topic Re: XSOAR - Send CSV in Cortex XSOAR Discussions

XSOAR - Send CSV

TexasHoosier — Tue, 31 Aug 2021 13:24:28 GMT

Hello,

I am trying to send a csv in a post request using the "http request" built-in task, but the File parameter seems to be missing. What is the best way to send a csv file in an api post from XSOAR?

Re: XSOAR - Send CSV

r_buchwalder — Tue, 31 Aug 2021 13:38:01 GMT

Hello

Did you tried to use ExportToCsv task?

https://xsoar.pan.dev/docs/reference/scripts/export-to-csv

regards

roger

Re: XSOAR - Send CSV

TexasHoosier — Tue, 31 Aug 2021 13:42:55 GMT

Thanks for the reply, yes I used the export-to-csv task to get the data into a csv format, but that's about all the task seems to do. Now that I have the file in csv format, I need a way to send it in a post request to another api.

Re: XSOAR - Send CSV

r_buchwalder — Tue, 31 Aug 2021 13:58:16 GMT

I do see you problem, you need first to donwload the file to continue the work/tasks.

I did a little test on my side and saw following:

The download link is cutted in different sections...

first part is https://<demisto machine name>
second part is /entry/download/
and third part is File.EntryID

so the url is like this, if you would use it in an other task:

https://demisto/entry/Download/${File.EntryID}

Be carefull, you migth not use the URL above if you send it in an E-Mail, because you need to login first into demisto...

Could you please try it out?

regards

roger

Re: XSOAR - Send CSV

TexasHoosier — Tue, 31 Aug 2021 14:20:00 GMT

The issue with sending the download URL is that a team will be using the file that does not have access to XSOAR. So I need to be able to send the csv directly.