Can I use "system import sets" to update existing records?

Daiki Shinohara
Tera Contributor

Can I use "system import sets" to update existing records?

I would like to update my ServiceNow CI by importing an edited Excel for a record already registered in ServiceNow.

 

Thank you for your cooperation.

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

yes you can

I hope you must be using data source, transform map and field maps

In the field maps; the field which is set as Coalesce=true determines if new record is to be created or not

If match is found it would update

If not then it would insert

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

3 REPLIES 3

suvro
Mega Sage
Mega Sage

Yes you can, just make sure to mark the correct field as  coalesce  which is the unique identifier for that CI for example Serial Number in case of Hardware and its children

Chandu Telu
Tera Guru
Tera Guru

Hi Daiki Shinohara,

 

Yes, you can use but make sure the there should a unique value added the screenshot for your reference

 

Mark the answer if correct/helpful , if it helps

 

Thanks

Chandu Telu

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

yes you can

I hope you must be using data source, transform map and field maps

In the field maps; the field which is set as Coalesce=true determines if new record is to be created or not

If match is found it would update

If not then it would insert

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader