nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using the AQL API to query assets

Wade H

Can anyone guide me on using an aql query to get a list of asset objects?
right now i am trying this:
/v1/aql/objects?objectSchemaId=5&objectTypeId=15

however it does not narrow down the return of just the objects that have an objectTypeId of 15.

thanks,
-wade

Accepted answers

Wade H

In case anyone is interestred this is what I got to work

/v1/aql/objects?qlQuery=objectSchemaId=5 and objectTypeId=15

All comments

Wade H

In case anyone is interestred this is what I got to work

/v1/aql/objects?qlQuery=objectSchemaId=5 and objectTypeId=15

Iker Gómez Eiras

My god, THANK YOU!!

The absolute lack of query examples in the official documentation is frustrating to the point of anger, specially since in IQL the objectSchemaID had to be specified before the actual query.

Thank you, thank you, thank you!!

Wade H

you are welcome!!

Paul Hecker_60magh

Hello Wade,

First, and most importantly, "Thank you!" for your post. It was the only information I could find referring to the use of the "qlQuery" REST API option.

For anyone else searching, with the assistance of Atlassian Support I was able to sort out my AQL query and perhaps someone may find it useful as well.

I was trying to use the REST API to run a Curl query against the Assets CMDB to find objects that met a criteria where the Serial Number attribute started with a specific text string.

EX: objectSchemaId = 7 AND objectTypeId = 22 AND "serial number" startsWith emea

The short answer was that I did not encode my query properly to be used in a URL. Where ""https://api.atlassian.com/jsm/assets/workspace/{workspaceId}/v1/aql/objects?qlQuery=objectSchemaId = 7 AND objectTypeId = 22 AND "serial number" startsWith emea"" did not work, ""https://api.atlassian.com/jsm/assets/workspace/{workspaceId}/v1/aql/objects?qlQuery=objectSchemaId%20%3D%207%20AND%20objectTypeId%20%3D%2022%20AND%20%22serial%20number%22%20startsWith%20emea"" did work.

I hope others find this information helpful.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

insight

jira-service-management-cloud

jira-service-management