Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData JDBC Driver for Shopify Views


Name	Description
AbandonedCheckoutCustomAttributes	Retrieves custom attributes associated with the resource.
AbandonedCheckoutLineItems	Retrieves a list of line items in the associated resource.
AbandonedCheckouts	List checkouts that were abandoned by customers.
AbandonedCheckoutTaxLines	Represents a single tax applied to the associated resource.
Abandonment	Returns abandonment.
AbandonmentProductsAddedToCart	Returns the products added to the cart during the customer abandoned visit.
AbandonmentProductsViewed	Returns the products viewed during the customer abandoned visit.
AppCredits	Lists credits that can be used towards future app purchases.
ArticleCommentEvents	Retrieves a paginated list of events associated with the host subject.
ArticleEvents	Retrieves a paginated list of events associated with the host subject.
AssignedFulfillmentOrders	Retrieves a paginated list of fulfillment orders assigned to the shop locations owned by the app. Assigned fulfillment orders are fulfillment orders that are set to be fulfilled from locations managed by fulfillment services that are registered by the app. One app (api_client) can host multiple fulfillment services on a shop. Each fulfillment service manages a dedicated location on a shop. Assigned fulfillment orders can have associated, or might currently not be requested to be fulfilled. The app must have 'read_assigned_fulfillment_orders' to be able to retrieve fulfillment orders assigned to its locations. All assigned fulfillment orders (except those with the 'CLOSED' status) will be returned by default.
BlogEvents	Retrieves a paginated list of events associated with the host subject.
BusinessEntities	List of Business Entities associated with the shop.
CollectionProducts	Retrieves a list of the products inside of a collection.
CompanyContactRoles	Returns available roles for company contacts.
CompanyEvents	Retrieves a paginated list of events associated with the host subject.
CustomerAddresses	List addresses associated with customers.
CustomerEvents	Retrieves a paginated list of events associated with the host subject.
CustomerSegmentMembers	The list of members, such as customers, that's associated with individual segments.
CustomerStoreCreditAccounts	Retrieve customers' store credit accounts.
DeliveryProfileLocationGroupCountries	Lists countries already selected in any zone for the specified location group.
DeliveryProfileLocationGroupCountryProvinces	Returns the list of regions associated with this country.
DeliveryProfileLocationGroups	Lists the location groups using this profile.
DeliveryProfileLocationGroupZones	Lists the applicable zones associated to the specified location group.
DeliveryProfileUnassignedLocations	Lists the locations that have not been assigned to a location group for this profile.
DiscountEvents	Retrieves a paginated list of events associated with the host subject.
DiscountsCodeFreeShipping	Returns a list of discounts.
Disputes	All disputes related to the shop.
DraftOrderCustomAttributes	Retrieves custom attributes associated with the resource.
DraftOrderEvents	Retrieves a paginated list of events associated with the host subject.
DraftOrderLineItemCustomAttributes	Retrieves custom attributes associated with the resource.
DraftOrderLineItems	Returns a list of the line items in the draft order.
DraftOrderLineItemTaxLines	Represents a single tax applied to the associated resource.
DraftOrderTaxLines	Represents a single tax applied to the associated resource.
Events	Retrieves a list of events associated with the shop.
FulfillmentLineItems	Line items from orders that are included in fulfillments.
FulfillmentLineItemTaxLines	Represents a single tax applied to the associated resource.
FulfillmentOrderLineItems	A list of the fulfillment order's line items.
FulfillmentOrderLocationForMoveAvailableLineItems	A list of the fulfillment order's line items.
FulfillmentOrderLocationForMoveUnavailableLineItems	A list of the fulfillment order's line items.
FulfillmentOrderLocationsForMove	A list of locations that the fulfillment order can potentially move to.
InventoryAdjustmentGroupChanges	Sets of inventory quantity changes that occurred in inventory events.
InventoryAdjustmentGroups	Groups of adjustments made as part of inventory operations.
InventoryItemCountryHarmonizedSystemCodes	Returns a list of country specific harmonized system codes.
InventoryItemInventoryLevelQuantities	List quantities for inventory items at specific locations.
InventoryItemInventoryLevelScheduledChanges	Scheduled changes for inventory levels.
Jobs	Returns a Job resource by ID. Used to check the status of internal jobs and any applicable changes.
LocalizationCountries	Returns the list of countries with enabled localized experiences.
MarketingEvents	Returns a list of marketing events associated with the marketing app.
MetafieldDefinitionConstraintValues	Returns constraint subtype values that metafield definitions apply to.
MetafieldDefinitionStandardTemplates	Standard metafield definition templates provide preset configurations to create metafield definitions.
MetafieldDefinitionTypes	Returns metafield definition types which provide the basic foundation and validations for metafields.
MetaobjectDefinitions	Provides the definition of a generic object structure composed of metafields.
MetaObjects	All metaobjects for the shop.
OrderAdditionalFees	A list of additional fees applied to the order.
OrderAgreementAdditionalFeeSales	Retrieves a list of sales associated with agreements.
OrderAgreementAdjustmentSales	Retrieves a list of sales associated with agreements.
OrderAgreementDutySales	Retrieves a list of sales associated with agreements.
OrderAgreementGiftCardSales	Retrieves a list of sales associated with agreements.
OrderAgreementProductSales	Retrieves a list of sales associated with agreements.
OrderAgreements	Retrieves a list of sales agreements associated with orders.
OrderAgreementShippingLineSales	Retrieves a list of sales associated with agreements.
OrderAgreementTipSales	Retrieves a list of sales associated with agreements.
OrderAgreementUnknownSales	Retrieves a list of sales associated with agreements.
OrderCustomAttributes	Retrieves custom attributes associated with the resource.
OrderDiscountApplications	Returns a list of discounts that are applied to the order, not including order edits and refunds.
OrderEditAgreementAdditionalFeeSales	Retrieves a list of sales associated with agreements.
OrderEditAgreementAdjustmentSales	Retrieves a list of sales associated with agreements.
OrderEditAgreementDutySales	Retrieves a list of sales associated with agreements.
OrderEditAgreementGiftCardSales	Retrieves a list of sales associated with agreements.
OrderEditAgreementProductSales	Retrieves a list of sales associated with agreements.
OrderEditAgreements	Retrieves a list of sales agreements associated with orders.
OrderEditAgreementShippingLineSales	Retrieves a list of sales associated with agreements.
OrderEditAgreementTipSales	Retrieves a list of sales associated with agreements.
OrderEditAgreementUnknownSales	Retrieves a list of sales associated with agreements.
OrderEvents	Retrieves a paginated list of events associated with the host subject.
OrderLineItemCustomAttributes	Retrieves custom attributes associated with the resource.
OrderLineItemDiscountAllocations	Retrieves the discounts that have been allocated onto the line item by discount applications, not including order edits and refunds.
OrderLineItemDuties	Lists the duties associated with the line items.
OrderLineItems	Retrieves line items associated with orders.
OrderLineItemTaxLines	Represents a single tax applied to the associated resource.
OrderNonFulfillableLineItemDuties	Lists the duties associated with the line items.
OrderNonFulfillableLineItems	Retrieves a list of line items in the associated resource.
OrderRefundAgreementAdditionalFeeSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementAdjustmentSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementDutySales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementGiftCardSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementProductSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreements	Retrieves a list of sales agreements associated with orders.
OrderRefundAgreementShippingLineSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementTipSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementUnknownSales	Retrieves a list of sales associated with agreements.
OrderShippingLines	Retrieve shipping lines attached to orders.
OrderTaxLines	Represents a single tax applied to the associated resource.
PageEvents	Retrieves a paginated list of events associated with the host subject.
PriceListPrices	A list of prices associated with a price list.
ProductBundleComponentOptionSelections	Get relationships between component options and parent options.
ProductBundleComponents	List products' component information.
ProductEvents	Retrieves a paginated list of events associated with the host subject.
ProductOperations	An entity that represents details of an asynchronous operation on a product.
ProductVariantEvents	Retrieves a paginated list of events associated with the host subject.
PublicationCollections	Returns a list of collections published to the publication.
PublicationProducts	Returns the list of publication for products.
RefundDuties	Lists the refunded duties as part of this refund.
RefundLineItemDuties	Lists the duties associated with the line items.
RefundLineItems	Retrieves the 'RefundLineItem' resources attached to the refund.
RefundOrderAdjustments	Retrieve the order adjustments that are attached to refunds.
RefundShippingLines	Retrieve shipping lines attached to refunds.
RefundTransactionFees	Returns the transaction fees charged on the order transaction. Only present for Shopify Payments transactions.
RefundTransactions	Retrieves the transactions associated with the resource.
ReturnExchangeLineItems	Retrieves a list of line items in the associated resource.
ReturnLineItems	Retrieves the return line items attached to the return.
ReturnLineItemsUnverified	Retrieves the unverified return line items attached to the return.
ReverseFulfillmentOrderDeliveries	Reverse deliveries are post-fulfillment objects that represents a buyer sending a package to a merchant.
ReverseFulfillmentOrderDeliveryLineItems	Details about reverse delivery line items.
ReverseFulfillmentOrderLineItems	Details about reverse fulfillment order line items.
ReverseFulfillmentOrders	Items in returns that will be processed at a fulfillment service.
SegmentFilterParameters	The parameters for event segment filters.
SegmentFilters	A list of filters.
SellingPlanGroupSellingPlans	Retrieves selling plans associated to the selling plan group.
Shop	Returns the Shop resource corresponding to the access token used in the request. The Shop resource contains business and store management settings for the shop.
ShopifyPaymentsAccount	Returns Shopify Payments account information, including balances and payouts.
ShopifyPaymentsAccountBalance	Returns current balances in all currencies for the account.
ShopifyPaymentsAccountBalanceTransactionAdjustmentsOrders	The adjustment orders associated to the transaction.
ShopifyPaymentsAccountBalanceTransactions	A list of balance transactions associated with a Shopify Payments account balance.
ShopifyPaymentsAccountBankAccounts	Lists all bank accounts configured for the Shopify Payments account.
ShopifyPaymentsAccountDisputes	Lists all disputes related to the Shopify Payments account.
ShopifyPaymentsAccountPayouts	Returns all current and previous payouts made between the account and the bank account. Its avaible only in a few certain countries.
ShopifyPaymentsAccountVerifications	Returns the verifications necessary for this account.
StaffMembers	Retrieves a paginated list of the shop's staff members. (This table is available only with a ShopifyPlus subscription)
StoreCreditAccountDebitRevertTransactions	Debit revert transactions created when a store credit account debit transaction is reverted.
StoreCreditAccountExpirationTransactions	Expiration transactions created when a store credit account credit transaction expires.
TenderTransactions	Returns a list of TenderTransactions associated with the shop.