ODBC Driver for Mailchimp

Build 24.0.9062

EcommerceProducts

A list of an account's ecommerce products.

Table Specific Information

Select

The 本製品 will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the 本製品.

The StoreId can be retrieved by selecting the ECommerceStores view.

  • StoreId supports the '=' operator.
  • Id supports the '=' operator.
For example:
SELECT * FROM EcommerceProducts WHERE StoreId = 'Test_Store123'

SELECT * FROM EcommerceProducts WHERE StoreId = 'Test_Store123' and Id = '44'

Columns

Name Type ReadOnly Description
StoreId [KEY] String False

The StoreId for the table.

Id [KEY] String False

A unique identifier for the product.

Title String False

The title of a product.

Handle String False

The handle of a product.

Url String False

The URL of a product.

Description String False

The description of a product.

Type String False

The type of product.

Vendor String False

The vendor for a product.

ImageUrl String False

The image URL for a product.

Variants String False

An array of the product's variants.

PublishedAtForeign Datetime False

The date and time when the product was published.

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