Have you ever tried updating data with XML import?

[Yuri Yoshinami]

Hi developers,

I always update data with using import set table and transform map. And Recently I came to find that we can also update data with xml import.

Has anyone updated data with xml import? and Is there any demerits compared to updating data with import set table?

Kind regards,

Yuri

[vkachineni]

Business rules are not run when you import XML. You can control it if you import via transform map.

[Hitoshi Ozawa]

I think most of us have used xml to import data.

I've used it to import master table data and to fix data. As was mentioned by vkachineni, data imported using xml won't be execute business rules, transformation map, nor update instance cache. This can be taken as a disadvantage or as an advantaged based on the data to be imported.

Importing using xml also requires admin role.

ServiceNow has many similar features. Which feature to use depends on who and what the requirements are. It's not about using one feature fully over other similar feature in all circumstances. It is, however, very important to fully understand the feature fully before using it in production environment.

[Yuri Yoshinami]

@Hitoshi Ozawa 

Thanks for your reply.

I have used xml import only when inserting records so that we can have the records which have same sys_id in dev instance and prod one. I will think whether there should be any BR to run when updating records.

[Hitoshi Ozawa]

It also won't update the cache so updating may not become available immediately until the cache is cleared.

To clear cache, execute "cache.do".