Query API - Get Query results - output JSON

Sarah Homan

I am using Ashlye Moose's Get Query results from new Query API template, but I want the output to be JSON so I can send an email with a table of results.

I added output_format = “Json” to the executebyid per the documentation

But when I try to parse the HTTP - Get Query results I get this error.

After the Get query results, I added a compose action, and it “looks” like JSON.

Thank you in advance for your assistance.

Glen Hutson

Hi @Sarah Homan,

I was running into the same issue as well until I wrapped the HTTP - Get Query results in a json expression.

json(body('HTTP_-_Get_Query_results'))

Though if you start off in the expression editor, you should be able to select the output from the Get Query results directly instead of having to type it out.

Similar to this (but not exactly as this example is from an FENXT Query):

Alex Wong

@Sarah Homan
My answer to this post will answer how you work with JSON output:

Sarah Homan

@Glen Hutson
I knew it would be something simple. Worked! Thank you.