Query API - Get Query results - output JSON

Sarah Homan
Sarah Homan
Tenth Anniversary Name Dropper Participant Facilitator 1
in SKY Developer General Discussions

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

0016329d0dced221debbf2d4c8130f08-huge-im

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

777c7c2d1764b6d2ee3e11933a019d48-huge-im
4c9ff60f9cdc283bda02d5b537321748-huge-im

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

fd9102a2fbc5f0ca09140abdd2228715-huge-im

Thank you in advance for your assistance.

Tagged:

Comments

  • Glen Hutson
    Glen Hutson Blackbaud Employee
    Tenth Anniversary Kudos 5 2026 K-12 User Conference Attendee First Reply

    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):

    814b0ad95c133a2478d745ce626a6b85-huge-im
  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Facilitator 5 Kudos 5 bbcon 2025 Attendee Badge

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

  • Sarah Homan
    Sarah Homan
    Tenth Anniversary Name Dropper Participant Facilitator 1

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

Categories