Help using the Query APIs

Kurt Barnes

Looking at the new query APIs, I'm trying to understand if this will be able to solve a challenge I'm having. We're currently trying to pull Fundraiser Name for a list of constituents. Today I have to make individual calls for each individual constituent so 100s of constituents = 100s of calls. Hoping to create a query, pass in all the ConsIDs, and return all the Fundraiser Names.

Can someone give me some quick guidance on which API(s) to use? Thinking to start with Query Execution Job(ad-hoc)?

Also, is there any additional documentation somewhere that shows me possible values for filters like ‘query_type_id’

Finally, if anyone has any sample code for queries they've created, please share!

Alex Wong

@Kurt Barnes
there has been a few post on this topic already, you can check these out:

Dan Snyder

@Kurt Barnes
I was looking for this information too with the new RENXT Query Connector in Power Automate and you can get the query type id with the try it option for Get query type list.