Skip to main content
Solved

Invalid Offset Value

M

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

Best answer by TheTimeSavingCo

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!

 

View original
Did this topic help you find an answer to your question?

5 replies

ScottWorld
Forum|alt.badge.img+20
  • ScottWorld
  • Brainy
  • 8742 replies
  • March 17, 2024

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
Forum|alt.badge.img+18

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!

 

Adam, Consultant @ The Time Saving Co
M
  • Maurizio_polver
  • Author
  • Participating Frequently
  • 9 replies
  • March 17, 2024

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

B

@TheTimeSavingCo I'm using the Airtable Node SDK and the type for `offset` is `number` but it throws an error of "INVALID_OFFSET_VALUE". Passing a `string` also throws an error "Error: Airtable: invalid parameters for `select`".

Also, I don't get the `offset` string from the response when using the SDK.

Is it possible to do pagination with the SDK? I see there's a function for `.select().eachPage()` but I'm not sure how to use it to implement pagination.

If requesting via Fetch, I get the `offset` string from the response and I'm able to send it to the next request and get the next page, but how do I navigate backwards? I would need to store in a hash map ( { 0: null, 1: 'first_page/offset_string', ... } ) ?

 

M
  • mliu
  • New Participant
  • 4 replies
  • November 12, 2024
Maurizio_polver wrote:

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


Hi Maurizio, 

Can you help to share how you use the offset code to continue load 100+ records in Power BI?  I got 1st 100row, but have not clue at all about the next step for the remained rows.  Thanks! 

Reply


Most helpful members this week

Terms & Conditions