How to read a CSV file line by line in Azure Logic App?

azure-functions azure-logic-apps
Nirman picture Nirman · Sep 30, 2016 · Viewed 11.1k times · Source

I have an Azure Logic app which picks a file from the Sharepoint site. In the next step, I want to parse the file contents to read them line-by-line and to pass each line in an Azure function I have already created.

At this stage I am unable to fetch and loop through each line of the file. I can get the complete file only.

Any suggestion on how to achieve this?

Answer

TusharJ picture TusharJ · Oct 5, 2016

As of now there is no out-of box connector or function in LogicApp which parses a CSV file line by line. You can always vote for new features feedback.azure.com/forums/287593-logic-apps?query=CSV

  1. You will have to pass the whole content to the Azure Function that you already have and perform the necessary operation on it

    Or

  2. There is a CSVToJson connector available in LogicApps github repo to use

https://github.com/logicappsio/CSVtoJSON

Not officially supported but should be able to use it.

Related questions

Azure Functions vs. Logic Apps

Functions & Logic Apps are two distinct offerings by Microsoft Azure. I wonder what are the use cases that one should favor the new Functions offering over Logic Apps.

Read More
Parse text in Azure Logic Apps

I want to create Azure Logic App which will constantly request a specific website on the Internet and parse received HTML. I've created Logic App and set up interval and HTTP request action. Which action should I choose as the …

Read More
How to pass parameters by POST to an Azure function?

I'm trying to do a simple Azure Function to learn about it. There will be 3 functions: 1 function to insert a row into a table of a database. This table will contain the current date and a string parameters typed by …

Read More