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


Terms & Conditions