Forum Discussion

jpt1228's avatar
jpt1228
Responsive Resident
5 years ago

API with basic authorization token comma expected error

Hello, I am trying to figure out my error in this API query. I want to add the page= as a variable outside of the base URL because I cannot schedule a refresh in the Power BI service with a dynamic s...
Need Help
Show and Tell
sayaliredij's avatar
sayaliredij
Solution Sage
5 years ago

Could you try this ?

 

(pagestart as text)=>

let
Source = Json.Document(Web.Contents("https://harvest.greenhouse.io/v1/jobs?", [Headers=[#"AUTHORIZATION"="Basic xxxxxx="]
,Query=[page="&pagestart&"]])),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "name", "requisition_id"})

in
#"Expanded Column1"

  • jpt1228's avatar
    jpt1228
    Responsive Resident
    5 years ago

    Hi sayaliredij that removed the error, but it doesn't appear to pass the function correctly to the base URL to change the page=1, then page=2 etc. The URL looks the same as the one that works for a single page but the %26 leading and trailing I believe are causing the error. Maybe I am not calling the function correctly?