'Azure Logic Apps: How to use variables in a dynamic query?

Trying to add values from the JSON Parser into a dynamic Oracle query but always shows up as blank/empty.

Same results trying to use the formal parameters and declaring them within the Oracle query as well.

Is this possible?

Service Bus trigger. Message comes in and goes into the "For each message" loop. It then gets parsed in the "Parse JSON Message" and when I try to use the dynamic content from that in an Oracle query (e.g. @body('Parse_JSON_Message')?['contentData']?['dynamicValue']), they always show up as nothing/blank.

I can use this same reference later (again @body('Parse_JSON_Message')?['contentData']?['dynamicValue']) with no issues but it always ends up blank in the query.

Even using formal parameterized key values shows the @body('Parse_JSON_Message')?['contentData']?['dynamicValue']) to be NULL.

So my queries are coded as:

SELECT thisValue
WHERE columnName = @body('Parse_JSON_Message')?['contentData']?['dynamicValue'] (have also tried @{body('Parse_JSON_Message')?['contentData']?['dynamicValue']})

But are coming out as:

SELECT thisValue
WHERE columnName = 

...with no result obviously.

This query does work if I hard code the value.

If I use dynamic values in my output (where I'm mapping data), it works fine. So how should I correctly dynamic values in this Oracle query?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source