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

Question

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.

Answer 1

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.

Answer 2

Hi,

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

https://plumsail.com/blog/how-to-parse-csv-file