Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 15, 2022 02:51 AM
Using:
"https://api.airtable.com/v0/app key/Interview%20Data
-H “Authorization: Bearer YOUR_API_KEY”
API to fetch all the records, some of my records are missing
Sep 15, 2022 03:06 AM
Welcome to the community, @khushbu!
When you fetch records from the API, it will only return the fields that have data in them.
Sep 15, 2022 03:27 AM
Thanks for reply @ScottWorld
not getting about 10-20 records
api called:
https://api.airtable.com/v0/appkey/tableid
Sep 15, 2022 03:36 AM
First, you said that fields are missing.
Now, you’re saying that records are missing.
And your screenshot doesn’t explain anything.
It seems like this is Liam spamming us here in the forums again, but using a different username.
Sep 15, 2022 03:47 AM
I’m using API call to fetch the all records.
Explanation of my issue, assume the following data.
table-1 contains 300 records, with Field-1 containing data “A”, “B”, “C” , etc… respectively.
make a List GET call and it retrieves only 270 records with correct values in Field-1.
but 30 records are missing.
Sep 15, 2022 05:11 AM
What are you trying to accomplish with the API? Are you a consultant, student, hobbyist, accidental coder, hacker, etc.?
How familiar are you with Airtable? Do you have an Airtable account? Can your account access the base? How do you know how many records are missing? Do you know what data is in the missing records? Can you share a screenshot of the records in Airtable?
What is your level of experience working with REST APIs and writing code? What language / platform are you using? Are you using a library?
The API documentation is quite good and explains the endpoints, authentication, and many other things. Have you looked at it?
Sep 15, 2022 07:03 AM
In your original post (before it was edited) the URL you shared indicated that you were querying from a specific view. If that view had a filter that prevented some records from being shown, that would explain the missing records.