Skip to main content

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. 

 

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

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.

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


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.

 

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.


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"
}
},

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.

 


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

Reply


Terms & Conditions