MarketplaceUsernames
List all the marketplace usernames of the customers.
Select
The add-in 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 add-in.
- CustomerId supports the following operator: =.
Note: CustomerId is required in order to query MarketplaceUserNames. For example, the following query is processed server side:
SELECT * FROM MarketplaceUserNames WHERE CustomerId = 1368175
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Marketplace customer user Id. | |
| CustomerId [KEY] | Long |
Customers.Id | Id of the customer. |
| CreateDate | Datetime | Create date of this record. | |
| Marketplace | String | Name of the marketplace. | |
| MarketplaceId | Integer | Id of the marketplace. | |
| ModifyDate | Datetime | Modify date of this record. | |
| Username | String | Username of the customers. |