Forum Discussion

tthierry's avatar
tthierry
Frequent Visitor
7 years ago

Launch multiple PUT API calls from a csv document

Hello

 

I have a bit of a challenge.

I have an excel file with two columns: a list of PUT APIs and their respective bodies. Each API and each body is different.

The APIs are structured:

PUT https://api.workflowmax.com/job.api/update/[id]/customfield?apiKey=[your API key]&accountKey=[WorkflowMax account key]

And the bodies are structured:

<CustomFields>
  <CustomField>
    <ID>5</ID> 
    <Text>some text</Text> 
    <ID>6</ID> 
    <Text>some text</Text> 
  </CustomField>
</CustomFields>

I would like to call these put APIs in order to update the data.

I thought about using https://docs.microsoft.com/en-us/powerquery-m/webmethod-put.

However, I am not super comfortable with it and don't really know where to start. A friend suggested to code this in Python but I am pretty sure there must be a way in PowerBI. Anyone who might be able to help please?

Need Help