Forum Discussion
SOAP Query - Passing parameters from another query to second query's M-Code
Hi, I have a SOAP service (Quinyx) to which I connect to via Power Query. The M-code that works in simple situations is presented below. The issue is, that the employeeId field is mandatory in t...
Have a table with your employee IDs. Add a column that constructs the payload for each of them. Add another column that calls Web.Contents on that payload. Process each response individually or union them together.
Hi lbendlin, apologies i didn't notice this thread had an answer. The idea itself seems ok, but I honestly have no idea how to accomplish this. I don't quite know how to reference "current row" in M. Do you have any references to some sort of guidance / tutorials / materials i could start studying to accomplish this? I'm pretty much lost on where to even begin.