Skip to main content

Plecto's Data Model

When creating data sources in Plecto, think of them as tables in an SQL database. This is not exactly how we store them, but conceptually it's very similar. Here are some good-to-knows:

  • As Plecto currently does not support joins, please make sure to include any necessary information for filtering purposes inside each "row." In addition, make sure that all data is encoded in utf-8.

  • Plecto has certain API limits – you can send up to 100 registrations per request and a total max of 3600 requests per hour.

Here's a list of field names, types and descriptions that make up Plecto's API data model:

Field name

Type

Description

data_source

string (UUID)

UUID of a Plecto data source which you must create first via the GUI or dedicated API methods.

date

ISO 8601 with timestamp

Primary date of this data registration. For example, for a sales opportunity, you could use the expected close date. You can add more date fields, but this will be the default.

member_api_provider

string

Name of the system where the member_api_id and member_name originate. For example, Salesforce, Podio, datawarehouse, activedirectory.

member_api_id

string

Employee ID in the member API provider's database.

member_name

string

Full name of the employee.

external_id

string

Unique ID of a registration.

<custom field>

<type selected>

You can add more fields from the GUI or via data source API methods.