Windsor brings all your Zendesk data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL
Zendesk Field Reference
Sample
This connector fetches data from Zendesk on a contact/user level.
https://connectors.windsor.ai/zendesk?api_key=[API Key]&date_preset=last_7d&fields=name,phone,email
Fields
ID | Type | Name | Description |
---|---|---|---|
confirmed | BOOLEAN | Confirmed | Indicates whether the user's account has been confirmed or not. |
created_at | DATE | Created at | Timestamp of creation in UTC (ISO8601 format). |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
deleted_at | DATE | Deleted at | Timestamp of deletion in UTC (ISO8601 format) in case the user has been deleted. |
TEXT | Email address of the user. | ||
group | TEXT | Group | Group the user belongs to. The group entry includes a unique identifier and a name. |
id | TEXT | ID | Unique identifier of user |
identity_type | TEXT | Identity Type | The user can be either a person (an agent) or an integration (an internal system user). Possible values: person, integration |
invited | BOOLEAN | Invited | Indicates whether an invitation has been sent to the user or not. Usually true. |
name | TEXT | Name | Full name of the user. |
phone | TEXT | Phone Number | Contact phone number of the user. |
reports_to | NUMERIC | Reports to | Unique identifier of the manager of the user. |
role | TEXT | Role | Role of the user. Notice that this attribute has no connection with role based access control and permissions. It indicates whether the user is an admin or a regular user. Possible values: user, admin |
roles | TEXT | Roles | An array of roles assigned to the user. Each entry in the array includes a unique identifier of the role and it's name. You can expect unique values in the array. RBAC API is not yet public. |
source | TEXT | Source | The name of the Windsor connector returning the row |
status | TEXT | Status | Status of the user's account. Usually active. Possible values: active, inactive. |
team_name | TEXT | Team Name | Name of the team the user belongs to. |
timezone | TEXT | Timezone | Timezone of the user as the offset from Coordinated Universal Time (UTC) in the format `UTC(+ |
today | DATE | Today | Today's date |
updated_at | DATE | Updated at | Timestamp of the last update in UTC (ISO8601 format). |
zendesk_user_id | TEXT | Zendesk User ID | If your Sell account is linked to a Zendesk account, the user will have a Zendesk user ID. |