odata query in Azure Logic App giving null value

Question

I am trying to access an integer value from CRM Entity using Parse JSON in Logic Apps. It is returning a null value instead of an integer value.

"territoryinteger": "@{items('For_each')?['[email protected]']}",

Any help is appreciated. Thanks

Answer 1

If you look at the Runs History (under the Logic App Overview) and drill down to the Get Record or Get List action block, you can see the output of the JSON retrieved and you can visually verify that the query is returning a value.