Tables

The driver models the data in Shopify as a list of tables in a relational database that can be queried using standard SQL statements.

CData JDBC Driver for Shopify Tables


Name	Description
AppFeedbacks	Reports the status of shops and their resources and displays this information within Shopify admin. AppFeedback is used to notify merchants about steps they need to take to set up an application on their store.
AppSubscriptionLineItems	Returns the plans attached to the app subscription.
AppSubscriptions	Lists all subscriptions created for a shop on the installed application.
ArticleComments	List of article comments.
Articles	List of the shop's articles.
Blogs	List of the shop's blogs.
CarrierServices	Returns a list of activated carrier services and associated shop locations that support them.
Catalogs	The catalogs belonging to the shop.
Collections	Returns a list of collections.
Companies	Returns the list of companies in the shop.
CompanyContactRoleAssignments	Returns role assignments.
CompanyContacts	Returns contacts for companies.
CompanyLocations	Returns a list of locations in the company.
CompanyLocationStaffMemberAssignments	Store's staff member who are assigned to a company location of the shop. The assigned staff members' actions are limited to objects associated with the assigned company location. (This table is available only with a ShopifyPlus subscription)
Customers	Retrieves a list of customers.
DeliveryProfiles	Returns a list of saved delivery profiles.
DiscountsAutomaticApp	Returns a list of discounts.
DiscountsAutomaticBasic	Returns a list of discounts.
DiscountsAutomaticBxgy	Returns a list of discounts.
DiscountsCodeApp	Returns a list of discounts.
DiscountsCodeBasic	Returns a list of discounts.
DiscountsCodeBxgy	Returns a list of discounts.
DraftOrders	Returns a list of saved draft orders.
Files	Returns the list of files that have been uploaded to Shopify.
FulfillmentEvents	Retrieves the history of events associated with one or many fulfillments.
FulfillmentOrders	Retrieves a paginated list of merchant-managed and third-party fulfillment orders.
Fulfillments	Fulfillment represents a shipment of one or more items in an order.
FulfillmentServices	Lists fulfillmentServices which Represents service that prepares and ships orders on behalf of the store owner.
FulfillmentTrackingInfo	Lists tracking information associated with the fulfillment, such as the tracking company, tracking number, and tracking URL.
GiftCards	Returns a list of gift cards. Requires read_gift_cards access scope. Also, note that the API client must be a private or custom application installed on a Shopify Plus or Shopify Plus Partner Sandbox store. (This table is available only with a ShopifyPlus subscription)
GiftCardTransactionsCredit	Credit transactions which increase the gift card balance. (This table is available only with a ShopifyPlus subscription)
GiftCardTransactionsDebit	Debit transactions which decrease the gift card balance. (This table is available only with a ShopifyPlus subscription)
InventoryItemInventoryLevels	Returns overview information of the inventory item for each location that the inventory item can be stocked at.
InventoryItems	Returns a list of inventory items.
Locations	Returns a list of active inventory locations.
Menus	List menus for display on the storefront.
MetafieldDefinitions	Returns metafield definitions.
Metafields	Retrieves a list of metafields that belong to one or many resource IDs.
OrderRiskAssessments	Retrieves a list of risk assessments for orders.
Orders	Retrieves a list of orders.
OrderTransactions	Retrieves the transactions associated with the resource.
Pages	List of the shop's pages.
PriceLists	All price lists for a shop.
ProductMediaImages	Returns the media images associated with the product.
ProductOptions	Returns a list of product options. The limit is specified by Shop.resourceLimits.maxProductOptions.
ProductOptionValues	List all the corresponding option value objects to the product option, including values not assigned to any variants.
ProductResourceFeedbacks	Returns the product resource feedback for the currently authenticated app.
Products	Returns a list of products.
ProductVariants	Returns a list of the product variants.
Publications	Returns the list of publications.
Refunds	Represents a refund of items or transactions in an order.
Returns	Retrieves a list of returns for the order.
ScriptTags	Returns a list of script tags.
Segments	A list of a shop's segments.
SellingPlanGroups	Returns a list Selling Plan Groups.
StoreCreditAccountCreditTransactions	Credit transactions which increase the store credit account balance.
StoreCreditAccountDebitTransactions	Debit transactions which decrease the store credit account balance.
StorefrontAccessTokens	Retrieves the storefront access token of a private application. These are scoped per-application.
Themes	List of the shop's themes.
UrlRedirects	Returns a list of redirects for a shop.