Hi Punit,

It looks like your environment did not install the Python dependencies. Please run this command to install them separately:
>=7.2.0
sudo -u fsr-integrations /opt/cyops-integrations/.env/bin/pip install -r /opt/cyops-integrations/integrations/connectors/csv-data-management_1_0_0/requirements.txt

<=7.0.2

sudo -u nginx /opt/cyops-integrations/.env/bin/pip install -r /opt/cyops-integrations/integrations/connectors/csv-data-management_1_0_0/requirements.txt

I have also updated the link in my original message. Please try the new link to see the other playbook.

Thank you,

------------------------------
Chris
Principal Software Development Engineer - FortiSOAR
------------------------------
-------------------------------------------
Original Message:
Sent: Jun 03, 2022 09:46 AM
From: Punit Dwivedi
Subject: Upload CSV and update FortiSOAR Records

He Chris,

Thanks for your response. I did try to use the CSV connector but when running the step, I was getting below error:
No module named 'pandas'  Connector :: csv-data-managementV1.0.0 URL : https://localhost:9595/integration/execute/?format=json 

Also, I do not seem to have access to the link to the older playbook. Do you mind attaching the older playbook to this thread.

Thanks 
Punit D

------------------------------
Punit
------------------------------

Original Message:
Sent: Jun 03, 2022 09:23 AM
From: Christopher Carsey
Subject: Upload CSV and update FortiSOAR Records

Hi Punit,

You can use the CSV Data Management connector to load data from a CSV: https://docs.fortinet.com/document/fortisoar/1.0.0/csv-data-management/270/csv-data-management-v1-0-0
You can use a step for loop with a Create Record step to create records using the output from the CSV.

Attached is an older playbook that does something similar (though it doesn't use the CSV connector). It accepts a CSV file as input, parses it, and creates indicators/assets based on the output.

Thank you,

------------------------------
Chris
Principal Software Development Engineer - FortiSOAR

Original Message:
Sent: Jun 02, 2022 08:35 PM
From: Punit Dwivedi
Subject: Upload CSV and update FortiSOAR Records

Hello,

I am looking to formulate a solution. I want to upload a csv file using user prompt to FortiSOAR and update records in Module of FortiSOAR. Of course, the headers in field will be similar to fields created in module. 

Looking for inputs from community members.

------------------------------
Punit
------------------------------