AQL API Search if the user exist with the email id

[Premasiri, Hari]

Hi All,

Can someone help me to correct the below API, I am searching in Atlassian Asset if anybody exists with an email = test@test.com

https://api.atlassian.net/jsm/insight/workspace/{{workspace_ID}}/v1/iql/objects?objectSchemaId={{Schema_ID}}&iql=Email=test@test.com

Thank you

[Premasiri, Hari · Accepted solution]

Figured out. URL (api.atlassian.com)should end with .com not .net

https://api.atlassian.com/jsm/insight/workspace/{{workspace_ID}}/v1/iql/objects?objectSchemaId={{Schema_ID}}&iql=Email=test@test.com

[Premasiri, Hari]

Hi @Benjamin 

I am using it on Postman and I getting 404

[Benjamin]

Hi @Premasiri, Hari ,

This article should give guidance on executing the Asset API using AQL.

https://community.atlassian.com/t5/Jira-Service-Management/Using-the-AQL-API-to-query-assets/qaq-p/2190698

-Ben

[Premasiri, Hari]

hi @Benjamin  as I am new to the API, I cannot figure it out. how to construct 

[Benjamin]

Hi @Premasiri, Hari ,

It depends where and how you execute the query. 

Would try this first:

https://api.atlassian.net/jsm/insight/workspace/{{workspace_ID}}/v1/iql/objects?qlQuery=objectSchemaId={id} and Email=test@test.com

If you are doing a curl query, you may need to encode it like what is mention in the article.

-Ben