Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |