Hi everyone, we have a use case where we need to bulk query identities to find things like who has 2 Factor Auth enabled. This can be for a few hundred users at a time. I can only spot API endpoints to get an individual identity or all identities, but nothing where we can pass a list of identity ids. Is there something I'm missing, please? Thanks in advance for help.

We had to do something similar and ended up doing our own API with a SQL query in Kratos DB to retrieve the information

Thanks @loud-spoon-23770. So, that would rule out Ory Cloud.

oh yes sorry we are self-hosted

I'm quite surprised this feature doesn't exist, I thought it would be a common requirement.

well the product is still updated and evolving everyday so they will probably add this feature at some point I think @magnificent-energy-493 ?

For anyone finding this thread at some point, there is an open request here that I've found: https://github.com/ory/kratos/issues/2448

There is also https://github.com/ory/kratos/issues/249 from 2020 😅 However, I do understand the complexity mentioned in this comment.

Thanks @handsome-agency-20541. That request is asking for something a lot harder to achieve: fuller querying/filtering, GraphQL, etc. Where as, passing a batch of identity IDs to get multiple identities in one go is probably an order of magnitude or two simpler to achieve.

@loud-spoon-23770 we are looking into numerous approaches to this query type and a few others as well. Grpc, used for instance in #keto has very good performance. To implement this query type across the Ory landscape we need more time. Contributions are also welcome. Perhaps you could write up a description of your solution so we can make the information available to others in the community? @clean-motherboard-93658 perhaps you can open an issues with your specific use case in GitHub? Even though there may be redundancy or overlap with other issues, we benefit from every use case documentation. Please DM me if I can help further.

@microscopic-oyster-60915 I've added it thanks: https://github.com/ory/kratos/issues/3015