hello,
when i try to connect to this table :
with this query :
let Pagination = List.Skip(List.Generate( () => [Last_Key = "init", Counter=0],
each [Last_Key] <> null,
each [
Last_Key = try if [Counter]<1 then ""
else
[WebCall][Value][offset] otherwise null,
WebCall = try if [Counter]<1
then
Json.Document(Web.Contents("https://api.airtable.com",
[RelativePath="v0/"&#"BASE_ID"&"/"&#"TABLE_ID"&"?api_key="&#"API_KEY"&""]))
else
Json.Document(Web.Contents("https://api.airtable.com",
[RelativePath="v0/"&#"BASE_ID"&"/"&#"TABLE_ID"&"?api_key="&#"API_KEY"&"&offset="&Last_Key&""])),
Counter = [Counter]+1
],
each [WebCall]
),1),
the result is :
why is the Notes column ignored?
how can I change my M query to get all columns even if the first row was null?
thank you very much
