Skip to main content
PUT
/
v2
/
members
/
jobs
/
csv
cURL
curl --request PUT \
  --url https://api.onsi.com/v2/members/jobs/csv \
  --header 'x-api-key: <api-key>'
{
  "jobId": "maj_cltd2zp7100096tmbamb9c46o"
}
Upload a CSV file containing your entire target member list. This endpoint behaves identically to V1, with one key difference: when bank detail columns are present but empty for an existing member that has bank details on their profile, their bank details will be unset (disabled). In V1, empty bank detail columns are ignored and existing bank details are preserved. The file should contain the following columns:
  • email: The email address of the member.
  • first_name: The first name of the member.
  • last_name: The last name of the member.
  • phone: (allowed empty) The phone number of the member.
  • tier: The tier of the member.
  • worker_id (optional, allowed empty): The worker ID of the member.
  • Bank detail columns (optional, allowed empty). In V2, leaving these empty will unset existing bank details.
    • For UK partners:
      • sort_code: The sort code of the member’s bank account.
      • account_number: The account number of the member’s bank account.
      • account_holder: The name of the account holder.
    • For EU partners:
      • iban: The IBAN of the member’s bank account.
      • account_holder: The name of the account holder.
The API doesn’t care about the casing of the columns, e.g. “Worker ID” is acceptable

​
Bank Details Handling

ScenarioV1 BehaviourV2 Behaviour
Bank detail columns empty for existing member with bank detailsExisting bank details preservedExisting bank details removed
Bank detail columns empty for existing member with no bank detailsMember remains with no bank detailsMember remains with no bank details
Bank detail columns populatedBank details updatedBank details updated
New member with bank detailsBank details setBank details set

​
Relevant Error Codes

When parsing the file uploaded we can return:

Authorizations

​
x-api-key
string
header
required

Headers

​
x-idempotency-key
string

Unique key to ensure idempotency of the request

Response

202 - application/json

202

​
jobId
string
required
Example:

"maj_cltd2zp7100096tmbamb9c46o"