PeopleProfilesByWebsiteId: Crisp People Profiles
insert REST
- Catalog:
Crisp - Schema:
Crisp - Primary Keys:
people_id - Label: People Profiles
Can retrieve data and change data using insert.
Summary
Lists people profiles for website.
API Source
- Endpoint:
/website/{website_id}/people/profiles/{page_number}?per_page=50
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
filter_ |
datetime |
Retrieve only the people profiles created at or before this moment (UTC). | ||
filter_ |
datetime |
Retrieve only the people profiles created at or after this moment (UTC). | ||
search_ |
varchar2 |
Search filter as the JSON text the route documents. | ||
search_ |
varchar2 |
Search operator when a search filter is given; and or or, defaults to and. | ||
search_ |
varchar2 |
Search term over all people profiles. | ||
sort_ |
varchar2 |
Sort the people profiles on this field; one of the available search field names. | ||
sort_ |
varchar2 |
Sort order; ascending or descending. | ||
website_ |
varchar2 |
The website identifier. Defaults to the website ID of the connection when left out. |
Table Columns
The columns of the table PeopleProfilesByWebsiteId are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
active_ |
datetime |
itgen_crp_active_last | filters on the platform, writable, active. |
Timestamp at which the user was last active. | |
active_ |
char |
itgen_crp_active_now | filters on the platform, writable, active. |
Whether user is considered active right now or not. | |
company_ |
varchar2 |
itgen_crp_company_description | filters on the platform, writable, company. |
Company description. | |
company_ |
varchar2 |
itgen_crp_company_domain | filters on the platform, writable, company. |
Company domain name. | |
company_ |
varchar2 |
itgen_crp_company_geolocation_city | filters on the platform, writable, company. |
City name. | |
company_ |
decimal |
itgen_crp_company_geolocation_coordinates_latitude | filters on the platform, writable, company. |
Latitude coordinate. | |
company_ |
decimal |
itgen_crp_company_geolocation_coordinates_longitude | filters on the platform, writable, company. |
Longitude coordinate. | |
company_ |
varchar2 |
itgen_crp_company_geolocation_country | filters on the platform, writable, company. |
Country code. | |
company_ |
varchar2 |
itgen_crp_company_geolocation_region | filters on the platform, writable, company. |
Region code. | |
company_ |
varchar2 |
itgen_crp_company_legal_name | filters on the platform, writable, company. |
Company legal name. | |
company_ |
decimal |
itgen_crp_company_metrics_arr | filters on the platform, writable, company. |
Annual recurring revenue. | |
company_ |
int32 |
itgen_crp_company_metrics_employees | filters on the platform, writable, company. |
Number of employees. | |
company_ |
decimal |
itgen_crp_company_metrics_market_cap | filters on the platform, writable, company. |
Market capitalization. | |
company_ |
decimal |
itgen_crp_company_metrics_raised | filters on the platform, writable, company. |
Money raised. | |
company_ |
varchar2 |
itgen_crp_company_name | filters on the platform, writable, company. |
Company name. | |
company_ |
int32 |
itgen_crp_company_timezone | filters on the platform, writable, company. |
Company time zone offset in minutes relative to UTC, negated (-120 stands for UTC+02:00). | |
company_ |
varchar2 |
itgen_crp_company_url | filters on the platform, writable, company. |
Company website URL. | |
created_ |
datetime |
itgen_crp_created_at | filters on the platform, writable | Profile creation timestamp. | |
email |
varchar2 |
itgen_crp_email | filters on the platform, writable | Email for people profile. | |
notepad |
varchar2 |
itgen_crp_notepad | filters on the platform, writable | Private notepad on people profile. | |
people_ |
varchar2 |
itgen_crp_people_id | filters on the platform, writable | People identifier. | |
person_ |
varchar2 |
itgen_crp_person_address | filters on the platform, writable, person. |
Address for user. | |
person_ |
varchar2 |
itgen_crp_person_avatar | filters on the platform, writable, person. |
Avatar for user. | |
person_ |
varchar2 |
itgen_crp_person_description | filters on the platform, writable, person. |
Description for user. | |
person_ |
varchar2 |
itgen_crp_person_employment_domain | filters on the platform, writable, person. |
Company domain name. | |
person_ |
varchar2 |
itgen_crp_person_employment_name | filters on the platform, writable, person. |
Company name. | |
person_ |
varchar2 |
itgen_crp_person_employment_role | filters on the platform, writable, person. |
User role in company. | |
person_ |
varchar2 |
itgen_crp_person_employment_seniority | filters on the platform, writable, person. |
User seniority in company. | |
person_ |
varchar2 |
itgen_crp_person_employment_title | filters on the platform, writable, person. |
User title in company. | |
person_ |
varchar2 |
itgen_crp_person_gender | filters on the platform, writable, person. |
Gender for user; one of male and female. | |
person_ |
varchar2 |
itgen_crp_person_geolocation_city | filters on the platform, writable, person. |
City name. | |
person_ |
decimal |
itgen_crp_person_geolocation_coordinates_latitude | filters on the platform, writable, person. |
Latitude coordinate. | |
person_ |
decimal |
itgen_crp_person_geolocation_coordinates_longitude | filters on the platform, writable, person. |
Longitude coordinate. | |
person_ |
varchar2 |
itgen_crp_person_geolocation_country | filters on the platform, writable, person. |
Country code. | |
person_ |
varchar2 |
itgen_crp_person_geolocation_region | filters on the platform, writable, person. |
Region code. | |
person_ |
varchar2 |
itgen_crp_person_nickname | filters on the platform, writable, person. |
Nickname for user (includes first name and last name). | |
person_ |
varchar2 |
itgen_crp_person_phone | filters on the platform, writable, person. |
Phone number for user. | |
person_ |
int32 |
itgen_crp_person_timezone | filters on the platform, writable, person. |
Time zone offset of user in minutes relative to UTC, negated (-120 stands for UTC+02:00). | |
person_ |
varchar2 |
itgen_crp_person_website | filters on the platform, writable, person. |
Website of user. | |
score |
int16 |
itgen_crp_score | filters on the platform, writable | Score associated to this profile, from 1 to 5 (based on ratings from user). | |
updated_ |
datetime |
itgen_crp_updated_at | filters on the platform, writable | Profile update timestamp. |
Referenced By
- ConversationsByWebsiteId
people_id(Textual) - PeopleLocalesByWebsiteId
people_id(Candidate) - PeopleSegmentsByWebsiteId
people_id(Candidate)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: