CODEWITHSUNDEEP
azure-functionsazure-logic-apps
Nirman
Nirman

Reputation: 6783

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?

Upvotes: 6

Views: 18524

Answers (2)

Pratik Bhattacharya
Pratik Bhattacharya

Reputation: 3746

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.

Upvotes: 2

TusharJ
TusharJ

Reputation: 1263

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.

Upvotes: 7

Related Questions