从表中查找并在Logicapp中追加字段 [英] Lookup from table and Append the fields in Logicapp

问题描述

我有从eventhub到logicapp的数据.现在，我想通过查找包含3个字段的单独表来丰富此数据.该表不是用SQL编写的，但我可以灵活地将其存储在LogicApp本身的适当数据结构中.

I have got data coming from eventhub to logicapp. Now I want to enrich this data by looking up a separate table which consists of 3 fields. The table is not in SQL or something, but I am flexible to store it in suitable data-structure in LogicApp itself. 

所以，现在我有2个资料来源.一个是来自Eventhub(json格式)，另一个是数据表包含3个字段(500条记录)

So, now I have got 2 sources. One is from Eventhub(json format) and another is the table of data consists of 3 fields(500 records)

我想使用一个公共字段在这两个源之间匹配数据.肯定会有一场比赛.匹配后，我想将第二个源(表)的其余2个字段追加到第一个源(eventhub的数据).比赛将是一对一的 自然，意味着没有重复.

I want to match the data between these two sources by using one common field. There will be definitely a match. Upon match I want to append the remaining 2 fields from 2nd source(table) to first source(data from eventhub). The match will be of one-to-one nature, means no duplicates.

解析后，数据将发送到日志分析.

Upon the parsing, the data will be sent to log-analytics. 

从扩展角度来看，我将每3分钟从eventhub到logicapp获取大量数据.

From the scaling point of view, I will be getting data lot of data from eventhub to logicapp every 3 minutes. 

请向我建议使用logicapp进行此工作的正确方法.我需要编写函数吗?

Please advise me the right approach for this work in logicapp. Do I need to write function ?

推荐答案

您可以使用函数，也可以使用compose形状并在其中添加json.请找到以下示例之一

You can use Functions or you can use the compose shape and enrich your json in it. Please find the below one of the example

https://social.technet.microsoft.com/wiki/contents/articles/51608.vlookup-scenario-in-azure-logicapps.aspx?Redirected=true

https://social.technet.microsoft.com/wiki/contents/articles/51608.vlookup-scenario-in-azure-logicapps.aspx?Redirected=true

您可能需要两个方法的执行时间以及逻辑应用程序中要执行的操作数，然后才能做出决定.

you might need to execution times on both the methods and also the number of actions executing in the logic app and make the decision.

这篇关于从表中查找并在Logicapp中追加字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！