Parse the CSV attachment.

[PK16]

Hello Community Experts,

I want to parse the CSV attachment and get the data present in that in the flow designer.

Is there any resources or script you have so that I can use them for reference?

(Note: I want to fetch the attachment from the sys_attachment table and parse it and display the values in the background script. After that, I will customize that in flow designer as well).

Regards,

PK

[Ankur Bawiskar]

Hi,

ServiceNow provided CSV Parser class which you can use in server side script.

In flow designer create a custom action and use that script.

CSVParser

Regards
Ankur

[PK16]

Hi @Ankur Bawiskar ,

I have created the below script:-  

try {
var attachment = new GlideSysAttachment();
var attachmentStream = attachment.getContentStream('1722a8da2fe5d1101a5cf3ecf699b65b');
var x = new sn_impex.CSVParser().parseLineToObject(attachmentStream);

gs.log('From CSV:'+x.title);


}
catch(ex) {
      gs.info("In Catch:"+ex.message);
}  

But it gives me output like below:-

it is not printing the title 

Whether I'm doing something wrong?

Thanks.

[PK16]

Below is my CSV file :-

[PK16]

Attachment :-