I’m trying to retrieve all the records in a table with curl over HTTPS.
I checked the table I’m targeting, and it has 283 records. I imagine I’ll need to issue three requests, since each request returns a maximum of 100 records.
I piped the results of my first
curl command into a new file called
output.txt and then tried to find the
offset value from within the curl output file.
However, when I search through this file, I can’t find an
offset value anywhere within the JSON like I expected, based on this line in the documentation:
If there are more records, the response will contain an
Is there something obvious that I’m missing… I feel like there has to be. If anyone knows how I can get this
offset value so that I can use it to request the next page of records (and the one after that), I’d be super grateful. :slightly_smiling_face:
Sure! Thanks for your help, Kasra!
Here’s the full command I’m using, with random values for the API key, app name, field names, etc. Turns out I’m piping to items.json, which makes more sense than output.txt. :slightly_smiling_face:
curl "https://api.airtable.com/v0/appmwKq8r6WDyWnKS1/Items?maxRecords=100&sort%5B0%5D%5Bfield%5D=sequence_number&sort%5B0%5D%5Bdirection%5D=asc&fields=fk_order_number&fields=remarks" -H "Authorization: Bearer keymwKq8r6WDyWnKS1" > items.json