Forum Discussion

Boersieee's avatar
Boersieee
New Member
3 years ago
Solved

Web Contents with multiple RelativePath and Parameter

Dear all, I need some help with the following: when i call the API i'm using for my data, I need to use a parameter which is used by a other query. So in this case: I have a table with all our lo...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

     

    Instead of

    = (LocationID as number)=>
let
    Bron = Json.Document(Web.Contents("https://example.picqer.com/api/v1/locations/",
    [RelativePath=Number.ToText(LocationID),ProductsParameter="/products"])),

     

     

    Your code should look like 

     

     

    = (LocationID as number)=>
let
    Bron = Json.Document(Web.Contents("https://example.picqer.com/api/v1/",
    [RelativePath="locations/" & Number.ToText(LocationID) & "/products"])),

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

 

Instead of

= (LocationID as number)=>
let
    Bron = Json.Document(Web.Contents("https://example.picqer.com/api/v1/locations/",
    [RelativePath=Number.ToText(LocationID),ProductsParameter="/products"])),

 

 

Your code should look like 

 

 

= (LocationID as number)=>
let
    Bron = Json.Document(Web.Contents("https://example.picqer.com/api/v1/",
    [RelativePath="locations/" & Number.ToText(LocationID) & "/products"])),