How can I find the total number of accounts for a particular site or API Key?
384 Views 6 Helpful

Question

How can I find the total number of accounts for a particular site or API Key?

Product

  • Registration-as-a-Service (RaaS)
  • Profile Management (IDS)

Answer

The total number of accounts on an API Key can be found using one of the following methods: 

  • Using the Identity Query Tool[1] with the query below
  • Using the accounts.search[2] REST API endpoint for sites which have RaaS enabled with the query below
  • Using the ids.search[3] REST endpoint for site which have Identity Storage but not RaaS enabled with the query below

Any of the the methods above can be used with the following query to return the total number:

select count(*) from accounts

Note: Please refer to the article "How can I find the total number of accounts for a particular site or API Key if it is part of a site group?"[4] for more information on this topic in the context of a child site in a site group.

Links

[1]: https://console.gigya.com/Site/partners/SocializeReports.aspx#cmd%3Dgcs.queryTool
[2]: http://developers.gigya.com/display/GD/accounts.search+REST
[3]: http://developers.gigya.com/display/GD/ids.search+REST
[4]: https://knowledge.gigya.com/GKB_Article?id=a6H400000004DPVEA2

Was this article helpful?