Access blob storage through azure logic apps

0
votes

I have Azure blob storage, which contains some CSV files. My task:

1. Create a logic app for the blob storage.
2. Retrieve the data from the blob storage.
3. Convert the retrieve file to JSON.
3. Upload that data to an online portal through API.

I've tried retrieving the data by "Get blob content" action, but not sure where to see the result. I have just created the logic app, but I'm stuck on what to do next.

1
azureazure-storage-blobsazure-logic-apps

1 Answers

1
votes

This is the output of get blob content. Is there any way to convert this output to JSONFor your question about

I've tried retrieving the data by "Get blob content" action, but not sure where to see the result.

When you run the logic app, you can see the content of your csv file in the OUTPUTS, shown as below:

enter image description here

If you want to use an api to upload the data, you just need to do the operation like below screenshot(but it also depends the type of your api's request body) :

enter image description here

Since you mentioned your azure storage blob contains some csv files, so maybe you need to loop the files. You can use "List blobs" action and "For each" action to loop them and then get blob content.

enter image description here

Hope it helps, if you have any further problem, please let me know.