Get all accounts

GET /api/v1/account

Query parameters

  • sort string

    Field to sort by. Valid fields are [created_at, updated_at, first_name, last_name, email, next_review_date, previous_review_date, anniversary_review_date]. Negative sign to denote DESC. Defaults to 'first_name'.

  • include string

    Comma separated list of relationships to include in the response. Valid relationships are [primary_phone_number, primary_email, primary_address, assigned_adviser, assigned_administrator, assigned_paraplanner, groups, tags, owners, custom_fields, external_references, charge_split_schema].

  • Filter accounts by name. This is a partial match against first_name, last_name, and entity_name together.

  • Filter accounts that have an email with a partial match. (DEPRECATED - Please use primary_email)

  • Filter accounts with a given primary email. Performs a partial match.

  • Filter accounts with a given primary phone number. Performs a partial match.

  • Filter client status by partial names or uuid's

  • Get accounts with this is_prospect value

  • Comma separated string to filter by different account roles. Valid types are [individual, joint, trust, business,member,owner,admin,introducer].

  • Comma separated string to filter by different account types. Valid types are [client,employee,external].

  • Date to filter when the accounts was created after. Example 2022-04-05

  • Date to filter when the accounts was created before. Example 2022-05-31

  • Filter by a accounts custom field. Example filter[custom_field:pet_name]='Doug'

  • Comma separated list of tag names or tag UUIDs.

  • Comma separated list of partial groups names or group UUIDs.

  • Comma separated list of departments the employee is in.

  • Provide a group UUID (or multiple as a comma-separated string) to filter accounts within the provided groups out from the response.

  • filter clients that have been introduced by this introducer account, expects introducer account uuid, can accept multiple,

  • Filter to clients that have been linked to the account given. This will also return the requested account.

  • Comma separated list of employee account UUIDs that should always be returned no matter what other filters are applied.

  • Filter accounts that have an active login

  • Comma separated list of UUIDS to filter accounts who have the provided adviser account UUIDs

  • Comma separated list of UUIDS to filter accounts who have the provided administrator account UUIDs

  • Comma separated list of UUIDS to filter accounts who have the provided paraplanner account UUIDs

  • per_page integer

    Number of results to return with pagination (Default 15. Max 500).

Responses

  • 200 application/json
    Hide response attribute Show response attribute object
    • data array[object]

      Additional properties are allowed.

GET /api/v1/account
curl \
 -X GET https://api.plannrcrm.com/api/v1/account \
 -H "Authorization: Bearer {OAUTH_ACCESS_TOKEN or PERSONAL_ACCESS_TOKEN}" \
 -H "Content-Type: application/json" \
 -H "Accept: application/json" \
 -H "X-PLANNR-ACCOUNT-UUID: {YOUR_PLANNR_ACCOUNT_UUID}"
