Forum Discussion

Neka's avatar
Neka
Icon for Helper III rankHelper III
2 years ago
Solved

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...
Need Help
pipelines
  • Neka's avatar
    Neka
    2 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.