# PeopleSocialMediaProfiles: Crisp People Social Media Profiles - Catalog: `Crisp` - Schema: `Views` - Label: People Social Media Profiles This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `PeopleSocialMediaProfiles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `company_name` | `varchar2` | | ☐ | Company name. | | `company_name` | `varchar2` | | ☐ | Company name. | | `handle` | `varchar2` | | ☑ | User handle on online platform. | | `handle` | `varchar2` | | ☑ | User handle on online platform. | | `people_id` | `varchar2` | | ☑ | People identifier. | | `people_id` | `varchar2` | | ☑ | People identifier. | | `person_created_at` | `datetime` | | ☑ | Profile creation timestamp. | | `person_created_at` | `datetime` | | ☑ | Profile creation timestamp. | | `person_email` | `varchar2` | | ☑ | Email for people profile. | | `person_email` | `varchar2` | | ☑ | Email for people profile. | | `person_updated_at` | `datetime` | | ☑ | Profile update timestamp. | | `person_updated_at` | `datetime` | | ☑ | Profile update timestamp. | | `type` | `varchar2` | | ☑ | Type of social media profile, such as facebook or twitter. | | `type` | `varchar2` | | ☑ | Type of social media profile, such as facebook or twitter. | | `url` | `varchar2` | | ☐ | URL for the profile. | | `url` | `varchar2` | | ☐ | URL for the profile. |# PeopleSocialMediaProfiles: Crisp People Social Media Profiles - Catalog: `Crisp` - Schema: `Views` - Label: People Social Media Profiles This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `PeopleSocialMediaProfiles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `company_name` | `varchar2` | | ☐ | Company name. | | `company_name` | `varchar2` | | ☐ | Company name. | | `handle` | `varchar2` | | ☑ | User handle on online platform. | | `handle` | `varchar2` | | ☑ | User handle on online platform. | | `people_id` | `varchar2` | | ☑ | People identifier. | | `people_id` | `varchar2` | | ☑ | People identifier. | | `person_created_at` | `datetime` | | ☑ | Profile creation timestamp. | | `person_created_at` | `datetime` | | ☑ | Profile creation timestamp. | | `person_email` | `varchar2` | | ☑ | Email for people profile. | | `person_email` | `varchar2` | | ☑ | Email for people profile. | | `person_updated_at` | `datetime` | | ☑ | Profile update timestamp. | | `person_updated_at` | `datetime` | | ☑ | Profile update timestamp. | | `type` | `varchar2` | | ☑ | Type of social media profile, such as facebook or twitter. | | `type` | `varchar2` | | ☑ | Type of social media profile, such as facebook or twitter. | | `url` | `varchar2` | | ☐ | URL for the profile. | | `url` | `varchar2` | | ☐ | URL for the profile. |