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

Credentials to use to access Order My Gear.

mysql_store_ids_connection required

MySQL database where store ID's are stored.

store_ids_query required

SQL Query to obtain the list of store ID's corresponding to the orders to download.

user_params

Parameters to use in the Store ID Query, if any. Refer to slide out help for more information.

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 and including the date specified will be loaded. Formatted as YYYY-MM-DD in UTC timezone. Leave this field blank to load all data updated up to and including the day prior to the current date when the Task is executed.


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

Automatically create the Target Table, if it does not exist, otherwise end the Task.