Asset import with reference object

[Ismael]

Hi everyone,

I'm importing objects of the type Voice Service from a CSV file into Jira Assets. One of the columns (F) contains references to objects of the type Voice Technical Solution. These references are stored using an identifier from the "Voice Technical Solution" object, and when there are multiple references, they are separated by ||.

The attribute in Jira Assets is configured as an object reference, and I'm using the following AQL during import:

objectType = "Voice Technical Solution" AND "Identifier" IN "1"

The attribute Identifier is a text field. However, even when a row contains only one reference, the relationship is not created.

I’ve confirmed that the referenced objects exist and that the attribute is correctly defined. Has anyone encountered this issue or knows how to resolve it?

Thanks in advance!

[Jason U]

This usually happens because the AQL reference doesn’t match exactly or because multiple reference values in the CSV aren’t supported during import.

Try testing with a single reference value (no “||”), and confirm the attribute mapping uses AQL match.

If the single-value import works, you’ll need to add the multiple references later using a bulk update or the Assets REST API.

Reference: Atlassian Developer Docs – Insight REST API

[Ismael]

Identifier = ${voice_technical_solution} is the correct way, but with objects with multiple relationships in the CSV it is not support.