Excel Add-In for Shopify

Build 24.0.9060

PublicationProducts

Returns the list of publication for products.

View-Specific Information

Select

The add-in uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.

  • ProductId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM PublicationProducts
  SELECT * FROM PublicationProducts WHERE ProductId = 'Val1'

Columns

Name Type References Description
ProductId [KEY] String

Products.Id

A globally-unique ID.
PublishDate Datetime The date that the resource publication was or is going to be published to the publication.
IsPublished Bool Whether the resource publication is published.
PublicationId [KEY] String A globally-unique ID.
PublicationName String Name of the publication.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060