Forum Discussion

tthierry's avatar
tthierry
Frequent Visitor
7 years ago
Solved

API Calls from column

Hi   So here is the challenge, I have an API in the format https://api.workflowmax.com/job.api/get/[id]/customfield?apiKey=[apiKey]&accountKey=[accountKey]   The ID changes for each job and jobs ...
Need Help
  • zoloturu's avatar
    zoloturu
    7 years ago

    Hi tthierry,

     

    I've tried this earlier. You need to follow below logic:

     

    let
...
PreviousStep = ... ,    

Step = Table.AddColumn(PreviousStep, "NewColumnName", each Json.Document(Web.Contents("https://api.workflowmax.com/job.api/get/" & [id] & "/customfield?apiKey=[apiKey]&accountKey=[accountKey]"))),

in Step

    Regards,
    Ruslan
    -------------------------------------------------------------------
    Did I answer your question? Mark my post as a solution!

zoloturu's avatar
zoloturu
Memorable Member
7 years ago

Hi tthierry,

 

I've tried this earlier. You need to follow below logic:

 

let
...
PreviousStep = ... ,    

Step = Table.AddColumn(PreviousStep, "NewColumnName", each Json.Document(Web.Contents("https://api.workflowmax.com/job.api/get/" & [id] & "/customfield?apiKey=[apiKey]&accountKey=[accountKey]"))),

in Step

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ruslan, 

I was looking for this exact same thing, but I'm a powerBI noob; where do you run this script? From a blank query? 

 

Thanks a lot! 

 

/Mari

  • tthierry's avatar
    tthierry
    Frequent Visitor
    7 years ago

    Hi Anonymous 

     

    Yes. Basically I created a function to call the API and I created a query that calls that function for each API that is created based on my database.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Did you have issues with the id being a number and the api a text? I have the same challenge that you initially had. 

       

      thanks!