Import rows

POST

/imports

curl --request POST \
  --url https://example.com/imports \
  --header 'Content-Type: application/json' \
  --cookie __Host-bottle.session_token=<__Host-bottle.session_token> \
  --data '{ "kind": "customers", "fileName": "example", "rows": [ { "accountNumber": "example", "name": "example", "address": "example", "postcode": "example", "contactName": "example", "phone": "example", "email": "example", "notes": "example" } ], "skip": [ 1 ], "firstRow": 1, "mapping": { "additionalProperty": "example" } }'

Adds and updates every row that checks clean, in one go, and keeps a record so the import can be undone. Refused with 422 while any row has a problem or a location to place. Registering a cylinder adds no stock: it is already counted.

Authorizations

• sessionCookie
  customers:write
• apiKey
  customers:write

Request Body^required

Media typeapplication/json

One of:

object

object

kind

required

string

Allowed values: customers

fileName

required

string

>= 1 characters <= 200 characters

rows

required

Array<object>

>= 1 items <= 5000 items

object

accountNumber

string

<= 500 characters

name

string

<= 500 characters

address

string

<= 500 characters

postcode

string

<= 500 characters

contactName

string

<= 500 characters

phone

string

<= 500 characters

email

string

<= 500 characters

notes

string

<= 2000 characters

skip

Array<integer>

<= 5000 items

firstRow

integer

>= 1

mapping

object

key

additional properties

string

<= 80 characters

object

object

kind

required

string

Allowed values: cylinders

fileName

required

string

>= 1 characters <= 200 characters

productId

required

UUID v7

string format: uuid

Example

019205d1-6e7a-7c3b-9f6e-3a2b1c0d9e8f

rows

required

Array<object>

>= 1 items <= 5000 items

object

references

required

object

key

additional properties

string

<= 500 characters

location

string

<= 500 characters

notes

string

<= 2000 characters

skip

Array<integer>

<= 5000 items

firstRow

integer

>= 1

places

object

key

additional properties

One of:

object

object

kind

required

string

Allowed values: place vehicle supplier customer

id

required

UUID v7

string format: uuid

Example

019205d1-6e7a-7c3b-9f6e-3a2b1c0d9e8f

object

object

kind

required

string

Allowed values: new_customer

name

required

string

>= 1 characters <= 160 characters

object

object

kind

required

string

Allowed values: nowhere skip

mapping

object

key

additional properties

string

<= 80 characters

Responses

201

Imported

Media typeapplication/json

object

id

required

UUID v7

string format: uuid

kind

required

string

Allowed values: customers cylinders

fileName

required

string

created

required

integer

updated

required

integer

skipped

required

integer

byName

required

string | null

createdAt

required

string format: date-time

undoneAt

required

string | null format: date-time

Example

{
  "id": "019205d1-6e7a-7c3b-9f6e-3a2b1c0d9e8f",
  "kind": "customers"
}

401

Not signed in

Media typeapplication/json

object

error

required

string

message

required

string

Example

{
  "error": "not_found",
  "message": "Customer not found"
}

403

Not an owner or admin, or the plan does not open Assets

Media typeapplication/json

object

error

required

string

message

required

string

Example

{
  "error": "not_found",
  "message": "Customer not found"
}

404

Not found, or Assets is not available to this business

Media typeapplication/json

object

error

required

string

message

required

string

Example

{
  "error": "not_found",
  "message": "Customer not found"
}

409

Assets is switched off, or the import was already undone

Media typeapplication/json

object

error

required

string

message

required

string

Example

{
  "error": "not_found",
  "message": "Customer not found"
}

422

Validation failed, or rows still have problems

Media typeapplication/json

object

error

required

string

Allowed values: validation

message

required

string

issues

required

Array<object>

object

path

required

string

message

required

string

Example

{
  "error": "validation",
  "issues": [
    {
      "path": "email",
      "message": "Invalid email"
    }
  ]
}