Import data in ServiceNow through Excel independent of Header

Sanjay21
Tera Contributor

‎08-29-2023 04:21 AM

I have a variable in Catalog item which has attachment in Excel.
I want to import the data from Excel to a table in servicenow.
But the end user is not providing exact header name mentioned in import set table.
Can you give me any solution for this? Like change excel with constant variable always. Or something.
Thanks

0 Helpfuls
  • 289 Views
1 REPLY 1

Maik Skoddow
Tera Patron
Tera Patron

‎08-29-2023 04:51 AM

Hi @Sanjay21 

if you go the approach with import set tables, header name matching is required.

 

But you also could go another approach and leverage the GlideExcelParser API. See the following article as an example: https://finite-partners.com/using-glideexcelparser-for-bulk-ordering-of-assets/ 

Maik

0 Helpfuls