Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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?

like image 364
Nirman Avatar asked Sep 30 '16 09:09

Nirman


2 Answers

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.

like image 90
TusharJ Avatar answered Oct 20 '22 18:10

TusharJ


Currently, there is a feature is Azure Logic App which can read Excel file from the given location.

Take a look at this blog - https://www.pmichaels.net/2018/04/22/what-can-you-do-with-a-logic-app-part-two-use-excel-to-manage-an-e-mail-notification-system/, it's written pretty well and should give you a heads-up about using the feature.

like image 24
Pratik Bhattacharya Avatar answered Oct 20 '22 17:10

Pratik Bhattacharya