invantive documentation
Forum di supporto InvantiveAccedi / Registrati

PeopleProfilesByWebsiteId: Crisp People Profiles

insert REST

  • Catalogo: Crisp
  • Schema: Crisp
  • Chiavi primarie: people_id
  • Label: People Profiles

È possibile recuperare e modificare i dati utilizzando insert.

Lists people profiles for website.

Codice sorgente dell'API

  • Punto finale: /website/{website_id}/people/profiles/{page_number}?per_page=50

Parametri

Name Tipo di dati 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.

Colonne della tabella

Di seguito sono riportate le colonne della tabella PeopleProfilesByWebsiteId. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
active_last datetime itgen_crp_active_last filtri sulla piattaforma, modificabili, active.last Timestamp at which the user was last active.
active_now char itgen_crp_active_now filtri sulla piattaforma, modificabili, active.now Whether user is considered active right now or not.
company_description varchar2 itgen_crp_company_description filtri sulla piattaforma, modificabili, company.description Company description.
company_domain varchar2 itgen_crp_company_domain filtri sulla piattaforma, modificabili, company.domain Company domain name.
company_geolocation_city varchar2 itgen_crp_company_geolocation_city filtri sulla piattaforma, modificabili, company.geolocation.city City name.
company_geolocation_coordinates_latitude decimal itgen_crp_company_geolocation_coordinates_latitude filtri sulla piattaforma, modificabili, company.geolocation.coordinates.latitude Latitude coordinate.
company_geolocation_coordinates_longitude decimal itgen_crp_company_geolocation_coordinates_longitude filtri sulla piattaforma, modificabili, company.geolocation.coordinates.longitude Longitude coordinate.
company_geolocation_country varchar2 itgen_crp_company_geolocation_country filtri sulla piattaforma, modificabili, company.geolocation.country Country code.
company_geolocation_region varchar2 itgen_crp_company_geolocation_region filtri sulla piattaforma, modificabili, company.geolocation.region Region code.
company_legal_name varchar2 itgen_crp_company_legal_name filtri sulla piattaforma, modificabili, company.legal_name Company legal name.
company_metrics_arr decimal itgen_crp_company_metrics_arr filtri sulla piattaforma, modificabili, company.metrics.arr Annual recurring revenue.
company_metrics_employees int32 itgen_crp_company_metrics_employees filtri sulla piattaforma, modificabili, company.metrics.employees Number of employees.
company_metrics_market_cap decimal itgen_crp_company_metrics_market_cap filtri sulla piattaforma, modificabili, company.metrics.market_cap Market capitalization.
company_metrics_raised decimal itgen_crp_company_metrics_raised filtri sulla piattaforma, modificabili, company.metrics.raised Money raised.
company_name varchar2 itgen_crp_company_name filtri sulla piattaforma, modificabili, company.name Company name.
company_timezone int32 itgen_crp_company_timezone filtri sulla piattaforma, modificabili, 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 filtri sulla piattaforma, modificabili, 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 filtri sulla piattaforma, modificabili, person.address Address for user.
person_avatar varchar2 itgen_crp_person_avatar filtri sulla piattaforma, modificabili, person.avatar Avatar for user.
person_description varchar2 itgen_crp_person_description filtri sulla piattaforma, modificabili, person.description Description for user.
person_employment_domain varchar2 itgen_crp_person_employment_domain filtri sulla piattaforma, modificabili, person.employment.domain Company domain name.
person_employment_name varchar2 itgen_crp_person_employment_name filtri sulla piattaforma, modificabili, person.employment.name Company name.
person_employment_role varchar2 itgen_crp_person_employment_role filtri sulla piattaforma, modificabili, person.employment.role User role in company.
person_employment_seniority varchar2 itgen_crp_person_employment_seniority filtri sulla piattaforma, modificabili, person.employment.seniority User seniority in company.
person_employment_title varchar2 itgen_crp_person_employment_title filtri sulla piattaforma, modificabili, person.employment.title User title in company.
person_gender varchar2 itgen_crp_person_gender filtri sulla piattaforma, modificabili, person.gender Gender for user; one of male and female.
person_geolocation_city varchar2 itgen_crp_person_geolocation_city filtri sulla piattaforma, modificabili, person.geolocation.city City name.
person_geolocation_coordinates_latitude decimal itgen_crp_person_geolocation_coordinates_latitude filtri sulla piattaforma, modificabili, person.geolocation.coordinates.latitude Latitude coordinate.
person_geolocation_coordinates_longitude decimal itgen_crp_person_geolocation_coordinates_longitude filtri sulla piattaforma, modificabili, person.geolocation.coordinates.longitude Longitude coordinate.
person_geolocation_country varchar2 itgen_crp_person_geolocation_country filtri sulla piattaforma, modificabili, person.geolocation.country Country code.
person_geolocation_region varchar2 itgen_crp_person_geolocation_region filtri sulla piattaforma, modificabili, person.geolocation.region Region code.
person_nickname varchar2 itgen_crp_person_nickname filtri sulla piattaforma, modificabili, person.nickname Nickname for user (includes first name and last name).
person_phone varchar2 itgen_crp_person_phone filtri sulla piattaforma, modificabili, person.phone Phone number for user.
person_timezone int32 itgen_crp_person_timezone filtri sulla piattaforma, modificabili, 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 filtri sulla piattaforma, modificabili, 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.

Riferito da

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: