This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 19%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Hi Experts,
I am trying to store the web activity response, success, and error to Cosmos DB in two containers (error log and success log containers) from an ADF pipeline. I am struggling to figure out how to approach this. Can someone guide me on how to proceed? I would greatly appreciate any help.
Scenario: Storing web activity response, success, and error to two separate Cosmos DB containers from an ADF pipeline.
Hi Satish,
This is what my current solution looks like, I am using copy activity with a source as a dummy data set and in the sink using cosmos DB dataset.
This solution works but, I am looking for a more systematic solution than this.
Data flow usage is not allowed, due to some security reasons.
This is what my current solution looks like:
Here I am using copy activity to pass the data to cosmos DB, where I am using a dummy dataset and passing the response of web activity to DB via variable.
This solution works but is there any better way?
Dataflow usage is not allowed because of some security reasons.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
Hello @Kunal Pagare Thanks for sharing the more context.
Your Workflow looks good,
Any error message do we see in the logs?
Hello @Kunal Pagare Just checking if we are still connected on this discussion? Could you please share any logs you have seen with any errors in your pipeline run?
Hello @Kunal Pagare,
Welcome to QnA forum, Happy to help you on this query!
Could you please add more info on your ADF pipeline how does it look like?
What are the Actions used in your Pipeline?
Any Error message? Any If Condition used?
Did you try to use Dataflow? for any conditional split?
Yes, You are doing the right way to capture the web-activity's output.
Hello @Kunal Pagare Did you get any resolution or still looking for the alternate solutions?
Are you able to use the HTTP Connector in the Source for the data?
Yes, You are doing the right way to capture the web-activity's output.
This solution works for me. Thanks.
I was looking for a solution where I don't have to use copy activity with a dummy dataset to save data to cosmos DB.
Hello @Kunal Pagare Thanks for the response, Please click "Accept Answer" . So that we can close this case.
Hello @Kunal Pagare Please click "Accept Answer" . So that we can close this case.