Help

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

Solved
Jump to Solution
602 1
cancel
Showing results for 
Search instead for 
Did you mean: 
mike16
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

mike16_0-1710416484393.png

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

2 Solutions

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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

See Solution in Thread

TheTimeSavingCo
18 - Pluto
18 - Pluto

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

 

See Solution in Thread

5 Replies 5
ScottWorld
18 - Pluto
18 - Pluto

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
18 - Pluto
18 - Pluto

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

TheTimeSavingCo
18 - Pluto
18 - Pluto

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
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you it worked.

Thank you so much for this.