Skip to content
Navigation

Import contacts from a CSV

Add or update many people at once from a CSV, given as text (csv) or as a base64 file (file, up to 12 MB, about 100,000 rows). Rows matching an existing contact's phone, WhatsApp, email or document update that contact; the rest create new ones. Returns a task at once: follow it with get_task (processedRows of totalRows, then created, updated and rejected counts with the first 100 row errors). cancel_task stops it after the current batch; a failed import resumes with retry_task within 7 days. Fails with IMPORT_FILE_INVALID when the file is not UTF-8 and IMPORT_FILE_TOO_LARGE above 12 MB.

  • Scope: raiz:contacts:write
  • Credentials: an API key, a client-credentials token or a person's access token
  • Effect: writes; not idempotent: check the outcome before you retry
  • Limits: request body up to 16 MB, response up to 1 MB
  • CLI: arbol raiz contacts import · MCP tool: raiz_contacts_import
POST
https://api.getarbol.com/v1/raiz/contacts/import

Authorization

  • Authorization
    string
    required
    Bearer <token>, where the token is an API key, a client-credentials token or a person's access token with the scope raiz:contacts:write. Get an API key.

Request body JSON required

  • countryCode
    optional
    string

    Country assumed for phone numbers written without + and country code (ISO 3166-1 alpha-2).

    pattern: ^[A-Z]{2}$ · default: "CO"
  • csv
    optional
    string

    The CSV as text. UTF-8 CSV with a header row (,, ; or tab). Recognized columns: given_name, family_name, phone, whatsapp, email, document_type, document_number, summary; any other column is stored as metadata, or as a fact when its header is an active contact definition's key. Rows whose phone, WhatsApp, email or document matches an existing contact update that contact. Give csv or file, not both.

    maxLength: 12000000 · minLength: 1
  • file
    optional
    object

    The CSV file as read from disk, in base64, as Knowledge files are sent. UTF-8 CSV with a header row (,, ; or tab). Recognized columns: given_name, family_name, phone, whatsapp, email, document_type, document_number, summary; any other column is stored as metadata, or as a fact when its header is an active contact definition's key. Rows whose phone, WhatsApp, email or document matches an existing contact update that contact.

    • data
      string
      required

      The file's bytes in standard base64, at most 12 MB decoded.

      maxLength: 16000000 · minLength: 4

Returns

200

Successful operation.

JSON
  • success
    boolean
    required
  • data
    object
    required
    • attemptCount
      integer
      required

      Attempts the task has made so far, retries included. A task that works in slices counts one attempt for all of them.

      minimum: 0
    • cancelRequestedAt
      string | null
      required

      When someone asked the running task to stop. It ends cancelled at its next checkpoint, keeping what it already did.

      format: date-time
    • createdAt
      string
      required

      An instant in RFC 3339 format, in UTC.

      format: date-time
    • createdBy
      string | null
      required

      The person or client that started it.

    • endedAt
      string | null
      required

      An instant in RFC 3339 format, in UTC.

      format: date-time
    • errorCode
      string | null
      required

      Why it failed, when it failed.

    • id
      string
      required

      Task id.

      pattern: ^job_(?:[0-7][0-9a-hjkmnp-tv-z]{25}|(?:[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}|[a-f0-9]{32}))$
    • kind
      contact_import
      or
      analysis_run
      or
      knowledge_crawl
      required

      What the task does.

    • progress
      object
      required

      Steps of a task that splits its work into child jobs (one per conversation of a re-analysis). Zero steps: the task runs as one unit.

      • failedSteps
        integer
        required
        minimum: 0
      • finishedSteps
        integer
        required
        minimum: 0
      • totalSteps
        integer
        required
        minimum: 0
    • result
      object | null
      required

      What the task produced, by kind (for example the import counts). While an import runs, its progress (processedRows of totalRows); a cancelled import keeps the counts of what it did.

    • retryable
      boolean
      required

      The task failed and retryTask can queue it again: its kind retries and it has attempts left.

    • startedAt
      string | null
      required

      An instant in RFC 3339 format, in UTC.

      format: date-time
    • status
      queued
      or
      running
      or
      completed
      or
      failed
      or
      cancelled
      required
    • subjectId
      string | null
      required

      The resource the task acts on, when it has one.

  • error
    null
    required
  • metadata
    object
    required
    • requestId
      string
      required

      Request correlation identifier, also sent as X-Request-Id.

400

INVALID_INPUT: The request does not match the published schema.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

401

UNAUTHORIZED: A valid access token is required.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

403

FORBIDDEN: The token does not authorize this operation.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

404

NOT_FOUND: The requested operation does not exist.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

405

HTTP_METHOD_NOT_ALLOWED: The HTTP method is not supported for this resource.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

413

  • REQUEST_TOO_LARGE: The request exceeds the allowed size.
  • IMPORT_FILE_TOO_LARGE: The import file is larger than 12 MB. Split it into several files.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

415

UNSUPPORTED_MEDIA_TYPE: The request content type is not supported.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

422

IMPORT_FILE_INVALID: The import file is not valid base64 of UTF-8 text. Save the spreadsheet as CSV UTF-8 and try again.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

429

RATE_LIMITED: The request rate limit was exceeded. Try again later.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

500

INTERNAL_ERROR: The service could not complete the operation.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

502

OUTCOME_UNKNOWN: The operation may have been applied; check its result before repeating it.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

503

  • UPSTREAM_UNAVAILABLE: The upstream service could not complete the request.
  • INTEGRATIONS_UNAVAILABLE: The organization's integrations cannot be read right now. Try again shortly.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

504

UPSTREAM_TIMEOUT: The upstream service did not respond before its deadline.
JSON
  • error
    required

    One of the following:

    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object
    • object

Escribe para buscar…

↑↓ navegar↵ seleccionarEsc cerrar