Create Requests from excel sheet sent through email

Rachael12
Tera Contributor

3 weeks ago

Hello,

 

A excel sheet is sent through email which contains 100+ rows. I have a requirement where in I need to create request -> RITM -> task for each row of the sheet.

I have create requests through cart functionality but not sure how to automate it for excel sheet.

 

Any guidance would be really helpful.

0 Helpfuls
  • 460 Views
2 REPLIES 2

Shashank_Jain
Kilo Sage

3 weeks ago - last edited 3 weeks ago

@Rachael12 ,

 

This can be achieved -

 

  • Excel file into ServiceNow (Data Source + Import Set).

  • Process the Import Set rows with a Transform Map + Script.

  • In that script, use Cart API / Request API to create REQ → RITM → TASK for each row.

Go through this link to get more idea about ServiceCatalogAPI.

Link - https://www.servicenow.com/docs/bundle/zurich-api-reference/page/integrate/inbound-rest/concept/c_Se...

PS :Start the development from scratch and go through the steps on your own once. While doing this, if you have any doubts, feel free to ask in the community.

 

If this works, please mark it as helpful/accepted — it keeps me motivated and helps others find solutions.
Shashank Jain
0 Helpfuls

Rachael12
Tera Contributor
In response to Shashank_Jain

2 weeks ago

Hello @Shashank_Jain 

Thank you the response. I have a query, when I create a Transform Map what should I map as target table. I do not want to create any custom table.

As of now I have created a import set table and loading data in it and through 'On Before' script, creating requests through Cart API.  What should I map in target table, currently I have mapped the source 'import set table' in target table as well but I think that will not be best practice.

Do you have any idea what should be the target table?

Regards

0 Helpfuls