Parse CSV Which is a bulk file without using third party connector usinh logicApp

Lubdha Dolas 121 Reputation points

I want to parse csv input so that i can do the mapping. But we are not permitted to use third party software within azure logicApps. How do i do it? Its a bulky csv file.

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
3,699 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,546 questions
{count} votes

2 answers

Sort by: Most helpful
  1. MayankBargali-MSFT 63,511 Reputation points

    anonymous user Thanks for reaching out. Unfortunately, there is no official Microsoft connector that can help you to Parse CSV. You can always provide your feedback/suggestion here if this is something you want to be supported by official Microsoft connector.
    As @Ronen Ariely shared the reference document you can leverage the parse CSV action provided by plumsail.

    The workaround will be to create your own custom connector to achieve the Parse CSV functionality on your end. Alternatively, you can offload this functionality to the azure function which will take the CSV input and parse it as per your requirement using your custom code in any of the Azure functions supported languages. Once you have created the azure function you can leverage this document to call your azure function from the logic app.

    Sharing one of the sample code for CSV to JSON conversion.

    1 person found this answer helpful.
    0 comments No comments

  2. Ronen Ariely 15,066 Reputation points


    An action to parse CSV file is already existing in Logics App. The following tutorial can help to do what you ask for: