using power automate to get data from a web query

Ashley Gelderblom

Hello I am a proficient user of Power Automate, but not yet had a need to use web query. How do I get constituent system ids from a web query

Alex Wong

@Ashley Gelderblom
there are 2 ways you can play this

1. save a query (doesn't matter using dbview or webview), get the query id, and execute the query by id. Template available: https://community.blackbaud.com/forums/viewtopic/586/70161
2. execute ad-hoc query, meaning you don't have to use a saved query and can dynamically change how your query filter, output and sort. Template available: https://community.blackbaud.com/forums/viewtopic/586/66943
   • the template is a bit old now, as there is easier way to get query json definition: by starting to create a query in webview (don't need to save the query), do your “base” filter, output, sort and option, then in the Option tab, select to “Copy JSON” and then you can mess with the Query definition JSON in flow.

Ashley Gelderblom

@Alex Wong oh excellent- have got that working thanks alot