Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Not getting all the data from AQL using jira Asset API

Anil Reddy Ailloni May 27, 2025

Hi All,

We are using below api to get the data from object_keys. But unfortunately we are getting partial data, not getting json file with these fields. 'NT Issue Key', 'IMEI', 'Device Status', 'Location', 'Inventory Location', 'Brands',
'Device Name', 'Device Type', 'Manufacturer', 'Model Number', 'Hardware Version',
'Device Tier', 'Chipset', 'Device Weight', 'Battery Capacity', 'Device Launch Date',
'eSIM Capability', 'Program', 'FUT Project Lead', 'FUT Project Name', 'Checked-Out To',
'ZIP Code Location', 'Tracking', 'Return Tracking', 'Attention Needed',
'Checked-Out thru DT Jira', 'Checked-Out thru NT Import', 'Usage', 'Initial TA Usage'.

 

Anyway to fix this issue. If I'm using API without aql getting 429 response as I'm calling api more than 40K times.
 

"https://api.atlassian.com/jsm/assets/workspace/{workspace_id}/v1/object/aql?includeAttributes=true"

 

payload = {
"qlQuery": aql_query,
"includeAttributes": True
}

response = requests.post(
paginated_url,
auth=auth,
headers={
'Accept': 'application/json',
'Content-Type': 'application/json'
},
json=payload,
timeout=60
)

2 answers

1 vote
Trudy Claspill
Community Champion
June 8, 2025

Hello @Anil Reddy Ailloni 

This is not an area of expertise for me. Please reconsider posting responses asking specifically for my help.

Posting responses to your own questions also increases the Answers count on your questions and removes them from the results of the Unanswered Questions filters, which makes them less likely to be seen by community members searching for unanswered questions on which to offer help.

For clarity, please state what programming language you are using.

Your code looks similar to the Python example, but is not quite the same.

https://developer.atlassian.com/cloud/assets/rest/api-group-object/#api-object-aql-post

1. Are you getting any objects in your results?

2. Are you getting any Attribute data in your results? I suspect not because have put the  includeAttributes parameter in the payload which doesn't match the example. 

 

 

0 votes
Anil Reddy Ailloni May 27, 2025

@Trudy Claspill Can you please help here, your last comment worked out - thanks.

Kate C_
Community Manager
Community Managers are Atlassian Team members who specifically run and moderate Atlassian communities. Feel free to say hello!
June 10, 2025

Hi @Anil Reddy Aillonithanks for your post! We ask that you wait at least 24 hours for a member of our community to reply to your question, before tagging particular individuals. We want to respect our Champions’ time and availability while also giving our members a chance to contribute. Thank you!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
ENTERPRISE
TAGS
AUG Leaders

Atlassian Community Events