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

Load Data

Download data from Order My Gear and store it in a MySQL database.

Variables

Source Parameters
omg_connection required

Credentials to use to access Order My Gear.

data_type required

Select the type of data to download.

ids_query

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

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Range Parameters
pointer required

Optional datetime stamp indicating the starting point of the data to download. This field will be automatically updated after each increment of data is downloaded.

start_point_query

Optional SQL Query to use to determine the start point of the data to download. If specified, Next Run Start Point will be ignored.

end_point_query

Optional SQL Query to use to determine the end point of the data to download.

end_pointer

Optional datetime stamp indicating the stopping point of data to download. Only data created before the datetime specified will be downloaded. If blank, the current datetime will be used.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.

auto_adjust_range

Automatically shrink the Process Increment if the amount of data found exceeds the limit of what the API will return.


Destination Parameters
mysql_connection

Credentials to use to access the MySQL database.

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.

table_config required

Select a Shared Config with the Order My Gear data property to MySQL column name mappings and MySQL column definitions.

skip_errors

Continue uploading subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where errors will be stored.