Creating records from excel in scoped app

MaharshiC
Tera Contributor

Hi,

I want to create records in my scoped table from excel . Suppose the user attaches an excel in my record producer and I want to create new records in my scoped table from that where for each row a new record should be created. I have got few solutions for creating new RITMS but for me it is a scoped table

 

Regards,

Maharshi Chatterjee

1 ACCEPTED SOLUTION

Hemanth M1
Giga Sage
Giga Sage

Hi @MaharshiC ,

 

Use excel parser api to read each row(you can validate each coulumn value) from the excel and use gliderecord to create records in your custom table

 

Refer : https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server/sn_impex-namespace/GlideExc... 

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

View solution in original post

2 REPLIES 2

Hemanth M1
Giga Sage
Giga Sage

Hi @MaharshiC ,

 

Use excel parser api to read each row(you can validate each coulumn value) from the excel and use gliderecord to create records in your custom table

 

Refer : https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server/sn_impex-namespace/GlideExc... 

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

Sandeep Rajput
Tera Patron
Tera Patron

@MaharshiC Please refer to this thread https://www.servicenow.com/community/developer-articles/parsing-the-excel-sheet-data-use-the-data-in... to know steps to parse excel data. You can apply the similar solution in scoped app too.