Import CSV into Table storage using logic app

asked 2021-04-19T12:14:02.807+00:00
Priya_108 21 Reputation points

Hi,

I am trying to import a csv file stored in a blob into an azure table using the logic app. I have set a trigger to identify an addition/modification in the blob and subsequent actions to get the blob content and store it in an array, however I'm not sure how to proceed from here.

Help would be much appreciated

Thank you!

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,803 questions
No comments
{count} votes

Accepted answer
  1. answered 2021-04-20T10:12:51.513+00:00
    MayankBargali-MSFT 49,446 Reputation points Microsoft Employee

    Hi @Priya_108

    Welcome to Microsoft Q&A! Thanks for posting the question.

    As you already had your CSV content in the array. You can loop in through each object in the array. The test that I have performed is using JSON object. You can also create the JSON object rather than an array when you reading the csv content.

    Once I have the JSON object now I am using Foreach loop to loop through each JSON value. Inside the foreach loop, you can use Insert Entity action to insert one JSON value at a time to your storage table as per your requirement. The Insert Entity action accepts the JSON value as below.

    Note: You need to define PartitionKey and RowKey whenever you are inserting the data to storage tables

    89476-image.png

    Hope the above helps. Feel free to get back to me if you need any assistance.

    Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.


0 additional answers

Sort by: Most helpful