Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
Then I think it would be easier to convert to Xml and use xPath.
It would be nice if JSONPath worked as expected.
Valid JSON Expression fails...why?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 84%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ3%3C/text%3E%3C/svg%3E)
Johns-305
16
Reputation points
@{triggerBody()[BatchedItems][?(@.messageId='6d2fba44-518c-42f3-befc-9ca61b08d65d')][content][$content]}
fails to validate with:
Unable to parse template language expression 'triggerBody()[BatchedItems][?(@.messageId='6d2fba44-518c-42f3-befc-9ca61b08d65d')][content][$content]': expected token 'LeftParenthesis' and actual 'RightSquareBracket'.".'.
The body is the Batched Items content. This is a valid expression, other JSON test tools recognize it, why doesn't Logic Apps recognize it?
The error message is beyond useless. As opposed to the fake Square Bracket? Do better.
Azure Logic Apps
-
VenkateshDodda-MSFT 25,251 Reputation points Microsoft Employee Moderator2022-12-27T08:49:43.96+00:00 @Johns-305 Thank you for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this. As per understanding the expression that you are using to pull the content of a particular messageId using expression is not possible. I am checking with my team internally on this.
Meanwhile could you please help us with the Sample Json and the output value you are trying to pull.
-
-
VenkateshDodda-MSFT 25,251 Reputation points Microsoft Employee Moderator
2022-12-28T06:07:14.367+00:00 @Johns-305 Thanks for sharing more information. As mentioned earlier the expression you are using to pull the content of particular messageId doesn't work and also i am checking with my internally on this as well. Meanwhile you can make use of either of the below.
- If you want to pull the content of a specific message Id from the received batch message, then you can make use of
for_eachloop and followed by compose action inside it and the expression will be in the below format.@if(equals(items('For_each')['messageId'],'6d2fba44-518c-42f3-befc-9ca61b08d65d'),true,items('for_each')['content']) - If you don't want to make use of the
for_eachloop you can use theFilter Arrayaction and followed byselectaction to pull the content for a particular message ID.
Feel free to reach back to me if you have any further questions on this.
- If you want to pull the content of a specific message Id from the received batch message, then you can make use of
Sign in to comment
1 answer
Sort by: Most helpful
-
Johns-305 16 Reputation points
2022-12-28T17:31:39.99+00:00 -
VenkateshDodda-MSFT 25,251 Reputation points Microsoft Employee Moderator
2022-12-29T05:09:58.767+00:00 @Johns-305 Thanks for your response. Yes, that could be another way to pull the content of particular message.
Sign in to comment -