invantive documentation
Invantive Support ForumsLog In / Sign Up

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_date_end datetime Retrieve only the people profiles created at or before this moment (UTC).
filter_date_start datetime Retrieve only the people profiles created at or after this moment (UTC).
search_filter varchar2 Search filter as the JSON text the route documents.
search_operator varchar2 Search operator when a search filter is given; and or or, defaults to and.
search_text varchar2 Search term over all people profiles.
sort_field varchar2 Sort the people profiles on this field; one of the available search field names.
sort_order varchar2 Sort order; ascending or descending.
website_id 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_last datetime itgen_crp_active_last filters on the platform, writable, active.last Timestamp at which the user was last active.
active_now char itgen_crp_active_now filters on the platform, writable, active.now Whether user is considered active right now or not.
company_description varchar2 itgen_crp_company_description filters on the platform, writable, company.description Company description.
company_domain varchar2 itgen_crp_company_domain filters on the platform, writable, company.domain Company domain name.
company_geolocation_city varchar2 itgen_crp_company_geolocation_city filters on the platform, writable, company.geolocation.city City name.
company_geolocation_coordinates_latitude decimal itgen_crp_company_geolocation_coordinates_latitude filters on the platform, writable, company.geolocation.coordinates.latitude Latitude coordinate.
company_geolocation_coordinates_longitude decimal itgen_crp_company_geolocation_coordinates_longitude filters on the platform, writable, company.geolocation.coordinates.longitude Longitude coordinate.
company_geolocation_country varchar2 itgen_crp_company_geolocation_country filters on the platform, writable, company.geolocation.country Country code.
company_geolocation_region varchar2 itgen_crp_company_geolocation_region filters on the platform, writable, company.geolocation.region Region code.
company_legal_name varchar2 itgen_crp_company_legal_name filters on the platform, writable, company.legal_name Company legal name.
company_metrics_arr decimal itgen_crp_company_metrics_arr filters on the platform, writable, company.metrics.arr Annual recurring revenue.
company_metrics_employees int32 itgen_crp_company_metrics_employees filters on the platform, writable, company.metrics.employees Number of employees.
company_metrics_market_cap decimal itgen_crp_company_metrics_market_cap filters on the platform, writable, company.metrics.market_cap Market capitalization.
company_metrics_raised decimal itgen_crp_company_metrics_raised filters on the platform, writable, company.metrics.raised Money raised.
company_name varchar2 itgen_crp_company_name filters on the platform, writable, company.name Company name.
company_timezone int32 itgen_crp_company_timezone filters on the platform, writable, company.timezone Company time zone offset in minutes relative to UTC, negated (-120 stands for UTC+02:00).
company_url varchar2 itgen_crp_company_url filters on the platform, writable, company.url Company website URL.
created_at 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_id varchar2 itgen_crp_people_id filters on the platform, writable People identifier.
person_address varchar2 itgen_crp_person_address filters on the platform, writable, person.address Address for user.
person_avatar varchar2 itgen_crp_person_avatar filters on the platform, writable, person.avatar Avatar for user.
person_description varchar2 itgen_crp_person_description filters on the platform, writable, person.description Description for user.
person_employment_domain varchar2 itgen_crp_person_employment_domain filters on the platform, writable, person.employment.domain Company domain name.
person_employment_name varchar2 itgen_crp_person_employment_name filters on the platform, writable, person.employment.name Company name.
person_employment_role varchar2 itgen_crp_person_employment_role filters on the platform, writable, person.employment.role User role in company.
person_employment_seniority varchar2 itgen_crp_person_employment_seniority filters on the platform, writable, person.employment.seniority User seniority in company.
person_employment_title varchar2 itgen_crp_person_employment_title filters on the platform, writable, person.employment.title User title in company.
person_gender varchar2 itgen_crp_person_gender filters on the platform, writable, person.gender Gender for user; one of male and female.
person_geolocation_city varchar2 itgen_crp_person_geolocation_city filters on the platform, writable, person.geolocation.city City name.
person_geolocation_coordinates_latitude decimal itgen_crp_person_geolocation_coordinates_latitude filters on the platform, writable, person.geolocation.coordinates.latitude Latitude coordinate.
person_geolocation_coordinates_longitude decimal itgen_crp_person_geolocation_coordinates_longitude filters on the platform, writable, person.geolocation.coordinates.longitude Longitude coordinate.
person_geolocation_country varchar2 itgen_crp_person_geolocation_country filters on the platform, writable, person.geolocation.country Country code.
person_geolocation_region varchar2 itgen_crp_person_geolocation_region filters on the platform, writable, person.geolocation.region Region code.
person_nickname varchar2 itgen_crp_person_nickname filters on the platform, writable, person.nickname Nickname for user (includes first name and last name).
person_phone varchar2 itgen_crp_person_phone filters on the platform, writable, person.phone Phone number for user.
person_timezone int32 itgen_crp_person_timezone filters on the platform, writable, person.timezone Time zone offset of user in minutes relative to UTC, negated (-120 stands for UTC+02:00).
person_website varchar2 itgen_crp_person_website filters on the platform, writable, person.website 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_at datetime itgen_crp_updated_at filters on the platform, writable Profile update timestamp.

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: