Fetching data from .csv excel sheet

[Rahul Raja Sami]

Hi

Currently I am using Glide EXCEL parser to fecth the data from .xlsx format sheet and creating requests with the data but when trying to fetch the data from .csv format sheet I am getting error as 

com.glide.script.RhinoEcmaError: Cannot read property "0" from null
sys_script.078696f21b148ad05cf40f6cdc4bcbae.script : Line(11) column(0)
8:
9: //retrieve the column headers
10: var headers = parser.getColumnHeaders();
==> 11: var header1 = headers[0];
12: var header2 = headers[1];
13: var header3 = headers[2];
14: var header4 = headers[3];

How to fetch the data from .csv sheet?

[Community Alums · Accepted solution]

Hi @Rahul Raja Sami ,

Please follow the steps mentioned in this article :https://www.servicenow.com/community/developer-articles/read-csv-formatted-files-in-servicenow/ta-p/...

[Rahul Raja Sami]

Hi Sandeep, this is good reference but not able to fetch the the particular cell details that can be mapped to a particular variable while raising the request.