Create Requests from excel sheet sent through email

Rachael12
Tera Contributor

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.

2 REPLIES 2

Shashank_Jain
Mega Sage

@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.

 

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