Create Jira Issues with a CSV Import that references Asset Objects

[Bernd Anderer]

I want to run a CSV Import to create Jira Issues. One field is linked to reference existing Jira Assets.

Question is - how can I create such  a CSV import file? It is only about how to provide a reference to an Jira Asset. The general setup of a CSV file is not a problem.

Which value goes in the Jira Asset field?

I created a Jira Issue with an Asset Object in it.  When I export the Jira Issue, I see a value like this in the Asset field : 67927907-xxx:467

1) I do not know that kind of value that is, and how/where to get it.

2) I tried to provide the Asset key value (e.g. RI-423) in the CSV which did not work

Does anybody know how I create such a CSV file?

[Manon Soubies-Camy · Accepted solution]

Hi @Bernd Anderer,

You can see here how to import Assets fields through CSV import: How to bulk update Assets Object custom fields via External System Import.

The export of a Jira issue gives you two things for the Assets field: workspace id and object id. In the example you mentioned:

• 67927907-xxx would be your workspace id (I edited it because I think it's best to not publicly share your workspace id)
• 467 your object id

If you want to import an issue with link to Asset object RI-423, it should work by providing the following in your CSV file:

67927907-xxx:423

Hope this helps,

- Manon

[Bernd Anderer]

Hi Manon,

thank you for your feedback - I'll go ahead and try that, sounds very promising :-)

Two more questions....

1. What exactly is a Workspace ID? 

2.  Where did you get such in depth information, I did not see that on Atlassian's website 😉 

regards,

Bernd

[Manon Soubies-Camy]

I went ahead and edited your initial post to remove your workspace id :)

1. Your workspace id helps identify your individual instance of Assets. It is mostly needed when working with APIs (more details here).
2. I've been working with Jira for a while now, I know what to search for to find the right documentation 😄

Let me know how it works!

[Bernd Anderer]

👍

It did work. Very cool :-) 

[Manon Soubies-Camy]

Glad it helped!