Help

Invalid Offset Value

Topic Labels: API Scripting
Solved
Jump to Solution
1065 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Maurizio_polver
6 - Interface Innovator
6 - Interface Innovator

Hi there,

I'm facing this issue unfortunetly i checked on the community but none of the solutions work for me.

This is the error: "type" Invalid_Offset_Value - The value of offset 100 is invalid.

I'm trying to get 350 rows. I already did a first api call to get the first 100 rows, what i need is to continue with the second call.

When i try this url https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome everything work fine, when i use the same URL adding the offset value, i get the error: https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome&offset=100

What am i doing wrong? I can't work much on the code, i just can modify the URL. I've also tried to put the recordId instead of the "100" but i get the same reply.

 

Hope you can help, thank you very much

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

The offset isn't the number at which you want to start getting records I'm afraid, and is a value returned by Airtable in your initial call that looks something like this: itrloILUa4LWba21F/recreX96b1OkfThVj

And so in your context, it'd look something like:

https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome&offset=itrloILUaxLWba21F/recreX96bXOkfThVj

I'm sure you're already familiar with the documentation, and for future reference you can tell what kind of data to pass along by checking out the '<number>' and '<string>' bits!

Screenshot 2024-03-17 at 5.46.22 PM.png

 

See Solution in Thread

3 Replies 3

The offset value is a long string of letters and numbers that has to be taken from the response of your previous API call.

Look at your first API call, and at the end of the response, there will be an offset value returned to you.

Use that offset value for your next API call. 

TheTimeSavingCo
18 - Pluto
18 - Pluto

The offset isn't the number at which you want to start getting records I'm afraid, and is a value returned by Airtable in your initial call that looks something like this: itrloILUa4LWba21F/recreX96b1OkfThVj

And so in your context, it'd look something like:

https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome&offset=itrloILUaxLWba21F/recreX96bXOkfThVj

I'm sure you're already familiar with the documentation, and for future reference you can tell what kind of data to pass along by checking out the '<number>' and '<string>' bits!

Screenshot 2024-03-17 at 5.46.22 PM.png

 

Maurizio_polver
6 - Interface Innovator
6 - Interface Innovator

Thank you very much for your time.
Everything solved thanks to you