如何在Azure逻辑应用程序中将电子邮件附加CSV文件内容存储为变量 [英] How to store email attach csv file content as variable in azure logic app

问题描述

我得到一个csv文件作为电子邮件附件.我需要一种方法来读取电子邮件附件并将该附件另存为变量，或者直接读取附件文件内容并获取数据或存储在blob存储中.(如果csv文件保存在blob中，我们如何阅读它.)

I get a csv file as email attachment.I need a way to read email attachment and save that attachment as variable or directly read the attach file content and get data or store in blob storage.( If csv file save in blob , how we can read it. )

注意-这个csv文件包含有关系统进程的数据.我只想从附加的csv文件中获取yes进程，然后继续集成.入职流程|是的计费过程|否

note - This csv file has data about system processes.I want to get only yes process from the attach csv file and continue the integration. ex- onboarding process | yes billing process | no

推荐答案

对于您有关"如果csv文件保存在blob中，我们将如何读取"的要求，我可以为您提供解决方案参考，请参考以下步骤:

For your requirement about "If csv file save in blob , how we can read it", I can provide a solution for your reference, please refer to the steps below:

1..我的Blob存储中有一个csv文件，其内容如下所示:

1. I have a csv file in my blob storage and its content show as below:

item,date,process
1,2020-01-01,yes
2,2020-01-01,no

2..使用"

3..在逻辑应用中搜索解析CSV"操作.

3. Search the action "Parse CSV" in you logic app.

它将要求您输入"API密钥"，您需要先转到复制机密并将其粘贴到您的逻辑中，它将使您能够连接Plumsail.

It will ask you to input "API Key", you need to go to this page first --> click "Start free trial", register an account and create a new API Key. Copy the secret and paste it to your logic, it will allow you to connect Plumsail.

4..在框中输入文件内容"和标题，我们还可以添加一个新参数跳过第一行"并将其设置为是"(此参数将跳过标题并避免在Expect表中使用两行标题).

4. Input the "File Content" and the headers into the box, we can also add a new parameter "Skip first line" and set it "Yes"(this parameter will skip the header line and avoid two lines header in the expect table).

5..然后，您可以循环执行解析CSV"操作中的正文"，并使用如果"条件来判断进程"是是"还是否"，然后在每个分支流中执行您想要的操作.

5. Then you can loop the "Body" from "Parse CSV" action and use a "If" condition to judge if the "process" equals "yes" or "no", and do what you want in each branch flow.

希望有帮助〜

这篇关于如何在Azure逻辑应用程序中将电子邮件附加CSV文件内容存储为变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！