Bulk logging requests in ServiceNow

[Jerry Ong]

Hi All,

I have an excel file to bulk load and convert to RITMs for about 70 records instead of manually logging the requests individually. Does ServiceNow have this capability for bulk loading requests via a spreadsheet?

Thanks for advising.

[Mark Manders]

Yes. You can create a data source and transform map to do so. 

It could also be a simple import, if you have the fieldnames mapped correctly, but that often isn't the case.

The only issue is that RITMs are part of the Request module. Normally, a form is filled and that creates a request, approval, RITMs and tasks because of the logic triggered on submitting the form through (work)flows. When creating the record through an import, none of that logic will run.

[Ankur Bawiskar]

@Jerry Ong 

I agree with Mark here.

If you want proper REQ, RITM and approvals etc, catalog tasks etc to be raised then you can use Data source, transform map and in transform script you can use Cart API

In the excel do you have all the variable details as well?

refer below links and enhance as per your requirement.

Create requests from excel import 

creating RITM using inbound action and cart api 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Selva Arun]

Hi Jerry,

Yes, it is available, please check the below developer document and youtube for doing it:

https://developer.servicenow.com/dev.do#!/learn/learning-plans/xanadu/servicenow_administrator/app_s...

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

https://www.youtube.com/watch?v=Q-kP9riLZGo

If you believe the solution provided has adequately addressed your query, could you please **mark it as 'Helpful'** and **'Accept it as a Solution'**? This will help other community members who might have the same question find the answer more easily.

Thank you for your consideration.

Selva Arun