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

Question

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.

Pedro Arroyo · Answer

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.

Eugenio Onofre_v78igo · Answer

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