In Logic App, sometimes we need to merge two Json arrays into one based on reference ID.
The normal way is to iterate one array -> filter the items with same ID in another array -> insert the items.
But there's another achievement to do it is using "Azure Monitor Logs" connector and pass arrays as dynamic content in the query which will be less time consumption and higher performance.
In Azure Monitoring query, we can not only retrieve the data which stored in the database, but also pass dynamic content into it and convert it as data table.
I have 2 Json arrays like following:
In this scenario, these 2 arrays need to be merged into one array which has id, displayName and userPrincipalName field.
We only need to create a Azure Monitor Log – Run query and list result action like following and pass these 2 json arrays as dynamic content:
After run the LA, we can get the merged array.
The values of type dynamic is limited to 1MB, so this workaround not support for handling large size data.
Thank you Drac for your sharing, very useful! @Drac_Zhang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.