Bulk Create RITMs as Historical Information

[Edi 8]

Hi Experts,

I had a question that is similar to this post, but slightly different: https://www.servicenow.com/community/developer-forum/create-bulk-ritm-and-single-request-from-excel/...

Background: we are sunsetting an application and moving processes into ServiceNow. We now need to migrate historical case details from the sunsetting application into SNOW for reference purposes.

Requirement:

 - We have an excel file where each row has data for a single RITM/REQ

 - We need to populate data from Excel into each RITM's variable(s) and fields on the RITM (sc_req_item) table  

 - We need to create these RITMs/REQs in an closed complete State and not trigger any notifications

Thank you in advance!

Edi

[Edi 8 · Accepted solution]

I'm closing this thread as I was able to figure it out. For anyone out there who has a similar use case, I ended up creating records on each table: sc_request, sc_req_item, sc_item_option, sc_item_option in a loop. This way, you can update fields on the REQ/RITM table and also account for each variable that needs to be created.