Automating Customer Data Import via API with CSV File for Batch Campaigns
Import from CSV Service
For the batch transfer of customer data into Pisano, the customers/import_from_csv endpoint is provided. This service facilitates the transfer of customer data from a CSV file into variables defined within the Pisano Customer Schema. The service requires the submission of several key pieces of information, including the node_id associated with the Pisano account, mappings between CSV headers and the Customer Schema, and the details of the CSV file itself. This information is essential for the accurate and secure importation of customer data into the Pisano platform.
Sample Request
curl --location 'https://<pisano domain>/v1/customers/import_from_csv' \
--header 'authorization: Bearer
\
\
--header 'content-type: application/json' \
--data-raw '{
"node_id": "",
"column_mapping": {
"phone_number": "MOBILEPHONE",
"gender": "GENDER",
"email": "EMAIL",
"name": "NAME",
...
},
"customer_list": null,
"csv_file": {
"name": "Customer_Sample.csv",
"csv_string": MOBILEPHONE,GENDER,EMAIL,NAME\r\n00905554443322,Male,dev@pisano.com, Pisano Dev Team
.... // customer data rows
"
}
}'
Following the transfer of customer data, batch campaign dispatches can be conducted through configurations set up in "Pisano Workflow" .