You can't use this until you register with us!

Description

Obtain information from Order My Gear and store it in a MySQL database.

Purchasing Options

Order My Gear to MySQL Loader - $99.99 / month

Available Actions

Process Orders

Download order data from the Order My Gear REST API and upload it to a MySQL database.

Variables

Source Parameters
omg_connection required

Authorization Token used to access Order My Gear.

store_ids required

Comma separated list of store ids corresponding to the order data to load.

pointer required

Date stamp indicating the starting point, based on updated date, of the data to load. Only data updated after the date specified will be loaded. This field will be automatically updated after each day's worth of data is loaded. Formatted as YYYY-MM-DD in UTC timezone.

range_end_point

Data updated up to the date specified will be loaded. Formatted as YYYY-MM-DD in UTC timezone. Leave this field blank to load all data updated after the starting point.


Destination Parameters
mysql_connection required

MySQL database where the data will be stored.

target_table required

Target table name, in schema.table format, where the data will be stored.

create_table_if_dne required

If the target and staging tables do not exist, automatically create them, otherwise end the Task.