Skip to main content

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

Be the first to reply!

Reply