parse data from template to change form

[Naga13]

Hi Team,

Please guide how to parse data from attached Template to change form( Data is getting from third party tool through integration).

Regards,

Venkat.

[Dr Atul G- LNG · Accepted solution]

Hi @Naga13 

The data is in which format?

Have a look here

https://www.servicenow.com/community/developer-articles/parsing-the-excel-sheet-data-use-the-data-in...

https://developer.servicenow.com/dev.do#!/reference/api/orlando/server/sn_impex-namespace/GlideExcel...

[Dr Atul G- LNG · Accepted solution]

Hi @Naga13 

The data is in which format?

Have a look here

https://www.servicenow.com/community/developer-articles/parsing-the-excel-sheet-data-use-the-data-in...

https://developer.servicenow.com/dev.do#!/reference/api/orlando/server/sn_impex-namespace/GlideExcel...

[Naga13]

Hi Atul, 

Appreciate your help !

Data is in excel format

Provided articles are relevant to my use case but i have little bit confusion, Actually data is getting from third party tool to submit the change in servicenow for that reason they will send few details in the template and those field values we need to auto populate on the change form.

Regards,

Venkata. 

[Dr Atul G- LNG]

Hi @Naga13 

We have done this similar use case

- Create a Staging table

- Parse the excel data and add update the fields based on excel vallue

- Then run Flow to move that data from staging to Change table.

Few Pain points

- Make sure, the excel fields did not get change

- Keep same name of excel to read the name and parse

- The reference field must have correct values so that at time of target table it should work.

Recommended Solution

- Excel parsing will not good, if you have different templates from different vendors.

- Try to use catalog item for this.

Hope this will be helpful

[Naga13]

Hi Atul,

Could you please share script for the same if you have any sample script.

Regards,

Venkata.