To get all CosmosDB Mongo API collection using foreach and copy Activity

Girish13 1

I have 10 collection in CosmosDB with Mongo API and load in BLOB storage , I can able to do for 1 collection using copy activity but cant do for all collection as I have used for each activity but not able to get all collection name in for each activity.

I used getmetadata and lookup activity to get collection name but no luck.

Can you please help me out to get all collection name using for each activity and load data on blob storage using copy activity.

HarithaMaddi-MSFT 10,136 Reputation points

2020-10-23T12:52:31.94+00:00

Hi @Girish13 ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

As per the document, "Get Metadata" activity does not support retrieving information from CosmosDB. Alternatives can be to retrieve collections list using Azure Functions.

Please suggest if this aligns with the requirement or for further queries and we will be glad to assist.
HarithaMaddi-MSFT 10,136 Reputation points

2020-10-27T07:52:43.827+00:00

Hi @Girish13 ,

We have not heard any response from you. Please take a look at this document as an additional reference.

Do let us know for further queries and we will be glad to assist.
HarithaMaddi-MSFT 10,136 Reputation points

2020-10-28T15:29:17.497+00:00

Hi @Girish13 ,

We still did not hear back from you. Please let us know if above details helped addressing the requirement, share for further queries and we will be glad to assist.

Share via

To get all CosmosDB Mongo API collection using foreach and copy Activity