How to import Insight references in CSV?

[Tim]

I have an object type with two references defined like this:

The color and shape objects are simply:

Using the following as input:

ashape,acolor,anobject,number
Square,Blue,Widget SB,1
Circle,Blue,Widget CB,1
Square,Red,Widget SR,1
Triangle,Green,Widget TG,1

I'm unable to populate the two reference type attributes using this import configuration:

The color and shape object types populate objects as expected, but the objects added to the Widget type does not import the referenced fields.  I'm assuming the Data Locator is the CSV column heading and that it should match the locator in the Object mapping IQL.  No errors are reported.

Thanks,

-tim

[Björn Gullander · Accepted solution]

Hi,

Try IQL mapping Name = ${ashape} 

Name is the attribute in the Shape object type you want to use to find the matching Shape object. 

label = ${ashape} should also work but without the plural s in labels. 

And likewise Name = ${acolor} 

[Tim]

Thanks Bjorn!!  

I guess I got hung up on JQL labels.  Curious there was no error generated.  I changed to label and all works as expected.

I will use label as that is what is documented here...

Create attributes and references from your data | Jira Service Management Cloud | Atlassian Support

Thanks again for your help!

-tim