Bulk import with open flows for a service catalog

[Lawrence4]

Hello, we have a request to raise bulk import to the requested table in one of our service catalog. It should have a running flow and task should be created. Is using transform map the best approach to do this request or we can do other methods for this one. Thanks for your help!

[Tom Sienkiewicz]

What kind of table are you importing to/is the flow running on?

Normally if the flow is set up to be triggered whenever a record gets created, it would be enough to ensure "Run Business Rules" option on your transform map is selected, for it to kick off. The task would then usually be generated from that flow.

Alternatively, you can use the Catalog API to insert orders or record producers: https://developer.servicenow.com/dev.do#!/reference/api/rome/rest/c_ServiceCatalogAPI

[Lawrence4]

It will be an excel file with all the details on it going to the requested item table. So transform map is the ideal approach to do this?

[Tom Sienkiewicz]

I would not say there is one ideal approach.

You need to keep in mind when inserting RITMs that there should also be a REQ record created in the backgorund. You need to figure out if all the RITMs from the file will be under one REQ, or one-by-one or other. 

Using import sets, you can create the REQ records first in one transform map, and then create and link RITM records in another transform map.

But you can also consider using the Catalog API, after the file is loaded, call that API for each row, for example:

https://docs.servicenow.com/bundle/sandiego-application-development/page/integrate/inbound-rest/conc...

It sort of automates the REQ creation inthe background, but you will have less control over the records created.

[Supriya13]

Hello Lawrence,

You can try below thinks ,

1. Create business rule after insert on RITM table which runs only for that  Catalog Item. and check whether the RITM has attachment or not

2.Create data source, transform map and field map created and  require coalesce will be present

3. Use scheduled import created with this data source with active= false and run through script, make run as administrator 

Also there is one blog to help in detail. 

https://community.servicenow.com/community?id=community_blog&sys_id=d3dc8911db285490190dfb243996199a

Thanks ,

Supriya