Import Customers from CSV

Batch import customer data from CSV content into fields defined in the Pisano Customer Schema.

POST /v1/customers/import_from_csv

Authentication

Authentication Method User integration token via Authorization header

Headers

Header	Required	Description	Example
`Authorization`	Yes	User integration token.	`Bearer <token>`
`Content-Type`	Yes	Request content type.	`application/json`

Request Body

{
  "node_id": "<Pisano account ID>",
  "column_mapping": {
    "phone_number": "MOBILEPHONE",
    "external_id": "ID",
    "email": "EMAIL",
    "name": "NAME"
  },
  "csv_file": {
    "name": "customer_import_sample.csv",
    "csv_string": "MOBILEPHONE,EMAIL,NAME,ID\r\n5555555555,pisano@pisano.com,Pisano,123"
  }
}

Request Body Fields

Field	Type	Required	Description	Example
`node_id`	string	Yes	Pisano account/node identifier.	<Pisano account ID>
`column_mapping`	object	Yes	Maps Pisano customer schema codes to CSV column names.	`{"email":"EMAIL"}`
`csv_file`	object	Yes	CSV file information.	`{}`
`csv_file.name`	string	Yes	CSV file name.	customer_import_sample.csv
`csv_file.csv_string`	string	Yes	CSV content; first row contains headers and following rows contain customer data.	MOBILEPHONE,EMAIL,NAME,ID...

Request Example

cURL

cURL Request Example

curl --location 'https://<pisano_domain>/v1/customers/import_from_csv' \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '<JSON body shown above>'

Responses

200 OK

CSV content processed and customers imported successfully.

Error Responses

400 Bad Request

Invalid or incomplete request data.

401 Unauthorized

Invalid or missing authorization token.

Additional Information

Usage Limitations

The request body and column_mapping depend on the target account and the Customer Schema fields that need to be populated.

Pisano External API - Customers - Import Customers from CSV