Import records

POST

orgs

{org_id}

tables

{table_id}

records

import

Import records

curl --request POST \
  --url https://api.useinvent.com/orgs/{org_id}/tables/{table_id}/records/import \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "file": "<string>",
  "mapping": "<string>"
}
'

{
  "created": 123,
  "failed": 123,
  "errors": [
    {
      "row": 123,
      "message": "<string>"
    }
  ]
}

Authorizations

Authorization

string

header

required

Bearer token authentication using your API key

Path Parameters

org_id

string

required

Org ID

table_id

string

required

Table ID

Body

file

required

mapping

string

Optional JSON object mapping a CSV header to a field key, e.g. {"Full Name":"name"}.

Maximum string length: 8192

Response

200 - application/json

created

number

required

Rows imported successfully.

failed

number

required

Rows that were rejected.

errors

object[]

required

Per-row failures. Successful rows still commit.

Show child attributes

List recordsList the records in a table.

Import records

curl --request POST \
  --url https://api.useinvent.com/orgs/{org_id}/tables/{table_id}/records/import \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "file": "<string>",
  "mapping": "<string>"
}
'

{
  "created": 123,
  "failed": 123,
  "errors": [
    {
      "row": 123,
      "message": "<string>"
    }
  ]
}