Forum Discussion

suebayes's avatar
suebayes
Resolver I
5 years ago
Solved

Json API with header details

I have a function that I’ve created that works with a JSON api with a query let Source = (RelativePath) => // function to add as a custom column to pull in relative path from table using the name o...
Need Help
  • suebayes's avatar
    suebayes
    5 years ago

    Hi Pat, I got it to work.  I'd tried putting it in as a parameter before but had neglected to change the parameter to a list type! So now when I put it in as a custom function within the column, I could then specify which column to use as the input and therefore which row.  A bit of an epic journey.

     

    ImkeF  I got it to work and learnt a lot 🙂

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

It looks like you are putting the relative path into the body of the web call in the last image, instead of putting it in the relative path option of the Web.Contents function.  Did you try concatenating the relative path into the url?

 

url = "https://*****/" & RelativePath

 

Pat

suebayes's avatar
suebayes
Resolver I
5 years ago

Hi Pat, I got it to work.  I'd tried putting it in as a parameter before but had neglected to change the parameter to a list type! So now when I put it in as a custom function within the column, I could then specify which column to use as the input and therefore which row.  A bit of an epic journey.

 

ImkeF  I got it to work and learnt a lot 🙂