Skip to main content

Looking to Fetch More Than 100 Records from API

  • February 6, 2017
  • 1 reply
  • 15 views
A

My organization is currently visualizing Airtable data in Tableau by connecting our Airtable API to Google Sheets (using Blockspring) and then connecting Tableau to Google Sheets. This is working, but since no more than 100 records can be fetched from Airtable at a time, I have to break tables into several smaller tables through filtered views. Is anyone able to assist with fetching more than 100 records?

Thanks!
Allie

    1 reply

    S
    • Stephen_Hauck
    • Known Participant
    • 15 replies
    • March 1, 2017

    Allie, I have not used Blockspring but according to the API you will be able to request the “next” 100 records …

    Pagination
    The server returns one page of records at a time. Each page will contain pageSize records, which is 100 by default.

    If there are more records, the response will contain an offset. To fetch the next page of records, include offset in the next request’s parameters.

    EXAMPLE REQUEST
    $ curl “https://api.airtable.com/v0/apps0rEGuArV4yriZ/Customers?maxRecords=3&view=Main%20View”
    -H "Authorization: Bearer YOUR_API_KEY"
    EXAMPLE RESPONSE
    {
    “records”: [
    {
    “id”: “recegJbG1ewjXcqiW”,
    “fields”: {
    “Google Map”: “https://www.google.com/maps/place/2906+Azalea+Dr,+Greensboro,+NC+27407/@36.0297813,-79.844546,17z/data=!4m13!1m7!3m6!1s0x88531a3ce7eb116b:0x5f556747e4…”
    },
    “createdTime”: “2017-02-25T21:27:02.000Z”
    },
    {
    “id”: “recEDcOixf6kjF1MU”,
    “fields”: {},
    “createdTime”: “2017-02-25T21:27:02.000Z”
    },
    {
    “id”: “recrwZFn9VVsCitz1”,
    “fields”: {},
    “createdTime”: “2017-02-25T21:27:02.000Z”
    }
    ],
    “offset”: “recrwZFn9VVsCitz1”
    }
    Iteration may timeout due to client inactivity or server restarts. In that case, the client will receive a 422 response with error message LIST_RECORDS_ITERATOR_NOT_AVAILABLE. It may then restart iteration from the beginning.


    Terms & ConditionsAccessibility statement