Forum Discussion
How include a value from the SetVariable activity that goes into the ForEach as part of the output?
Hello,
I have a SetVariable activity that has a JSON file going into my ForEach activity. Within the ForEach is a WebActivity1 that is using Workspace Id value from the SetVariable JSON file to call a Power BI REST API and get unused artifacts from that Workspace Id. There is another WebActivity2 after the first that saves the output of the WebActivity2 into a JSON file. I would like the Workspace Id value to appear before the Unused Artifacts that are found in that Workspace so that they are easier to find. How can I include the Workspace Id in the output from my ForEach?
This is what the pipeline looks like:
SetVariable (JSON file containing WorkspaceId) -> ForEach {WebActivity1(Uses WorkspaceId to find unused artifacts) -> WebActivity2 (saves unused artifacts into JSON)}
Thank you for your help!
Hello,
Thank you for your help but I ended up using a different strategy. However, I also discovered that using this expression in the body of the web activity brought in the Workspace Id that was entering the ForEach:
@concat('{"workspaceId":"', item().id, '", "unusedArtifacts":', activity('UnusedArtifactsWebActivity_copy1').output, '}').
I will leave it here, if anyone needs it.
6 Replies
Hi Neka ,
Thanks for using Fabric Community.
Inorder to do transformations ro your output json, can you use Copy Activity with Source as Rest API.
You can do some modifications to your json output with mappings option (like add columns).I hope you got some insights.
Hello again Anonymous ,
Do you mean to replace the WebActivity1 with the copy activity? How do you use a CopyActivity to access the RESTAPI?
Thank you.
Hi Neka ,
You can check for Rest in Copy Activity -
Or else if you can see the existing connection that created in Web Activity, try using it in Copy Activity.Hello Neka ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
Otherwise, will respond back with the more details and we will try to help .
