How to find an Jira assets object id based on some attribute like email or username via API call?

[Wendy Wei]

Hello,

I need to update a jira user object under assets via API call.  How do I find the user object id based on username or email via API call?

Any suggestion or idea is highly appreciated.

Thank you

Wendy

[Gikku]

@Wendy Wei Below steps should get you accomplish the requirement.

1. Use the AQL api Post object aql to first retrieve the asset object to be updated
   The AQL query should specify the object schema and object type to be searched for, along with the attributes to be matched (username or email)
2. Once you have the object returned, use the objectKey value to update the object via Put object {id} API.

[Wendy Wei]

@Gikku thank you for the information. However, I cannot get expected result using below url, it still retrieve 25 users as pageObhectSize, not just the specific one:

https://api.atlassian.com/jsm/assets/workspace/XXXXXXXXX..../v1/aql/objects?qlQuery=objectschemaId=4&objectTypeId=6&username="Wendy.Wei@xxx.com".  In addition, i got 405 method not allowed error when using either post or put.  but using Get does return results, just not a single result.  

Any idea?

[Wendy Wei]

@Gikku any suggestions?

thanks,

Wendy

[Gikku]

@Wendy Wei The query should be corrected as 'objectSchemaId' and you can also verify the results by running the same search from the UI to see if you are getting the intended results. 

Here is a sample code that I am using with Scriptrunner.

*******

def ASSETS_WITH_TAGS_AQL = 'objectSchemaId=1 AND objectTypeId=2 AND Tag IS NOT EMPTY'

def getDevicesWithUsername = {
post("https://api.atlassian.com/jsm/assets/workspace/${WORKSPACE_ID}/v1/object/aql?maxResults=10&includeAttributes=false")
.basicAuth(ASSETS_ACCOUNT, ASSETS_TOKEN)
.header('Content-Type', 'application/json')
.body([qlQuery: "${ASSETS_WITH_TAGS_AQL}"])
.asObject(Map)
.body
.values as List
}

[Wendy Wei]

@Gikku 

thank you very much for your information. I was able to use below to retrieve the specific object using label, instead of username.

However, I am having issue with create an asset object using below:

https://api.atlassian.com/jsm/assets/workspace/xxxxxx/v1/object/create, i am getting 401 unauthorized error but it wa confirmed the user making the connection does have write permission.  I am not sure exact what parameters I should be using.  is basic authorization correct? useraccount: password? or username: apitoken when making connection?

thank you very much!

Wendy

[Gikku]

@Wendy Wei Try using the API token for the script. Basic auth is fine. 

[Wendy Wei]

@Gikku 

I tried to use:

username:APItoken

then applied base64 code on this string, and use it on header as:

Authorization: Basic base64encoded of username:APItoken

Content-Type: application/json

still threw 401 error.

anything else I am missing?