Forums

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

How to update an existing .json imported schema with delta data.

Derek Low
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 9, 2024

I have an existing JSM Asset Management Schema that was created and populated using a .json data set.

Each object has several linked objects with both inbound and outbound references.

I need to refresh the schema to include new objects in the existing object type whilst retaining the integrity of the data in that object type. The new data is also in a .json format and will be imported through the importer.  

I have tried this approach:

https://confluence.atlassian.com/jirakb/how-to-update-the-existing-objects-using-the-csv-import-in-assets-1299914393.html

The problem is the import creates a new object type, without updating the existing one with only the deltas, and of course, all of the linked objects no longer exist in the newly imported object type. 

 

Basically, I wasn't to update an existing object type, with new (delta) .json objects whilst retaining the integrity of all the existing objects. 

2 answers

0 votes
Pedro Arroyo May 24, 2024

Hi,

I can speak from my experience using Assets and External Imports. Once the import is defined you need to make sure which attributes you have checked as identifiers. You can actually have more than one checked. 

Whenever new objects get imported Assets will see the identifier, and if there's already one with the same value, it will update the properties that are different.

Make sure the Key attribute is not checked as an identifier in the import as that value is *always* different and you can't override it.

0 votes
Eugenio Onofre
Community Champion
January 12, 2024

Hi @Derek Low

I would suggest using Jira Asset Management APIs to achieve what you want instead of the default import functionality.

The official documentation is below:
https://developer.atlassian.com/cloud/assets/rest/api-group-aql/#api-group-aql

I know this require custom script development but is the easiest and safest way to achieve what you want.

Please remember to accept this answer in case it helps you resolve your question as it may also help other community members in the future.

Regards,
Eugenio

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events