Reference

Endpoint Get Orders Count

Name

get_orders_count

Description

Retrieve a orders count. [API reference]

Parameters

Parameter Required Options
Name: status

Label: status
Option Value
any any
open open
closed closed
Name: financial_status

Label: Financial Status
Option Value
any any
authorized authorized
pending pending
paid paid
partially_paid partially_paid
refunded refunded
voided voided
partially_refunded partially_refunded
unpaid unpaid
Name: fulfillment_status

Label: Fulfillment Status
Option Value
any any
shipped shipped
partial partial
unshipped unshipped
unfulfilled unfulfilled
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_I8 bigint
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 Orders Count
Optional Parameters
status
Financial Status
Fulfillment Status
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 Orders Count
Optional Parameters
status
Financial Status
Fulfillment Status
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get orders count 

SELECT * FROM get_orders_count

SQL Server

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

Get orders count 

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

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];