Create a request/RITM using csv file

[Ganesh Prasad C]

Hello everyone,

I have two catalog items - 1) ItemA and 2)ItemB

When a user uploads .csv file to ItemA and submits it through the service portal, ItemB should be requested depending upon the number of rows filled in the .csv file.

example, if the csv file has 10 rows, 10 requests for ItemB should be raised (through Buy Item (POST)).

Could anyone help me on how this can be achieved in a detailed and simple manner along with scripts? I'm fairly new to ServiceNow.

Appreciate your help on this

[Jaspal Singh]

You need something as below.

1. A data source that will be used to create catalog item B

2. An After insert business rule on Attachment table that copies attachment from RITM to Datasource in Step 1

3. Transform map for the datasource created in step 1 to REQ table with onBefore Transform script that reads each cell from excel & then creates corresponding Catalog item

[P M Kamer Taj]

Hi Ganesh,

Can you please try to follow this below article.

https://joshbrostoff.github.io/bulk_upload/