Creating records from excel in scoped app

[MaharshiC]

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

[Hemanth M · Accepted solution]

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

[Sandeep Rajput]

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