Querying Accounts on Decisions

Hey there,

Yes, there is a query which you could use to potentially fit your use case. Performing the following query will return all associated details for all the accounts which exist in your Decisions instance:

select * from entity_account

For the most relevant information on the accounts (such as their actual email address and the type of the account they are using), you could use the following query:

select account_id, account_type, authentication_type, entity_name from entity_account

You could use these queries in any Raw SQL Step within a Flow. Do note that for larger data sets, this Step may not be the best fit performance wise for you use case.

In addition, there is also a way you can accomplish this using a Report with a Run Report Step. By creating a Report sourcing the Account Data Source, you can select similar fields as shown in the query above to get the same information.

You can then utilize a Run Report Step returning Data Rows to have the respective information available within the Flow.

Hope this helps!

-Cody