Users
Query Users.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operator. The connector processes other filters client-side within the connector.
- Id supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM Users
SELECT * FROM Users WHERE Id = 123
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | The ID of the user. | |
| FirstName | String | The first name of the user. | |
| String | The email of the user. | ||
| Url | String | The url of the user. | |
| IM | String | The IM of the user. | |
| ScreenName | String | The screen name of the user. | |
| Phone | String | The phone number of the of the user. | |
| LastName | String | The last name of the user. | |
| AccountOwner | Bool | If the user is the account owner. | |
| ReceiveAnnouncements | Bool | If the user receives announcements. | |
| Bio | String | The bio of the user. | |
| Permissions | String | The list of permissions of the user. | |
| Locale | String | The Locale of the user. | |
| UserType | String | The type of the user. | |
| AdminGraphQLAPIId | String | The Admin GraphQL API Id of the user. | |
| TFAEnabled | Bool | If TFA is enabled. |