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": "40423b9a-d98c-4e1e-a83b-4dfb759cec85",
        "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": "2024-11-20T13:23:59+00:00",
        "updated_at": "2024-11-20T13:23:59+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": "75276522-9a5c-40e7-accd-7deb19d82ec9",
          "colour": "#ef4582",
          "created_at": "2024-11-20T13:23:59+00:00",
          "updated_at": "2024-11-20T13:23:59+00:00"
        }
      ],
      "type": "client",
      "uuid": "ce24e3ae-c2e4-4471-b83c-4f5fbfde6757",
      "email": "gareth@codepotato.co.uk",
      "groups": [
        {
          "name": "finance",
          "slug": "finance",
          "uuid": "a0751117-b197-4f3a-a923-75b6b90d56cd",
          "created_at": "2024-11-20T13:23:59+00:00",
          "updated_at": "2024-11-20T13:23:59+00:00",
          "participants": {
            "name": {
              "example": "Gareth Thompson",
              "description": "Name of the account"
            },
            "role": {
              "example": "client",
              "description": "Role of the account"
            },
            "uuid": {
              "example": "2f763b17-9f0f-4501-93cf-a27f80ced871",
              "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": "de0c6bb2-7ee0-4301-980b-7fe4a00cd775",
          "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"
        }
      ],
      "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": [
        {
          "name": "Favourite Drink",
          "type": "string",
          "uuid": "1054b86a-fcde-4f0e-b045-39f9516414ab",
          "value": "Coffee",
          "help_text": "This is the client's favourite drink.",
          "reference": "favourite_drink",
          "created_at": "2024-11-20T13:23:59+00:00",
          "updated_at": "2024-11-20T13:23:59+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": "61375724-f439-496b-93ef-b8a42a6b8388",
        "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"
      },
      "primary_email": {
        "name": "Work number",
        "type": "phone_number",
        "uuid": "cebe1ff6-45e9-42ed-a016-d01f533b758e",
        "value": "+443330903630",
        "accounts": "App\\Http\\Resources\\AccountResource",
        "created_at": "2024-11-20T13:23:59+00:00",
        "updated_at": "2024-11-20T13:23:59+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": "0e9d264b-8276-4b30-83bc-6785158a34e5",
        "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"
      },
      "next_review_date": "2024-11-20T13:23:59+00:00",
      "has_joint_account": true,
      "current_time_entry": {
        "name": "Research",
        "uuid": "763c6315-003b-4df8-98c8-eb130bf67616",
        "end_date": "2024-11-20T13:23:59+00:00",
        "is_active": "1",
        "trackable": "Client",
        "start_date": "2024-11-20T13:23:59+00:00"
      },
      "first_contact_date": "2024-11-20T13:23:59+00:00",
      "external_references": [
        {
          "uuid": "a7c783f8-ec44-45ab-8bbe-1ec67f3ecf69",
          "reference": "AB123456",
          "created_at": "2024-11-20T13:23:59+00:00",
          "updated_at": "2024-11-20T13:23:59+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": "69852610-e58d-490f-a36a-07bdf489fa78",
        "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"
      },
      "previous_review_date": "2024-11-20T13:23:59+00:00",
      "primary_phone_number": {
        "name": "Work number",
        "type": "phone_number",
        "uuid": "2332844d-2e91-4c88-98eb-b41255ff7fcb",
        "value": "+443330903630",
        "accounts": "App\\Http\\Resources\\AccountResource",
        "created_at": "2024-11-20T13:23:59+00:00",
        "updated_at": "2024-11-20T13:23:59+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": "14d90c96-1fe2-47f7-9a53-d70455d045ce",
        "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"
      },
      "anniversary_review_date": "2024-11-20T13:23:59+00:00"
    }
  ]
}