Data missing

pracas · ‎Jun 18, 2024

Hi,

I've been testing Airtable to create a visual database system for skilled professionals in Nepal. While fetching data from Airtable API to my APP, I hardly get all data.

Few of my data are missing. I have tested it using postman.

TheTimeSavingCo · ‎Jun 18, 2024

Are you missing records or specific fields? Could you provide an example API call and a screenshot of your data?

Adam, Consultant @ The Time Saving Co

pracas · ‎Jun 19, 2024

Hi,

I'm missing records not whole fields.

kuovonne · ‎Jun 20, 2024

Are you using filterByFormula? Are you using the pageSize or maxRecords parameters? Are you asking for records in a particular view? All of these things can affect how many records are returned.

NirajanDahal · ‎Jun 21, 2024

Above is the screen shot of Data's except ID: 225 are missing.

Here is an API of ID:225

{

"id": "recEaS9JzSzzkCEtb",

"createdTime": "2024-06-10T17:13:02.000Z",

"fields": {

"First Name": "Dipendra ",

"Last Name": "Chaudhary ",

"Phone": "9779812351276",

"Profession": "Carpenter",

"Active in App": "Yes",

"City": "Biratnagar",

"ID": 425,

"Ward #": "11",

"Payment": "No",

"Top Pro": "Yes",

"WhatsApp Ac": "No",

"Working Hours": "10:00 AM - 05:00 PM",

"UIN": 376,

"Gender": "Male ",

"Email": "9779812351276@sriyog.com",

"Created By": {

"id": "usrROSHARE0000000",

"email": "anonymous@noreply.airtable.com",

"name": "Anonymous"

},

"WhatsApp": {

"label": "WhatsApp",

"url": "https://api.whatsapp.com/send?phone=9779812351276"

},

"Created Date": "2024-06-10T17:13:02.000Z"

}

}, rest of the ID's API are not shown.

NirajanDahal · ‎Jun 21, 2024

I have filtered those four records according to Yes/No values as in the right end of above screenshot. Record having ID 425 is only shown and rest of the records are missing in API as well. With the same filter it worked for other records.

Here's the API of ID 425 :

{