question Creating records from excel in scoped app in ServiceNow Otto for Creator forum

Creating records from excel in scoped app

MaharshiC — Mon, 30 Sep 2024 14:16:44 GMT

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

Re: Creating records from excel in scoped app

Hemanth M — Mon, 30 Sep 2024 14:59:25 GMT

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/GlideExcelParserScopedAPI#GEPS-getTableInfo

Re: Creating records from excel in scoped app

Sandeep Rajput — Mon, 30 Sep 2024 15:15:13 GMT

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