Launch multiple PUT API calls from a csv document

[tthierry]

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?

[ImkeF]

For some strange reason, that documentation contains functions that you actually cannot use in Power Query. That function is one of them: https://social.technet.microsoft.com/Forums/security/en-US/ad808464-8819-45ac-a015-b53938095aae/how-... 

So Python is probably the best solution then.