Reference

Endpoint Get Products Count

Name

get_products_count

Description

Retrieve a products count. [API reference]

Parameters

Parameter Required Options
Name: published_status

Label: Published Status
Option Value
any any
published published
unpublished unpublished
Name: product_type

Label: Product Type (e.g. Cult Products)
Name: collection_id

Label: Collection Id
Name: published_at_min

Label: Published After
Name: published_at_max

Label: Published Before
Name: created_at_max

Label: Created Before

Restrict results to records created before a specified date. (format: 2014-04-25T16:15:47). Supported options are the following: now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3 days from month start)
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2014-04-25T16:15:47 2014-04-25T16:15:47
2014-04-25T16:15:47-04:00 2014-04-25T16:15:47-04:00
Name: created_at_min

Label: Created After

Restrict results to records created after a specified date. (format: 2014-04-25T16:15:47). Supported options are the following: now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3 days from month start)
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2014-04-25T16:15:47 2014-04-25T16:15:47
2014-04-25T16:15:47-04:00 2014-04-25T16:15:47-04:00
Name: updated_at_max

Label: Updated Before

Restrict results to records last updated before a specified date. (format: 2014-04-25T16:15:47). Supported options are the following: now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3 days from month start)
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2014-04-25T16:15:47 2014-04-25T16:15:47
2014-04-25T16:15:47-04:00 2014-04-25T16:15:47-04:00
Name: updated_at_min

Label: Updated After

Restrict results to records last updated after a specified date. (format: 2014-04-25T16:15:47). Supported options are the following: now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3 days from month start)
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2014-04-25T16:15:47 2014-04-25T16:15:47
2014-04-25T16:15:47-04:00 2014-04-25T16:15:47-04:00

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Count DT_I4 int
If the column you are looking for is missing, consider customizing Shopify Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Shopify Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Shopify
Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
Shopify
Get Products Count
Optional Parameters
Published Status
Product Type (e.g. Cult Products)
Collection Id
Published After
Published Before
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Shopify
Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
Shopify
Get Products Count
Optional Parameters
Published Status
Product Type (e.g. Cult Products)
Collection Id
Published After
Published Before
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get products count 

SELECT * FROM get_products_count

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get products count 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_products_count';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];