Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Live Search
spaceKeyHG
additionalpage excerpt
placeholderSearch for a solution
typepage

The Users and Accounts API feed
Info

The Users API feed endpoints allows you to integrate User and Account information with other employee and customer-based software such as HRMS and CRM.

The feed is available if you have the API Feeds module. Please speak to your CSM to find out more about this module.

Purpose of the API

Feed

Feeds

This

The Users

and Accounts

API

Feed could

Feeds can be used to connect your accessplanit platform to other employee or customer platforms, such as your CRM system to sync your customer contacts, or your HR system to sync your employees.

Connecting your platforms and syncing the data between them removes the need for double data entry, reduces the risk of human error and eases the headache of managing multiple pieces of software!


Fields Available in the API Feeds

There are three

feeds included for Users and Accounts data

endpoints available for User & Account data, please see the below tables for the data that is available in each.

Each of these three feeds

can be used to read data from, send updates to, and create new records in your accessplanit platform

have different levels of reading, creating, and updating, the tables below explain what actions are available for the fields in each feed.

Users

This feed is used for accessing the details of Users within the database.

It is possible to create and update Users via the feed, please see the below table to view which fields can be used when creating and updating Users.

Field

GET
(Read)

GET
(Filter)

PUT
(Update)

POST
(Create new)

Validation for PUT & POST

User ID

(tick)

(tick)

(error)

(tick)

Max

10 chars

characters 10

Title (Mr, Mrs, etc.)

(tick)

(tick)

(tick)

(tick)

Must exist as a title in your accessplanit platform (i.e. Mr, Ms, Dr, Mx)

Forenames

(tick)

(tick)

(tick) Mandatory

(tick) Mandatory

Middle Name

Max characters 50

Middle Names

(tick)

(tick)

(tick)

(tick)

Max characters 250

Surname 

(tick)

(tick)

(tick) Mandatory

(tick) Mandatory

External ID 

Max characters 40

Status

(tick)

(tick)

(tick)

(error)

(error)

n/a

Email Address 

(tick)

(tick)

(tick)

(tick)

Valid

Postcode 

(tick)

Must be in an email address format

Max characters 80

Date of Birth

(tick)

(tick)

(tick)

(tick)

Date (i.e. "1985-01-12")

Date must be in the past

Phone Number 

(tick)

(tick)

(tick)

(tick)

Must be a valid phone number, extensions are accepted

Max characters 25

Mobile Number

(tick)

(tick)

(tick)

(tick)

Max characters 25

Job Title

(tick)

(tick)

(tick)

(tick)

Max characters 255

Marketing Opt-in 

(tick)

(tick)

(tick)

(tick)

True or False

Address

(tick)

(tick)

(tick)

(tick)

Max characters 150

Town 

(tick)

(tick)

(tick)

(tick)

Max characters 60

County 

(tick)

(tick)

(tick)

(tick)

Max characters 30

Postcode 

(tick)

(tick)

(tick)

(tick)

Max characters 10

Country 

(tick)

(tick)

(tick)

(tick)

Must be a valid country

External ID 

(tick)

Y - must exist in the platform already

(tick)

(tick)

(tick)

Max characters 50

Date Updated

(tick)

(tick)

(error)

(error)

n/a

Main Account / Company ID

(tick)

(tick)

(tick) Mandatory

(tick) Mandatory

Must validate against an existing

Company

Account in your accessplanit platform

Main Account / Company Name

(tick)

(tick)

(tick)

(error)

Status

(tick)

(tick)

(tick)

Preferred

Date of Birth

(tick)

(tick)

(tick)

(error)

Main Account should be created and updated using MainCompanyID

(Preferred) Method of Contact

(tick)

(error)

(tick)

(tick)

Must exist as a method of contact in your accessplanit platform (i.e. Email, Phone, SMS)

Gender

(tick)

(tick)

(error)

(tick)

Title (Mr, Mrs, etc.)

(tick)

(tick)

(tick)

Must exist as a gender in your accessplanit platform (i.e. Female, Male, Unspecified, Other)

User Based Custom Fields

(tick)

(error)

(tick)

(tick)

Validation on POST & PUT requests are subject to custom field type used, for example a valid date must be provided for Custom Fields with a type of ‘date’

