Help

Data missing

2443 6
cancel
Showing results for 
Search instead for 
Did you mean: 
pracas
4 - Data Explorer
4 - Data Explorer

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. 

 

6 Replies 6

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

pracas
4 - Data Explorer
4 - Data Explorer

Hi, 

I'm missing records not whole fields. 

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_0-1718982881829.png

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",
},
"Created Date": "2024-06-10T17:13:02.000Z"
}
}, rest of the ID's API are not shown.

 

photo_2024-06-21_22-09-16.jpg

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 :

{
"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",
},
"Created Date": "2024-06-10T17:13:02.000Z"
}
},

Could you provide the full endpoint with the query params used?