Overview
Configuration is provided for establishing connections with Shopify service. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Demonstration
Configuration
Base URL address: https://[shop].myshopify.com.
-
The authentication uses an authorized token.
The authentication has the following user-defined parameters:
- Scope:
The following request parameters will be automatically processed during the authentication process:
-
X-Shopify-Access-Token:
{{=token.Access}}
For further information, please check here.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- LongerText
Data type: DT_WSTR ( length 4000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Currency
Data type: DT_CY
- Code2
Data type: DT_WSTR ( length 2 )
- Code3
Data type: DT_WSTR ( length 3 )
- Id
Data type: DT_UI8
- Address
Field components:
-
Uses template:
Id. - Contains the following components: id, address1, address2, city, company, country, country_code, first_name, last_name, latitude, longitude, name, phone, province, province_code, zip, default.
-
Uses template:
- Metafields
An array field. Field components:
-
Uses template:
ShortText. - Contains the following components: key, value, value_type, namespace, description.
-
Uses template:
- Image
Field components:
-
Uses template:
ShortText. - Contains the following components: attachment, src, created_at.
-
Uses template:
- DiscountCodes
An array field. Field components:
-
Uses template:
Currency. - Contains the following components: amount, code, type.
-
Uses template:
- Receipt
Field components:
- Contains the following components: testcase, authorization.
- TaxLines
An array field. Field components:
-
Uses template:
Currency. - Contains the following components: price, rate, title.
-
Uses template:
- LineItem
Field components:
-
Uses template:
Id. - Contains the following components: id, fulfillable_quantity, fulfillment_service, fulfillment_status, quantity, requires_shipping, taxable, gift_card, shipment_status, title, grams, price, total_discount, tax_lines, product_id, variant_inventory_management, properties, variant_id, variant_title, name, vendor, sku, product_exists.
-
Uses template:
- PaymentDetails
An array field. Field components:
-
Uses template:
ShortText. - Contains the following components: avs_result_code, credit_card_bin, cvv_result_code, credit_card_number, credit_card_company.
-
Uses template:
- Transaction
Field components:
-
Uses template:
Id. - Contains the following components: id, amount, authorization, device_id, gateway, source_name, payment_details, kind, order_id, receipt, error_code, status, message, test, user_id, currency, location_id, parent_id, created_at.
-
Uses template:
- Province
Field components:
-
Uses template:
Id. - Contains the following components: id, code, country_id, name, tax, tax_name, tax_type, tax_percentage.
-
Uses template:
- [Read] action
-
The result is extracted from:{{=response[resource.objects]}}.
The result is paginated.The following request parameters will be automatically processed:
-
page:
{{=parameters.iterator}} -
limit:
{{=parameters.batchSize}} -
fields:
{{=_.filter(parameters.fields, function(item) { return item.indexOf('.') == -1; }).join()}} -
_includeUserParameters:
{{=parameters}}
-
page:
- [Create] action
-
The result is extracted from:{{=response[resource.object]}}.
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{= function(item) { var result = {}; result[resource.object] = item; return result; }(item) }}
-
application/json:
- [Update] action
-
The result is extracted from:{{=response[resource.object]}}.
The action uses PUT method.The following request parameters will be automatically processed:
-
application/json:
{{= function(item) { var result = {}; result[resource.object] = item; return result; }(item) }}
-
application/json:
- [Delete] action
-
The action uses DELETE method.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/checkouts.json.
The result is extracted from:{{=response.checkouts}}.For further information check here.
- id
A key field. Data type: DT_I4
- name
Template: ShortText.
- source
Template: ShortText.
- source_name
Template: ShortText.
- abandoned_checkout_url
Template: ShortText.
- billing_address
Template: Address.
- buyer_accepts_marketing
Data type: DT_BOOL
- cancel_reason
Template: ShortText.
- cart_token
Template: ShortText.
- closed_at
Template: DateTime.
- completed_at
Template: DateTime.
- currency
Template: Code3.
- source_identifier
Template: ShortText.
- source_url
Template: ShortText.
- customer
Field components:
-
Uses template:
Id. - Contains the following components: id, email, accepts_marketing, created_at, updated_at, first_name, last_name, orders_count, state, total_spent, last_order_id, note, verified_email, multipass_identifier, tax_exempt, tags, last_order_name, default_address.
-
Uses template:
- discount_codes
Template: DiscountCodes.
Template: ShortText.
- gateway
Template: ShortText.
- landing_site
Template: ShortText.
- line_items
An array field. Field components:
-
Uses template:
ShortText. - Contains the following components: key, applied_discounts, compare_at_price, destination_location_id, fulfillment_service, fulfillment_status, gift_card, grams, line_price, price, origin_location_id, product_id, properties, quantity, requires_shipping, sku, tax_lines, taxable, title, variant_id, variant_title, vendor, name.
-
Uses template:
- note
Template: LongText.
- note_attributes
Template: LongText.
- referring_site
Template: ShortText.
- shipping_address
Template: Address.
- shipping_lines
An array field. Field components:
-
Uses template:
ShortText. - Contains the following components: id, code, price, source, title.
-
Uses template:
- subtotal_price
Template: Currency.
- tax_lines
Template: TaxLines.
- taxes_included
Data type: DT_BOOL
- token
Template: ShortText.
- total_discounts
Template: Currency.
- total_line_items_price
Template: Currency.
- total_price
Template: Currency.
- total_tax
Template: Currency.
- total_weight
Data type: DT_I4
- updated_at
Template: DateTime.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/application_charges.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/application_charges.json.For further information check here.
- id
A key field. Template: Id.
- name
Template: ShortText.
- price
Template: Currency.
- return_url
Template: ShortText.
- test
Data type: DT_BOOL
- confirmation_url
Template: ShortText. A read-only field.
- status
Template: ShortText. A read-only field.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- api_client_id
Template: Id. A read-only field.
- charge_type
Template: ShortText. A read-only field.
- decorated_return_url
Template: ShortText. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/blogs/{{=parameters.blog_id}}/articles.json.The action has the following user-defined parameters:
- blog_id: Required. Specify blog identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/blogs/{{=item.blog_id}}/articles.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/blogs/{{=item.blog_id}}/articles/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/blogs/{{=parameters.blog_id}}/articles/{{=item.id}}.json.The action has the following user-defined parameters:
- blog_id: Required. Specify blog identifier.
For further information check here.
- id
A key field. Template: Id.
- author
Template: ShortText.
- blog_id
Template: Id.
- body_html
Template: LongerText.
- handle
Template: ShortText.
- image
Template: Image.
- metafields
Template: Metafields.
- published
Data type: DT_BOOL
- summary_html
Template: ShortText.
- tags
Template: ShortText.
- template_suffix
Template: ShortText.
- title
Template: ShortText.
- user_id
Template: Id.
- published_at
Template: DateTime.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/themes/{{=parameters.theme_id}}/assets.json.The action has the following user-defined parameters:
- theme_id: Required. Specify theme identifier.
For further information check here.
- [Upsert] action
-
Endpoint URL address:
/admin/themes/{{=item.theme_id}}/assets.json.
The result is extracted from:{{=response.asset}}.
The action uses PUT method.The following request parameters will be automatically processed:
-
application/json:
{{={ asset: item } }}
For further information check here.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/admin/themes/{{=parameters.theme_id}}/assets.json.The action has the following user-defined parameters:
- theme_id: Required. Specify theme identifier.
The following request parameters will be automatically processed:
-
asset[key]:
{{=item.key}}
For further information check here.
- key
A key field. Template: ShortText.
- attachment
Data type: DT_IMAGE The value is gathered from
{{=item.public_url}}address. Before setting, the value is processed with{{=!_.isUndefined(value) && getClrType('System.Convert').ToBase64String(value)}}expression.- content_type
Template: ShortText.
- public_url
Template: ShortText.
- size
Data type: DT_I4
- source_key
Template: ShortText.
- src
Template: ShortText.
- theme_id
Template: Id.
- value
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/blogs.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/blogs.json.
The result is extracted from:{{=response.blog}}.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/blogs/{{=item.id}}.json.
The result is extracted from:{{=response.blog}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/blogs/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- commentable
Template: ShortText.
- feedburner
Template: ShortText.
- feedburner_location
Template: ShortText.
- handle
Template: ShortText.
- metafields
Template: Metafields.
- tags
Template: ShortText.
- template_suffix
Template: ShortText.
- title
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/carrier_services.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/carrier_services.json.
The result is extracted from:{{=response.carrier_service}}.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/carrier_services/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/carrier_services/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- active
Data type: DT_BOOL
- callback_url
Template: ShortText.
- carrier_service_type
Template: ShortText.
- name
Template: ShortText.
- service_discovery
Data type: DT_BOOL
- format
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/collects.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/collects.json.
The result is extracted from:{{=response.collect}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/collects/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- collection_id
Data type: DT_I4
- featured
Data type: DT_BOOL
- position
Data type: DT_I4
- product_id
Data type: DT_I4
- sort_value
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/comments.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/comments.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/comments/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- article_id
Template: Id.
- author
Template: ShortText.
- blog_id
Template: Id.
- body
Template: LongerText.
- body_html
Template: LongerText.
Template: ShortText.
- ip
Template: ShortText.
- published_at
Template: DateTime.
- status
Template: ShortText.
- user_agent
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/countries.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/countries.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/countries/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/countries/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- code
Template: Code2.
- name
Template: ShortText.
- provinces
Template: Province. An array field.
- tax
Data type: DT_R8
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/custom_collections.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/custom_collections.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/custom_collections/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/custom_collections/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- body_html
Template: LongerText.
- handle
Template: ShortText.
- image
Template: Image.
- metafields
Template: Metafields.
- published
Data type: DT_BOOL
- published_at
Template: DateTime.
- published_scope
Template: ShortText.
- sort_order
Template: ShortText.
- template_suffix
Template: ShortText.
- title
Template: ShortText.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/customers.json.For further information check here.
- [Read search] action
-
Endpoint URL address:
/admin/customers/search.json.The action has the following user-defined parameters:
- search: Required. Specify search query (alias for "query").
The following request parameters will be automatically processed:
-
query:
{{=parameters.search}}
For further information check here.
- [Read saved_search] action
-
Endpoint URL address:
/admin/customer_saved_searches/{{=parameters.saved_search}}/customers.json.The action has the following user-defined parameters:
- saved_search: Required. Specify saved search identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/customers.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/customers/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/customers/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- accepts_marketing
Data type: DT_BOOL
Template: ShortText.
- first_name
Template: ShortText.
- metafields
Template: Metafields.
- multipass_identifier
Template: ShortText.
- last_name
Template: ShortText.
- last_order_id
Template: ShortText.
- last_order_name
Template: ShortText.
- note
Template: LongText.
- tags
Template: ShortText.
- tax_exempt
Data type: DT_BOOL
- total_spent
Template: Currency.
- verified_email
Data type: DT_BOOL
- addresses
Template: Address. An array field.
- default_address
Template: Address. A read-only field. The value is sent to
/admin/customers/{{=item.id}}/addresses/{{=item.default_address.id}}/default.jsonaddress. Field components:-
Uses template:
Id. - Contains the following components: id.
-
Uses template:
- orders_count
Data type: DT_I4 A read-only field.
- state
Template: ShortText. A read-only field.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- [Read] action
-
Endpoint URL address:
/admin/customers/{{=parameters.customer_id}}/addresses.json.
The result is extracted from:{{=response.addresses}}.The action has the following user-defined parameters:
- customer_id: Required. Specify customer identifier.
The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/customers/{{=item.customer_id}}/addresses.json.
The result is extracted from:{{=response.customer_address}}.
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{={ address: item } }}
For further information check here.
-
application/json:
- [Update] action
-
Endpoint URL address:
/admin/customers/{{=item.customer_id}}/addresses/{{=item.id}}.json.
The result is extracted from:{{=response.customer_address}}.
The action uses PUT method.The following request parameters will be automatically processed:
-
application/json:
{{={ address: item } }}
For further information check here.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/admin/customers/{{=item.customer_id}}/addresses/{{=item.id}}.json.
The action uses DELETE method.For further information check here.
The resource includes the fields from the Address template.
- customer_id
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/customer_saved_searches.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/customer_saved_searches.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/customer_saved_searches/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/customer_saved_searches/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- name
Template: ShortText.
- query
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/discounts.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/discounts.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/discounts/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- discount_type
Template: ShortText.
- code
Template: ShortText.
- value
Data type: DT_R8
- ends_at
Template: DateTime.
- starts_at
Template: DateTime.
- status
Template: ShortText.
- minimum_order_amount
Data type: DT_I4
- usage_limit
Data type: DT_I4
- applies_to_id
Data type: DT_I4
- applies_once
Data type: DT_BOOL
- applies_once_per_customer
Data type: DT_BOOL
- applies_to_resource
Template: ShortText.
- times_used
Data type: DT_I4 A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/orders/{{=parameters.resource}}/events.json.The action has the following user-defined parameters:
- resource: Required. Specify resource.
For further information check here.
- id
A key field. Template: Id.
- arguments
Template: ShortText.
- body
Template: LongerText.
- path
Template: ShortText.
- message
Template: ShortText.
- subject_id
Template: Id.
- subject_type
Template: ShortText.
- verb
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/orders/{{=parameters.order_id}}/fulfillments.json.The action has the following user-defined parameters:
- order_id: Required. Specify order_id identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/orders/{{=item.order_id}}/fulfillments.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/orders/{{=item.order_id}}/fulfillments/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- line_items
Template: LineItem. An array field.
- order_id
Template: Id.
- receipt
Template: Receipt.
- status
Template: ShortText.
- tracking_company
Template: ShortText.
- tracking_numbers
Template: LongText.
- tracking_urls
Template: LongerText.
- variant_inventory_management
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- [Read] action
-
Endpoint URL address:
/admin/orders/{{=parameters.order_id}}/fulfillments/{{=parameters.fulfillment_id}}/events.json.
The result is extracted from:{{=response.fulfillment_events}}.The action has the following user-defined parameters:
- order_id: Required. Specify order_id identifier.
The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/orders/{{=item.order_id}}/fulfillments/{{=item.fulfillment_id}}/events.json.
The result is extracted from:{{=response.fulfillment_event}}.The following request parameters will be automatically processed:
-
application/json:
{{={ event: item } }}
For further information check here.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/admin/orders/{{=item.order_id}}/fulfillments/{{=item.fulfillment_id}}/events/{{=item.id}}.json.
The action uses DELETE method.For further information check here.
- id
A key field. Template: Id.
- shop_id
Template: Id.
- order_id
Template: Id.
- fulfillment_id
Template: Id.
- status
Template: ShortText.
- happened_at
Data type: DT_I4
- message
Template: ShortText.
- city
Template: ShortText.
- province
Template: Code2.
- zip
Template: ShortText.
- country
Template: ShortText.
- address1
Template: ShortText.
- latitude
Data type: DT_R8
- longitude
Data type: DT_R8
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/fulfillment_services.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/fulfillment_services.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/fulfillment_services/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/fulfillment_services/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- callback_url
Template: ShortText.
- format
Template: ShortText.
- handle
Template: ShortText.
- inventory_management
Data type: DT_BOOL
- name
Template: ShortText.
- provider_id
Template: Id.
- requires_shipping_method
Data type: DT_BOOL
- tracking_support
Data type: DT_BOOL
Template: ShortText.
- include_pending_stock
Data type: DT_BOOL
- service_name
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/gift_cards.json.For further information check here.
- [Read search] action
-
Endpoint URL address:
/admin/gift_cards/search.json.The action has the following user-defined parameters:
- search: Required. Specify search query (alias for "query").
The following request parameters will be automatically processed:
-
query:
{{=parameters.search}}
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/gift_cards.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/gift_cards/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/gift_cards/{{=item.id}}/disable.json.For further information check here.
- id
A key field. Template: Id.
- api_client_id
Template: Id.
- user_id
Template: Id.
- order_id
Template: Id.
- line_item_id
Template: Id.
- balance
Template: Currency.
- currency
Template: Code3.
- code
Template: ShortText.
- masked_code
Template: ShortText.
- last_characters
Data type: DT_WSTR ( length 4 )
- note
Template: LongText.
- template_suffix
Template: ShortText.
- expires_on
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- disabled_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/inventory_items.json.
The result is paginated.The action has the following user-defined parameters:
- ids: Specify comma separated list of inventory items identifier.
For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/inventory_items/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- sku
Template: ShortText.
- tracked
Data type: DT_BOOL
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- [Read] action
-
Endpoint URL address:
/admin/inventory_levels.json.
The result is extracted from:{{=response.inventory_levels}}.The action has the following user-defined parameters:
- inventory_item_ids: A comma-separated list of inventory item IDs.
- location_ids: A comma-separated list of location IDs.
The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/inventory_levels/connect.json.
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{=_.extend({ inventory_item_id: item.inventory_item_id, location_id: item.location_id }, item)}}
For further information check here.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/admin/inventory_levels.json.
The action uses DELETE method.For further information check here.
- inventory_item_id
A key field. Template: Id.
- location_id
A key field. Template: Id.
- available
Data type: DT_I4 The value is sent to
/admin/inventory_levels/set.jsonaddress.- updated_at
Template: DateTime. A read-only field.
- available_adjustment
Data type: DT_I4 The value is sent to
/admin/inventory_levels/adjust.jsonaddress.- relocate_if_necessary
Data type: DT_BOOL
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/locations.json.
The result is paginated.For further information check here.
- id
A key field. Template: Id.
- active
Data type: DT_BOOL
- address1
Template: ShortText.
- address2
Template: ShortText.
- city
Template: ShortText.
- country
Template: ShortText.
- country_code
Template: Code2.
- legacy
Data type: DT_BOOL
- name
Template: ShortText.
- phone
Template: ShortText.
- province
Template: ShortText.
- province_code
Template: Code2.
- zip
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- [Read] action
-
Endpoint URL address:
/admin/locations.json.
The result is extracted from:{{=response.locations}}.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
For further information check here.
-
_includeUserParameters:
- id
A key field. Template: Id.
- name
Template: ShortText.
- address1
Template: ShortText.
- address2
Template: ShortText.
- zip
Template: ShortText.
- city
Template: ShortText.
- province
Template: ShortText.
- country
Template: Code2.
- phone
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin{{=parameters.get('resource') || ''}}/metafields.json.The action has the following user-defined parameters:
- resource: Optional. Specify resource.
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin{{=item.resource || ''}}/metafields.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin{{=item.resource || ''}}/metafields/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin{{=parameters.get('resource') || ''}}/metafields/{{=item.id}}.json.The action has the following user-defined parameters:
- resource: Optional. Specify resource.
For further information check here.
- id
A key field. Template: Id.
- resource
Template: ShortText.
- description
Template: ShortText.
- key
Template: ShortText.
- namespace
Template: ShortText.
- owner_id
Template: Id.
- owner_resource
Template: ShortText.
- value
Template: ShortText.
- value_type
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/orders.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/orders.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/orders/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/orders/{{=item.id}}.json.For further information check here.
- billing_address
Template: Address.
- browser_ip
Template: ShortText.
- buyer_accepts_marketing
Data type: DT_BOOL
- cancel_reason
Template: ShortText.
- cart_token
Template: ShortText.
- client_details
Field components:
-
Uses template:
ShortText. - Contains the following components: accept_language, browser_height, browser_ip, browser_width, session_hash, user_agent.
-
Uses template:
- currency
Template: Code3.
- customer
Field components:
-
Uses template:
Id. - Contains the following components: id, accepts_marketing, email, first_name, order_id, last_name, note, state, tags, total_spent, orders_count, created_at, updated_at.
-
Uses template:
- discount_codes
Template: DiscountCodes.
Template: ShortText.
- financial_status
Template: ShortText.
- fulfillments
An array field. A read-only field. Field components:
-
Uses template:
Id. - Contains the following components: id, line_items, order_id, receipt, status, service, tracking_company, shipment_status, tracking_number, tracking_numbers, tracking_url, tracking_urls, created_at, updated_at.
-
Uses template:
- fulfillment_status
Template: ShortText.
- tags
Template: ShortText.
- gateway
Template: ShortText.
- landing_site
Template: ShortText.
- line_items
Template: LineItem. An array field.
- name
Template: ShortText.
- note
Template: LongText.
- note_attributes
An array field. Field components:
-
Uses template:
ShortText. - Contains the following components: name, value.
-
Uses template:
- number
Data type: DT_I4
- order_number
Data type: DT_I4
- payment_details
Template: PaymentDetails.
- payment_gateway_names
Template: LongText. A composite field.
- processing_method
Template: ShortText.
- referring_site
Template: ShortText.
- refunds
An array field. A read-only field. Field components:
-
Uses template:
Id. - Contains the following components: id, created_at, note, refund_line_items, restock, transactions, user_id, order_adjustments.
-
Uses template:
- shipping_address
Template: Address.
- shipping_lines
An array field. Field components:
-
Uses template:
ShortText. - Contains the following components: code, price, source, title, tax_lines, carrier_identifier, requested_fulfillment_service_id.
-
Uses template:
- source_name
Template: ShortText.
- subtotal_price
Template: Currency.
- status
Template: ShortText.
- tax_lines
Template: TaxLines.
- taxes_included
Data type: DT_BOOL
- token
Template: ShortText.
- total_discounts
Template: Currency.
- total_line_items_price
Template: Currency.
- total_price
Template: Currency.
- total_tax
Template: Currency.
- total_weight
Data type: DT_I4
- transactions
Template: Transaction. An array field.
- order_status_url
Template: ShortText.
- send_receipt
Data type: DT_BOOL
- send_fulfillment_receipt
Data type: DT_BOOL
- inventory_behaviour
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- closed_at
Template: DateTime. A read-only field.
- cancelled_at
Template: DateTime. A read-only field.
- processed_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/orders/{{=parameters.order_id}}/risks.json.The action has the following user-defined parameters:
- order_id: Required. Specify order identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/orders/{{=item.order_id}}/risks.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/orders/{{=item.order_id}}/risks/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/orders/{{=item.order_id}}/risks/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- cause_cancel
Data type: DT_BOOL
- display
Data type: DT_BOOL
- order_id
Template: Id.
- message
Template: ShortText.
- recommendation
Template: ShortText.
- score
Data type: DT_R8
- source
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/pages.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/pages.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/pages/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/pages/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- author
Template: ShortText.
- body_html
Template: LongerText.
- handle
Template: ShortText.
- metafields
Template: Metafields.
- shop_id
Template: Id.
- template_suffix
Template: ShortText.
- title
Template: ShortText.
- published
Data type: DT_BOOL
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- published_at
Template: DateTime. A read-only field.
- [Read] action
-
Endpoint URL address:
/admin/policies.json.
The result is extracted from:{{=response.policies}}.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
For further information check here.
-
_includeUserParameters:
- title
Template: ShortText.
- body
Template: LongerText.
- url
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/products.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/products.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/products/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/products/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- body_html
Template: LongerText.
- handle
Template: ShortText.
- images
Template: Image. An array field.
- options
An array field. Field components:
-
Uses template:
Id. - Contains the following components: id, product_id, name, position, values.
-
Uses template:
- product_type
Template: ShortText.
- published_scope
Template: ShortText.
- tags
Template: ShortText.
- template_suffix
Template: ShortText.
- title
Template: ShortText.
- metafields_global_title_tag
Template: ShortText.
- metafields_global_description_tag
Template: ShortText.
- variants
An array field. Field components:
-
Uses template:
Id. - Contains the following components: id, barcode, compare_at_price, fulfillment_service, grams, weight, weight_unit, inventory_management, inventory_policy, inventory_quantity, metafields, option1, option2, option3, position, price, product_id, requires_shipping, sku, taxable, title, created_at, updated_at.
-
Uses template:
- vendor
Template: ShortText.
- published
Data type: DT_BOOL
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- published_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/products/{{=parameters.product_id}}/images.json.
The result is paginated.The action has the following user-defined parameters:
- product_id: Required. Specify product identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/products/{{=item.product_id}}/images.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/products/{{=item.product_id}}/images/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/products/{{=item.product_id}}/images/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- position
Data type: DT_I4
- product_id
Template: Id.
- variant_ids
Template: LongText. A composite field.
- attachment
Data type: DT_IMAGE The value is gathered from
{{=item.src}}address. Before setting, the value is processed with{{=!_.isUndefined(value) && getClrType('System.Convert').ToBase64String(value)}}expression.- src
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- filename
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/products/{{=parameters.product_id}}/variants.json.The action has the following user-defined parameters:
- product_id: Required. Specify product identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/products/{{=item.product_id}}/variants.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/variants/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/products/{{=parameters.product_id}}/variants/{{=item.id}}.json.The action has the following user-defined parameters:
- product_id: Required. Specify product identifier.
For further information check here.
- id
A key field. Template: Id.
- barcode
Template: ShortText.
- compare_at_price
Template: Currency.
- fulfillment_service
Template: ShortText.
- grams
Data type: DT_I4
- image_id
Template: Id.
- inventory_item_id
Template: Id.
- inventory_management
Template: ShortText.
- inventory_policy
Template: ShortText.
- inventory_quantity
Data type: DT_I4 A read-only field.
- old_inventory_quantity
Data type: DT_I4
- inventory_quantity_adjustment
Data type: DT_I4
- metafields
Template: Metafields.
- option1
Template: ShortText.
- option2
Template: ShortText.
- option3
Template: ShortText.
- position
Data type: DT_I4
- price
Template: Currency.
- product_id
Template: Id.
- requires_shipping
Data type: DT_BOOL
- sku
Template: ShortText.
- taxable
Data type: DT_BOOL
- tax_code
Template: ShortText.
- title
Template: ShortText.
- weight
Data type: DT_R8
- weight_unit
Template: Code2.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/countries/{{=parameters.country_id}}/provinces.json.The action has the following user-defined parameters:
- country_id: Required. Specify country identifier.
For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/countries/{{=item.country_id}}/provinces/{{=item.id}}.json.For further information check here.
The resource includes the fields from the Province template.
- shipping_zone_id
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/recurring_application_charges.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/recurring_application_charges.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/recurring_application_charges/{{=item.id}}/customize.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/recurring_application_charges/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- capped_amount
Template: Currency.
- confirmation_url
Template: ShortText.
- name
Template: ShortText.
- price
Template: Currency.
- return_url
Template: ShortText.
- status
Template: ShortText.
- terms
Template: ShortText.
- test
Data type: DT_BOOL
- trial_days
Data type: DT_I4
- created_at
Template: DateTime.
- updated_at
Template: DateTime.
- activated_on
Template: DateTime.
- billing_on
Template: DateTime.
- cancelled_on
Template: DateTime.
- trial_ends_on
Template: DateTime.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/redirects.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/redirects.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/redirects/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/redirects/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- path
Template: ShortText.
- target
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/orders/{{=parameters.order_id}}/refunds.json.The action has the following user-defined parameters:
- order_id: Required. Specify order identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/orders/{{=item.order_id}}/refunds/calculate.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/orders/{{=item.order_id}}/refunds.json.
The action uses POST method.For further information check here.
- id
A key field. Template: Id.
- order_id
Template: Id.
- note
Template: LongText.
- refund_line_items
An array field. Field components:
-
Uses template:
Id. - Contains the following components: id, line_item, line_item_id, quantity.
-
Uses template:
- restock
Data type: DT_BOOL
- transactions
Template: Transaction. An array field.
- user_id
Template: Id.
- order_adjustments
Template: LongText. A composite field.
- notify
Data type: DT_BOOL
- shipping
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/script_tags.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/script_tags.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/script_tags/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/script_tags/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- event
Template: ShortText.
- src
Template: ShortText.
- display_scope
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/shipping_zones.json.For further information check here.
- id
A key field. Template: Id.
- name
Template: ShortText.
- countries
An array field. Field components:
-
Uses template:
Id. - Contains the following components: id, code, name, tax, tax_name.
-
Uses template:
- provinces
Template: Province. An array field.
- carrier_shipping_rate_providers
An array field. Field components:
-
Uses template:
Id. - Contains the following components: id, carrier_service_id, flat_modifier, percent_modifier, service_filter.
-
Uses template:
- price_based_shipping_rates
An array field. Field components:
-
Uses template:
Id. - Contains the following components: id, name, min_order_subtotal, price, max_order_subtotal.
-
Uses template:
- weight_based_shipping_rates
An array field. Field components:
-
Uses template:
Id. - Contains the following components: id, weight_low, weight_high, name, price.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/smart_collections.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/smart_collections.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/smart_collections/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/smart_collections/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- body_html
Template: LongerText.
- handle
Template: ShortText.
- image
Template: Image.
- published_scope
Template: ShortText.
- rules
An array field. Field components:
-
Uses template:
ShortText. - Contains the following components: column, relation, condition.
-
Uses template:
- disjunctive
Data type: DT_BOOL
- sort_order
Template: ShortText.
- template_suffix
Template: ShortText.
- title
Template: ShortText.
- published
Data type: DT_BOOL
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- published_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/themes.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/themes.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/themes/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/themes/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- name
Template: ShortText.
- src
Template: ShortText.
- role
Template: ShortText.
- previewable
Data type: DT_BOOL
- processing
Data type: DT_BOOL
- theme_store_id
Template: Id.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/orders/{{=parameters.order_id}}/transactions.json.The action has the following user-defined parameters:
- order_id: Required. Specify order identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/orders/{{=item.order_id}}/transactions.json.For further information check here.
The resource includes the fields from the Transaction template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/recurring_application_charges/{{=parameters.recurring_application_charge_id}}/usage_charges.json.The action has the following user-defined parameters:
- recurring_application_charge_id: Required. Specify recurring application charge identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/recurring_application_charges/{{=item.recurring_application_charge_id}}/usage_charges.json.For further information check here.
- id
A key field. Template: Id.
- description
Template: ShortText.
- price
Template: Currency.
- recurring_application_charge_id
Template: Id.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
- billing_on
Template: DateTime. A read-only field.
- balance_used
Template: Currency. A read-only field.
- balance_remaining
Template: Currency. A read-only field.
- risk_level
Data type: DT_R8
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/users.json.For further information check here.
- id
A key field. Template: Id.
- account_owner
Data type: DT_BOOL
- bio
Template: LongText.
Template: ShortText.
- first_name
Template: ShortText.
- im
Template: ShortText.
- last_name
Template: ShortText.
- permissions
Template: LongText.
- phone
Template: ShortText.
- receive_announcements
Data type: DT_I4
- screen_name
Template: ShortText.
- url
Template: ShortText.
- user_type
Template: ShortText.
- phone_validated
Data type: DT_BOOL
- tfa_enabled
Data type: DT_BOOL
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/admin/webhooks.json.For further information check here.
- [Create] action
-
Endpoint URL address:
/admin/webhooks.json.For further information check here.
- [Update] action
-
Endpoint URL address:
/admin/webhooks/{{=item.id}}.json.For further information check here.
- [Delete] action
-
Endpoint URL address:
/admin/webhooks/{{=item.id}}.json.For further information check here.
- id
A key field. Template: Id.
- address
Template: ShortText.
- fields
Template: LongText. A composite field.
- format
Template: ShortText.
- metafield_namespaces
Template: LongText. A composite field.
- topic
Template: ShortText.
- created_at
Template: DateTime. A read-only field.
- updated_at
Template: DateTime. A read-only field.
Knowledge Base
- Where can I find the documentation for the Shopify Connection?
- How to manually generate a Shopify Token?
What's New
- Fixed: Two resources having the same Transaction name.
- New: Replaced deprecated 'Discount' resource with the new 'Discount | Price Rule' and 'Discount | Discount Code' resources.
- New: Support for 'Payout', 'Balance', 'Dispute', 'Transaction' resources.
- Fixed: Various fixes.
- New: Support for cursor-based pagination process.
- New: Support for 'Inventory Item', 'Inventory Level', 'Inventory Location' resources.
- Fixed: Various fixes (Thank you Moe, Gaurav).
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.