How to get less records in webapi and also get the offsett

[mike16]

Hello there,

https://api.airtable.com/v0/appycQyQBCRaFT2aD/Tebi-Category-Test?maxRecords=110&view=Grid%20view
I'm using this API to get the my table's data and after that I will process this into my CMS and then to fetch next records there is offset which I'm using to get another records. 

Since the records are more than 100 server might get out so I tried to get less records like 10 but offset is not there in the response.

so can someone help me to get less records and also the offset in it ?
Thank you.

[ScottWorld]

There are 2 different ways of handling this:

1. You can write your own custom JavaScript scripts to do that.
or
2. You can use a no-code automation tool that doesn’t require any knowledge of programming code at all.

Personally, I don’t know JavaScript, so I go with #2 myself.

I use and I highly recommend Make’s Airtable automations and integrations.

You would just need to use Make’s Airtable - Search Records module to search your Airtable records, and Make will automatically handle all the offsets for you.

Make will also let you specify the maximum number of records you want to retrieve and the sort order of the records.

Make will also automatically loop through all the records for you, so you can handle each one separately when sending them to your CRM.

If your CRM isn’t natively supported by Make, you can just use Make’s HTTP module to send your own custom API calls to your CRM.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread: https://air.tableforums.com/t/make-com-basic-navigation-tips/277

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances here: https://www.youtube.com/playlist?list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1

For example, in this video, I show how to work with Airtable arrays in Make.
https://www.youtube.com/watch?list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1&v=sKPyG0HZCYY

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld 

[kuovonne · Accepted solution]

MaxRecords sets the total number of records you will get. If you want fewer records per call, set the page size.

[TheTimeSavingCo · Accepted solution]

As kuovonne said, try pageSize, so your URL would just be:

https://api.airtable.com/v0/appycQyQBCRaFT2aD/Tebi-Category-Test?pageSize=10&view=Grid%20view

[mike16]

Thank you it worked.

[mike16]

Thank you so much for this.