Users
Returns user account records, including name, email, status, and login details.
View-Specific Information
Select
The provider will use the ShipStation API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the provider.
- Status supports the following operator: =.
SELECT * FROM Users WHERE Status = 'active'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A string that uniquely identifies the user. | |
| Name | String | The full name of the user. | |
| Username | String | The username of the user. | |
| String | The email address of the user. | ||
| Status | String | The status of the user.
The allowed values are active, inactive, locked_out, email_lock. | |
| LastLoginAt | Date | The date the user last logged in. | |
| CreatedAt | Date | The date the user was created. |