Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Insight IQL API return dynamic attributes (without empty ones)

Hi,

We have problems with requesting Insight API trought curl and jq.

curl -sk "https://jira/rest/insight/1.0/iql/objects?objectSchemaId=1&iql=objectTypeId=16%20AND%20UUID%20is%20not%20empty&resultPerPage=10000" -u $USER:$PASS | jq -r '.objectEntries[]|[.attributes[].objectAttributeValues[].displayValue]|@csv'

Results not showing attributes with empty values in the same columns and csv file is "broken".

All attributes are inherited from parent "abstract" object.

For example attributes[13] on one object return "objectTypeAttributeId 28"

2020-09-24 10_47_18-.png

and on another object return "objectTypeAttributeId 26"
2020-09-24 10_47_12-.png

Is there any option to generate all attributes even if they are empty?
Or maybe we could get only few attributes by attribute ID/Name?

I've found API request parameter "orderByAttributeId" that could help but it's deprecated. https://documentation.mindville.com/insight/5.4/insight-advanced-usage-guide/insight-for-developers/insight-rest-api/version-1-0-documentation/iql-rest

Insight version 8.6.6

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: Fine Software

Happy New Year, everybody! What better way to kick off 2022 than with a new Marketplace Partner Spotlight ✨ This month, we're getting to know Daniel Franz, co-founder of Fine Software. Fine Software ...

372 views 2 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you