Help

Power bi ignore some airtable table columns

Topic Labels: Sync
418 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Alireza_Mohamma
4 - Data Explorer
4 - Data Explorer

hello,
when i try to connect to this table :
000100

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 :
000101

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

0 Replies 0