Offset value invalid; output does not match API documentation
Hello,
I am trying to build a query in Power Query/Power BI to load an Airtable table into the data model. I have found some working code which uses the offset parameter returned by the API to deal with the pagination.
However, the offset value returned does not match the API documentation and gives an error when I try to parse it.
According to the API docs, the offset should look like this:
"offset": "reco1XxXxXxXxXxXxXx"
However, what I get is this:
"offset":"itrZXxXxXxXxXxXxXxXx/rec5XxXXXxXxXxXxXx"
When I parse the value into the URL, using &offset=itrZXxXxXxXxXxXxXxXx/rec5XxXXXxXxXxXxXx, I get the following error:
{"error":{"type":"LIST_RECORDS_ITERATOR_NOT_AVAILABLE"}}
When I try passing either of the values (before and after the /), then the error is:
{"error":{"type":"INVALID_OFFSET_VALUE","message":"The value of offset itrZXxXxXxXxXxXxXxXx is in
