Forum Discussion
Lina_B
5 years agoRegular Visitor
Issue with pagination for airtable (no records)
Hello, I tried to apply the pagination formula to obtain more than 100 records from airtable in the power query. Unfortunately, the pagination does not work and I have no more records (I have the...
PhilipTreacy
Super User
5 years agohi Lina_B
I'm a little unclear on the results you are getting. You say you have no more records, and you have the names of all the columns but no records, yet you say you have 1 record = null?
Maybe if you shared an image of your actual results it would be clearer to me.
Using your code below to connect to my own Airtable account I successfully retrieve data.
Have you tried confirming that your API call below is actually returning data? You can issue a request directly in your browser like this
https://api.airtable.com/v0/BASE_ID/TABLE_ID?api_key=keyXXXXXXXXXX
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.