Response examples (200)
{
  "data": [
    {
      "firm": {
        "tax": 17.5,
        "logo": "https://api.plannrcrm.com/images/plannr.jpg",
        "name": "Codepotato",
        "slug": "codepotato",
        "uuid": "b471f30f-2667-4152-ae9f-a7aaa446da70",
        "county": "Hampshire",
        "billing": {
          "invoice_email": "gareth@codepotato.co.uk",
          "invoice_county": "Hampshire",
          "invoice_country": "United Kingdom",
          "invoice_postcode": "PO7 7YH",
          "invoice_address_1": "Suite E, 5 The Briars",
          "invoice_address_2": "Waterberry Drive",
          "invoice_town_city": "Waterlooville"
        },
        "country": "United Kingdom",
        "postcode": "PO7 7YH",
        "address_1": "Suite E, 5 The Briars",
        "address_2": "Waterberry Drive",
        "logo_icon": "https://api.plannrcrm.com/images/plannr-icon.jpg",
        "month_end": 25,
        "town_city": "Waterlooville",
        "created_at": "2025-01-21T09:11:07+00:00",
        "updated_at": "2025-01-21T09:11:07+00:00",
        "ip_whitelist": [
          "192.168.0.1",
          "127.0.0.1"
        ],
        "brand_colours": {
          "sidebar_text": "#ffffff",
          "sidebar_hover": "#0A0A42",
          "email_sub_text": "#ffffff",
          "sidebar_accent": "#36367E",
          "sidebar_active": "#53DBB8",
          "email_background": "#0E0E56",
          "email_button_text": "#ffffff",
          "sidebar_background": "#0E0E56",
          "sidebar_title_primary": "#FFC634",
          "email_button_background": "#36367E",
          "sidebar_title_secondary": "#ffffff",
          "sidebar_title_background": "#36367E",
          "email_logo_background_panel": "#36367E",
          "sidebar_title_secondary_hover": "#ffffff"
        },
        "is_subscribed": true,
        "regulatory_text": "Regulatory text",
        "addon_subscriptions": "App\\Http\\Resources\\Addons\\AddonSubscriptionResource",
        "statement_frequency": "monthly",
        "task_board_template": "App\\Http\\Resources\\Board\\BoardResource",
        "keep_deleted_files_for": 30,
        "welcome_paragraph_html": "<h1>Welcome.</h1>",
        "email_welcome_paragraph_html": "Welcome to Plannr!"
      },
      "name": "Gareth Thompson",
      "role": "client",
      "tags": [
        {
          "name": "Mortgage",
          "slug": "mortgage",
          "uuid": "ee784dfc-3b62-49fe-a1e3-d6d69d937fce",
          "colour": "#ef4582",
          "created_at": "2025-01-21T09:11:07+00:00",
          "updated_at": "2025-01-21T09:11:07+00:00"
        }
      ],
      "type": "client",
      "uuid": "550ae111-a7c6-4453-8fc8-8b0bd6dbf45b",
      "email": "gareth@codepotato.co.uk",
      "groups": [
        {
          "name": "finance",
          "slug": "finance",
          "uuid": "e6df8430-76f3-4b92-a276-a7dc064a4529",
          "created_at": "2025-01-21T09:11:07+00:00",
          "updated_at": "2025-01-21T09:11:07+00:00",
          "participants": {
            "name": {
              "example": "Gareth Thompson",
              "description": "Name of the account"
            },
            "role": {
              "example": "client",
              "description": "Role of the account"
            },
            "uuid": {
              "example": "bfa854cd-44b9-4f34-b437-56971100f97d",
              "description": "UUID of the account"
            },
            "email": {
              "example": "gareth@codepotato.co.uk",
              "description": "Email of the account"
            },
            "last_name": {
              "example": "Thompson",
              "description": "Last name of the account"
            },
            "first_name": {
              "example": "Gareth",
              "description": "First name of the account"
            }
          },
          "participants_count": "3"
        }
      ],
      "owners": [
        {
          "firm": "App\\Http\\Resources\\FirmResource",
          "name": "Gareth Thompson",
          "role": "client",
          "tags": "App\\Http\\Resources\\TagResource",
          "type": "client",
          "uuid": "7ce4e42f-4ada-4c99-86e4-07575d5042c5",
          "email": "gareth@codepotato.co.uk",
          "groups": "App\\Http\\Resources\\GroupResource",
          "owners": "App\\Http\\Resources\\AccountResource",
          "last_name": "Thompson",
          "created_at": "2025-01-21T09:11:07+00:00",
          "first_name": "Gareth",
          "updated_at": "2025-01-21T09:11:07+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": "2025-01-21T09:11:07+00:00",
          "has_joint_account": true,
          "current_time_entry": "App\\Http\\Resources\\TimeEntryResource",
          "first_contact_date": "2025-01-21T09:11:07+00:00",
          "external_references": "App\\Http\\Resources\\ExternalReferenceResource",
          "assigned_paraplanner": "App\\Http\\Resources\\AccountResource",
          "previous_review_date": "2025-01-21T09:11:07+00:00",
          "primary_phone_number": "App\\Http\\Resources\\ContactDetailResource",
          "assigned_administrator": "App\\Http\\Resources\\AccountResource",
          "anniversary_review_date": "2025-01-21T09:11:07+00:00"
        }
      ],
      "last_name": "Thompson",
      "created_at": "2025-01-21T09:11:07+00:00",
      "first_name": "Gareth",
      "updated_at": "2025-01-21T09:11:07+00:00",
      "with_login": true,
      "custom_fields": [
        {
          "name": "Favourite Drink",
          "type": "string",
          "uuid": "e30811a1-7be6-4b2b-8b48-c2b6946e6de3",
          "value": "Coffee",
          "help_text": "This is the client's favourite drink.",
          "reference": "favourite_drink",
          "created_at": "2025-01-21T09:11:07+00:00",
          "updated_at": "2025-01-21T09:11:07+00:00",
          "is_required": false,
          "selection_options": [
            "Coffee",
            "Tea",
            "Water"
          ]
        }
      ],
      "introduced_by": {
        "firm": "App\\Http\\Resources\\FirmResource",
        "name": "Gareth Thompson",
        "role": "client",
        "tags": "App\\Http\\Resources\\TagResource",
        "type": "client",
        "uuid": "dc1ecab2-8135-451d-83fb-8fdd171dc0b7",
        "email": "gareth@codepotato.co.uk",
        "groups": "App\\Http\\Resources\\GroupResource",
        "owners": "App\\Http\\Resources\\AccountResource",
        "last_name": "Thompson",
        "created_at": "2025-01-21T09:11:07+00:00",
        "first_name": "Gareth",
        "updated_at": "2025-01-21T09:11:07+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": "2025-01-21T09:11:07+00:00",
        "has_joint_account": true,
        "current_time_entry": "App\\Http\\Resources\\TimeEntryResource",
        "first_contact_date": "2025-01-21T09:11:07+00:00",
        "external_references": "App\\Http\\Resources\\ExternalReferenceResource",
        "assigned_paraplanner": "App\\Http\\Resources\\AccountResource",
        "previous_review_date": "2025-01-21T09:11:07+00:00",
        "primary_phone_number": "App\\Http\\Resources\\ContactDetailResource",
        "assigned_administrator": "App\\Http\\Resources\\AccountResource",
        "anniversary_review_date": "2025-01-21T09:11:07+00:00"
      },
      "primary_email": {
        "name": "Work number",
        "type": "phone_number",
        "uuid": "2ab976ea-a48a-47b2-8f89-ddd1b5f89c7d",
        "value": "+443330903630",
        "accounts": "App\\Http\\Resources\\AccountResource",
        "created_at": "2025-01-21T09:11:07+00:00",
        "updated_at": "2025-01-21T09:11:07+00:00",
        "phone_number_meta": {
          "country": "GB",
          "formatted": "0333 090 3630"
        }
      },
      "can_be_deleted": "false",
      "assigned_adviser": {
        "firm": "App\\Http\\Resources\\FirmResource",
        "name": "Gareth Thompson",
        "role": "client",
        "tags": "App\\Http\\Resources\\TagResource",
        "type": "client",
        "uuid": "191741b8-cb6c-4815-8765-2f1bc203fe8c",
        "email": "gareth@codepotato.co.uk",
        "groups": "App\\Http\\Resources\\GroupResource",
        "owners": "App\\Http\\Resources\\AccountResource",
        "last_name": "Thompson",
        "created_at": "2025-01-21T09:11:07+00:00",
        "first_name": "Gareth",
        "updated_at": "2025-01-21T09:11:07+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": "2025-01-21T09:11:07+00:00",
        "has_joint_account": true,
        "current_time_entry": "App\\Http\\Resources\\TimeEntryResource",
        "first_contact_date": "2025-01-21T09:11:07+00:00",
        "external_references": "App\\Http\\Resources\\ExternalReferenceResource",
        "assigned_paraplanner": "App\\Http\\Resources\\AccountResource",
        "previous_review_date": "2025-01-21T09:11:07+00:00",
        "primary_phone_number": "App\\Http\\Resources\\ContactDetailResource",
        "assigned_administrator": "App\\Http\\Resources\\AccountResource",
        "anniversary_review_date": "2025-01-21T09:11:07+00:00"
      },
      "next_review_date": "2025-01-21T09:11:07+00:00",
      "has_joint_account": true,
      "current_time_entry": {
        "name": "Research",
        "uuid": "8a81799c-859b-48e2-86d5-2537c9ce055c",
        "account": "App\\Http\\Resources\\MinimalAccountResource",
        "end_date": "2025-01-21T08:49:07+00:00",
        "is_active": true,
        "trackable": "App\\Http\\Resources\\MinimalAccountResource",
        "created_at": "2025-01-21T09:11:07+00:00",
        "start_date": "2025-01-21T08:21:07+00:00",
        "updated_at": "2025-01-21T09:11:07+00:00",
        "description": "This is a description.",
        "trackable_type": "Client",
        "total_time_in_minutes": 28,
        "computed_time_elapsed_in_seconds": 1680
      },
      "first_contact_date": "2025-01-21T09:11:07+00:00",
      "external_references": [
        {
          "uuid": "a5e56464-306f-4366-b468-d830a9d98701",
          "reference": "AB123456",
          "created_at": "2025-01-21T09:11:07+00:00",
          "updated_at": "2025-01-21T09:11:07+00:00",
          "third_party": "nucleus"
        }
      ],
      "assigned_paraplanner": {
        "firm": "App\\Http\\Resources\\FirmResource",
        "name": "Gareth Thompson",
        "role": "client",
        "tags": "App\\Http\\Resources\\TagResource",
        "type": "client",
        "uuid": "679af886-8b23-491a-af46-500e5dca5af3",
        "email": "gareth@codepotato.co.uk",
        "groups": "App\\Http\\Resources\\GroupResource",
        "owners": "App\\Http\\Resources\\AccountResource",
        "last_name": "Thompson",
        "created_at": "2025-01-21T09:11:07+00:00",
        "first_name": "Gareth",
        "updated_at": "2025-01-21T09:11:07+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": "2025-01-21T09:11:07+00:00",
        "has_joint_account": true,
        "current_time_entry": "App\\Http\\Resources\\TimeEntryResource",
        "first_contact_date": "2025-01-21T09:11:07+00:00",
        "external_references": "App\\Http\\Resources\\ExternalReferenceResource",
        "assigned_paraplanner": "App\\Http\\Resources\\AccountResource",
        "previous_review_date": "2025-01-21T09:11:07+00:00",
        "primary_phone_number": "App\\Http\\Resources\\ContactDetailResource",
        "assigned_administrator": "App\\Http\\Resources\\AccountResource",
        "anniversary_review_date": "2025-01-21T09:11:07+00:00"
      },
      "previous_review_date": "2025-01-21T09:11:07+00:00",
      "primary_phone_number": {
        "name": "Work number",
        "type": "phone_number",
        "uuid": "7dd9c494-6c92-4a35-8bd8-fb2b26ea269a",
        "value": "+443330903630",
        "accounts": "App\\Http\\Resources\\AccountResource",
        "created_at": "2025-01-21T09:11:07+00:00",
        "updated_at": "2025-01-21T09:11:07+00:00",
        "phone_number_meta": {
          "country": "GB",
          "formatted": "0333 090 3630"
        }
      },
      "assigned_administrator": {
        "firm": "App\\Http\\Resources\\FirmResource",
        "name": "Gareth Thompson",
        "role": "client",
        "tags": "App\\Http\\Resources\\TagResource",
        "type": "client",
        "uuid": "19931d11-7c86-4134-ae12-683397557768",
        "email": "gareth@codepotato.co.uk",
        "groups": "App\\Http\\Resources\\GroupResource",
        "owners": "App\\Http\\Resources\\AccountResource",
        "last_name": "Thompson",
        "created_at": "2025-01-21T09:11:07+00:00",
        "first_name": "Gareth",
        "updated_at": "2025-01-21T09:11:07+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": "2025-01-21T09:11:07+00:00",
        "has_joint_account": true,
        "current_time_entry": "App\\Http\\Resources\\TimeEntryResource",
        "first_contact_date": "2025-01-21T09:11:07+00:00",
        "external_references": "App\\Http\\Resources\\ExternalReferenceResource",
        "assigned_paraplanner": "App\\Http\\Resources\\AccountResource",
        "previous_review_date": "2025-01-21T09:11:07+00:00",
        "primary_phone_number": "App\\Http\\Resources\\ContactDetailResource",
        "assigned_administrator": "App\\Http\\Resources\\AccountResource",
        "anniversary_review_date": "2025-01-21T09:11:07+00:00"
      },
      "anniversary_review_date": "2025-01-21T09:11:07+00:00"
    }
  ]
}