JDBC Driver for ShipStation

Build 22.0.8462

MarketplaceUsernames

List all the marketplace usernames of the customers.

Select

The driver 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 driver.

  • 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
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462