Forum Discussion
Combining API Call with two functions (including pagination)
Hi, I am trying to call an API in Power BI and have run into a roadblock. The API parameters only allow 1 site to be entered, so I have created Function 1 and invoked it on a site table (using sit...
Hi Anonymous ,
not sure I fully understand, but wouldn't you have t make the site dynamic like in the first function?:
(Offset as number, hostEmail as text)=>let
Source = Json.Document(Web.Contents("https://webexapis.com/v1/" & "meetings"
&"?hostEmail="&(hostEmail)
&"&max=100&offset="&Number.ToText(Offset),
[Headers=[Authorization=List.Min(#"Refresh Token (POST)")]])),
#"Converted to Table" = Table.FromRecords({Source}),
#"Removed Columns" = Table.RemoveColumns(#"Inserted Minutes",{"Custom"})
in
#"Removed Columns"
--------------------------------