Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help fixing this query

My query is:    let // Define GetCostManagementData function GetCostManagementData = (url as text, rows as list) as table => let QueryHeaders = [#"Content-Type" = "application/json", #"Authoriz...
Need Help
AlienSx's avatar
AlienSx
Super User
3 years ago

Hello, Anonymous 

recursion. So I would suggest to use @ 

in
if next <> null then
@GetCostManagementData(next, combinedRows)
else
Table.FromRows(combinedRows, columns)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Now, if I add @ at the begining as you mentioned, then it gives a different error: DataFormat.Error: Invalid URI: The hostname could not be parsed.

     

    Looks like it can't read the nextLink or something wrong with the condition