use transform map on an XML import from a file

[Joe K2]

We are working on an acquisition that is requiring us in February to take any open incidents from their instance of SNow and import them into instance.  Ideally we'd like to do this with an XML import so we can maintain images and attachments and I know ideally this should be done with a SN to SN connection of some sort to transfer data, but this would be a one time data load from them to us and they do not see value in connecting our instances.

That being said there are some issues here.  their incident schema is slightly different from ours as well issues with numbering incidents since if we do a direct load of an XML export of theirs it will maintain their incident numbers which may cause duplicate records for us.  I've been looking for a way to import this flat XML file and run it through a transform map, but have come up empty handed.  Is there anything that can do this natively or are there any creative solutions or workarounds that i'm not seeing?

any help would be appreciated. Thanks!

[Tony Chatfield1]

Hi, an xml 'upload' would only be successful if both instances contain exactly the same fields and all necessary reference data (for the records being loaded), if the custom fields are not aligned the import will fail, if the reference data, choice lists, custom states etc are different there will be inconsistencies in the loaded data. As you indicated you may also get duplicate values like incident number.

I would probably configure a scripted rest api and load the records via a staging table\import set from a REST get so the data can be aligned\managed in advance (in dev), that way the import can be triggered with a simple UI button push (execute scheduled job) and you can walk away\leave it to do its thing.

https://www.youtube.com/watch?v=DyIuma1cZrg