Need to create multiple requests from excel attached

[Pallavi65]

Hi all,

There will be an excel file attached to an incident via Inbound email action. That excel consists of 3 columns

Server, Application and Group.

For example, there are 5 rows in that excel and there are two applications that are in common.

1. Server1, App1, Database group

2. Server2, App1, Database group

3. Server3, App2, Database Group

4. Server4, App3, Infra Group

5. Server5, App4, Logistics Group

So, here the first two records have same application name. So, from this excel I want to create 4 requests automatically. In the first request, the short description should have Application name and the description should have the two servers. And the separate requests for other rows of the excel and they should be assigned to the assignment group mentioned in the third column.

So, in one word, for every one application one request should be created.

Please tell me how can I get this?

Thanks in advance.

Regards,

Pallavi

[ersureshbe]

Hi, You can use GlideExcelParser API. I recommend to check below link and modify based on your requirement.

https://developer.servicenow.com/dev.do#!/reference/api/quebec/server/GEPS-getRow

Regards,

Suresh.

[Pallavi65]

Hi Suresh,

This is unclear to my standards.

Currently what I was working is, I have created a data source and attaching the excel to it and the target table in the transform map is sc_request. So designed a workflow with some conditions and creating associated RITM and Catalog task.

But as said, the requests are getting created for every row of excel.

But only one request should be created for one unique application with different servers.

Please help

Regards,

pallavi

[Ankur Bawiskar]

@Pallavi65 

you can use ExcelParser as mentioned by other member.

Also you can try to explore on data source, transform map for transforming the data from excel

Auto load Excel spreadsheet using Email Inbound Action 

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

[Pallavi65]

Hi Ankur,

I have attached the sample excel file here. Here in this excel there are 6 rows. And if you can see there is an application called 'Atlas'

So here totally 4 requests have to be created but not 6 requests.

In the Atlas request, in the Short Description Atlas should be there and, in the Description the corresponding 3 servers should be there. 

Can you please help me in the code you share?

Regards,

pallavi