Azure Cosmos DB
An Azure NoSQL database service for app development.
1,632 questions
helllo to resolve my problem I've used the collect fucntion and then i create a file (json)
How to write a Json file from a csv file
![](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(96, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
CORONADO GRANADOS Diana Milena
126
Reputation points
Hello
I have got a csv file with an array inside, I need to create a sink data file(json) to be loaded within Cosmos DB, any idea about how to do it?
With the csv files i dont have any problem to upload within cosmosDb because I didn't have any array, but right now I have it!
{count} votes
-
![](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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,487 Reputation points Microsoft Employee2020-07-07T18:16:52.96+00:00 Hi @CORONADOGRANADOSDianaMilena-8538,
Thanks for reaching out. To better assist on your query, could you please share a sample source with dummy data (csv file)? If you are not comfortable in sharing it in forum, please feel free to email at AzCommunity@microsoft.com with below details.
- Subject of the email: <Attn - Kranthi : Microsoft Q&A Thread title>
- Thread URL: <Microsoft Q&A Thread link>
- Sample source data (csv file) attached.
- Sample - Expected sink data structure?
Please let me know here once you have done the same.
-
KranthiPakala-MSFT 46,487 Reputation points Microsoft Employee
2020-07-08T21:14:25.95+00:00 Hi @CORONADO GRANADOS Diana Milena ,
Following up to see if you have got a chance to see my previous response. If so could you please share the details as requested in my previous reply.
Thanks
-
KranthiPakala-MSFT 46,487 Reputation points Microsoft Employee
2020-07-10T06:13:22.35+00:00 Hi @CORONADOGRANADOSDianaMilena-8538,
Just checking to see if still need assistance on this query. In case if you have already found a solution, please feel free to share it here with community.
Thank you
Sign in to comment
1 answer
Sort by: Most helpful
-
CORONADO GRANADOS Diana Milena 126 Reputation points
2020-07-16T14:18:35.47+00:00