using power automate to get data from a web query

@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.