Shopify Connector
Documentation
Version: 2
Documentation

EndPoint Get Orders Count


Name

get_orders_count

Description

Retrieve a orders count. [API reference]

Parameters

Parameter Label Required Options Description
status status NO
Option Value
any any
open open
closed closed
financial_status Financial Status NO
Option Value
any any
authorized authorized
pending pending
paid paid
partially_paid partially_paid
refunded refunded
voided voided
partially_refunded partially_refunded
unpaid unpaid
fulfillment_status Fulfillment Status NO
Option Value
any any
shipped shipped
partial partial
unshipped unshipped
unfulfilled unfulfilled
created_at_max Created Before NO
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
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)
created_at_min Created After NO
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
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)
updated_at_max Updated Before NO
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
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)
updated_at_min Updated After NO
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
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)

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Count DT_I8 bigint False

Input Columns

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