Here are some example filters that you are able to use with your Users API Feed:

Only include users that have opted into marketing:

  • {{apiroot}}/users?MarketingOptIn=true

Only include a specific User

  • {{apiroot}}/users?UserID=TaShall

Only include users updated since 20th August 2022

  • {{apiroot}}/users?DateUpdated=gt:2022-08-20T00:00:00

Only include users born between 1990 and 2010

  • {{apiroot}}/users?DateOfBirth=gt:1990-01-01T00:00:00&lt:2010-12-31T23:59:59

Only include users that have a title of "Dr"

  • {{apiroot}}/users?Title=”Dr”

Only include users with a status of “Locked”

  • {{apiroot}}/users?Status=Locked

Only include users that do not have an email address

  • {{apiroot}}/users?EmailAddress=NULL

Only include users that have a middle name

  • {{apiroot}}/users?MiddleNames=not:NULL


Companies

This feed is used for accessing the details of Accounts within the database. Accounts are used to group Users and manage their employment records.

It is possible to create and update Accounts via the feed, please see the below table to view which fields can be used when creating and updating Accounts.

Field

GET
(Read)

GET
(Filter)

PUT
(Update)

POST
(Create new)

Validation for PUT & POST

Account ID   

(tick)

(tick)

(error)

(tick)

Max characters 10

Name

(tick)

(tick)

(tick) Mandatory

Email Address

(tick)

(tick)

(tick)

Valid email address format

Mandatory

Max characters 255

Main Contact User ID

(tick)

(tick)

(tick)

(tick)

Must validate against an existing User

ID

in your accessplanit platform

Email Address

(tick)

(tick)

(tick)

(tick)

Must be in an email address format

Max characters 80

External ID

(tick)

(tick)

(tick)

(tick)

Max characters 50

Address

(tick)

(tick)

(tick)

(tick)

Max characters 150

Town

(tick)

(tick)

(tick)

(tick)

Max characters 60

County

(tick)

(tick)

(tick)

(tick)

Max characters 50

Postcode

(tick)

(tick)

(tick)

(tick)

Max characters 15

Country

(tick)

(tick)

(tick)

(tick)

Postcode

Must be a valid country

Phone

(tick)

(tick)

(tick)

(tick)

Must be a valid phone number, extensions are accepted

Max characters 25

Date Updated

(tick)

(tick)

(error)

(error)

n/a

Account Group IDs

(tick)
Via Links

(error)

(tick)

On this page:

toc

(error)

(tick) Mandatory

Must validate against existing Company Group

Account Based Custom Fields

(tick)

(error)

(tick)

(tick)

Validation on POST & PUT requests are subject to custom field type used, for example a valid date must be provided for Custom Fields with a type of ‘date’

Here are some example filters that you are able to use with your Companies API Feed:

Only include a specific Account

  • {{apiroot}}/companies?CompanyID=TEST01

Only include Accounts updated since 20th August 2022

  • {{apiroot}}/companies?DateUpdated=gt:2022-08-20T00:00:00

Only include Accounts that do not have an external ID

  • {{apiroot}}/companies?ExternalID=NULL

Only include Accounts that have an email address

  • {{apiroot}}/companies?EmailAddress=not:NULL


Company Groups

This feed is used for accessing the details of Account Groups within the database. Account Groups are used to categorise and group Accounts.

It is possible to create and update Account Groups via the feed, please see the below table to view which fields can be used when creating and updating Account Groups.

It is not yet possible to filter the results of GET request for Accounts, other than specifying the account group’s ID via

  • {{apiroot}}/companygroup/[company group ID]

Field

GET
(Read)

GET
(Filter)

PUT
(Update)

POST
(Create new)

Validation

Account Group ID

(tick)

(tick)

(error)

(tick)

Max characters 10

Account Group Label Name

(tick)

(error)

(tick) Mandatory

(tick)
Mandatory

Max characters 50


Connecting to the API

Note

DISCLAIMER: By using accessplanit APIs, you agree to our terms of use.

To gain access to the Users and Accounts API Feed please speak to the CSM team at accessplanit on csm@accessplanit.com

As the API Feeds are an additional module, please contact your assigned Customer Success Manager (CSM) to gain access to them for your integrations.