Create the import

POST /api/v1/import

Fist step of the import process, must be mapped before it can be started Must be of Content-Type multipart/form-data

Headers

multipart/form-data

Body Required

  • type string Required

    Type of record to import, available records are business_staff_members, charges, clients, group_scheme_members, notes, plans, premiums, tasks and valuations

  • mode string Required

    Type of import mode to enforce, available modes are store, update and validate

  • file string(binary) Required

    CSV file with import records

Responses

  • 200 application/json
    Hide response attributes Show response attributes object
    • uuid string

      The UUID of the resource.

    • created_at string

      The timestamp of when the resource was created.

    • updated_at string

      The timestamp of when the resource was updated.

    • type string

      The type of model the importer is importing

    • mode string

      The mode this import was run on

    • headers array[string]

      Headers taken from uploaded csv, not visible on index route

    • mapping object

      Mapped headers, not visible on index route

      Additional properties are allowed.

    • status string

      The status of the importer

    • total_jobs integer

      Total amount of imports in the importer

    • progress integer

      The current progress of the importer

    • jobs_remaining integer

      Number of pending imports

    • failed_jobs integer

      Number of failed imports

    • error_report object

      Error report file

      Additional properties are allowed.

    • errors object

      Array of failed imports, limited to 25 rows

      Additional properties are allowed.

    • account object

      Account that inititiated the import

      Additional properties are allowed.
POST /api/v1/import 
curl \
 -X POST https://api.plannrcrm.com/api/v1/import \
 -H "Authorization: Bearer {OAUTH_ACCESS_TOKEN or PERSONAL_ACCESS_TOKEN}" \
 -H "Content-Type: multipart/form-data" \
 -H "Accept: application/json" \
 -F "type=clients" \
 -F "mode=store" \
 -F "file=@file"
Response examples (200) 
{
  "mode": "store",
  "type": "clients",
  "uuid": "bf338d7e-14f0-40b0-a4ca-98b1356e4496",
  "errors": {
    "client": {
      "example": [],
      "description": "Client that failed importing"
    },
    "errors": {
      "example": {
        "send_welcome_email": [
          "The send welcome email field is required."
        ]
      },
      "description": "The reasons why the client failed importing"
    }
  },
  "status": "processing",
  "account": {
    "firm": "App\\Http\\Resources\\FirmResource",
    "name": "Gareth Thompson",
    "role": "client",
    "tags": "App\\Http\\Resources\\TagResource",
    "type": "client",
    "uuid": "7d4cd72d-5b97-4f54-938a-506cbe5e00aa",
    "email": "gareth@codepotato.co.uk",
    "groups": "App\\Http\\Resources\\GroupResource",
    "owners": "App\\Http\\Resources\\AccountResource",
    "last_name": "Thompson",
    "created_at": "2024-11-20T13:23:59+00:00",
    "first_name": "Gareth",
    "updated_at": "2024-11-20T13:23:59+00:00",
    "with_login": true,
    "custom_fields": "App\\Http\\Resources\\CustomFieldValueResource",
    "introduced_by": "App\\Http\\Resources\\AccountResource",
    "primary_email": "App\\Http\\Resources\\ContactDetailResource",
    "can_be_deleted": "false",
    "assigned_adviser": "App\\Http\\Resources\\AccountResource",
    "next_review_date": "2024-11-20T13:23:59+00:00",
    "has_joint_account": true,
    "current_time_entry": "App\\Http\\Resources\\TimeEntryResource",
    "first_contact_date": "2024-11-20T13:23:59+00:00",
    "external_references": "App\\Http\\Resources\\ExternalReferenceResource",
    "assigned_paraplanner": "App\\Http\\Resources\\AccountResource",
    "previous_review_date": "2024-11-20T13:23:59+00:00",
    "primary_phone_number": "App\\Http\\Resources\\ContactDetailResource",
    "assigned_administrator": "App\\Http\\Resources\\AccountResource",
    "anniversary_review_date": "2024-11-20T13:23:59+00:00"
  },
  "headers": [
    "fname",
    "lname",
    "email"
  ],
  "mapping": {
    "email": "email",
    "fname": "first_name",
    "lname": "last_name"
  },
  "progress": 100,
  "created_at": "2024-11-20T13:23:59+00:00",
  "total_jobs": 4,
  "updated_at": "2024-11-20T13:23:59+00:00",
  "failed_jobs": 1,
  "error_report": {
    "firm": "App\\Http\\Resources\\FirmResource",
    "name": "Welcome to Plannr",
    "size": "21691783",
    "tags": "App\\Http\\Resources\\TagResource",
    "type": "type",
    "uuid": "d95afc54-16c8-4c16-8449-29c18df3a562",
    "parent": "Object",
    "status": "uploaded",
    "account": "App\\Http\\Resources\\AccountResource",
    "filename": "Welcome to Plannr.pdf",
    "progress": "100",
    "extension": "pdf",
    "created_at": "2024-11-20T13:23:59+00:00",
    "updated_at": "2024-11-20T13:23:59+00:00",
    "folder_name": "folder 2",
    "uploaded_at": "2024-11-20T13:23:59+00:00",
    "download_url": "https://plannr.valet/file/48b7142c-986b-4b12-b807-c2e57c46db28/download",
    "last_modified": "2024-11-20T13:23:59+00:00",
    "original_created_at": "2024-11-20T13:23:59+00:00"
  },
  "jobs_remaining": 1
}