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




Description

Obtain information from ManageOrders and store it in a MySQL database.


Purchasing Options



Available Actions

Download Orders

Download orders from ManageOrders and store them in a table in a MySQL database.


Variables

Source Parameters
manage_orders_credentials required

Credentials to use to access ManageOrders.

last_run required

Date stamp indicating the starting point, based on updated date, of the data to download. Only data updated on or after the date specified will be downloaded. This field will be automatically updated after each successful Task execution. Formatted as YYYY-MM-DD.

process_increment required

Multiple submissions are made to request data. Too much data requested in a single submission will result in a failure. Specify the number of days worth of data to request in each submission.


Destination Parameters
mysql_connection required

MySQL database where the data will be loaded.

target_table required

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


Download Payments

Download payments from ManageOrders and store them in a table in a MySQL database.


Variables

Source Parameters
manage_orders_credentials required

Credentials to use to access ManageOrders.

last_run required

Date stamp indicating the starting point, based on updated date, of the data to download. Only data updated on or after the date specified will be downloaded. This field will be automatically updated after each successful Task execution. Formatted as YYYY-MM-DD.

process_increment required

Multiple submissions are made to request data. Too much data requested in a single submission will result in a failure. Specify the number of days worth of data to request in each submission.


Destination Parameters
mysql_connection required

MySQL database where the data will be loaded.

target_table required

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


Download Tracking Information

Download tracking information from ManageOrders and store it in a table in a MySQL database.


Variables

Source Parameters
manage_orders_credentials required

Credentials to use to access ManageOrders.

last_run required

Date stamp indicating the starting point, based on updated date, of the data to download. Only data updated on or after the date specified will be downloaded. This field will be automatically updated after each successful Task execution. Formatted as YYYY-MM-DD.

process_increment required

Multiple submissions are made to request data. Too much data requested in a single submission will result in a failure. Specify the number of days worth of data to request in each submission.


Destination Parameters
mysql_connection required

MySQL database where the data will be loaded.

target_table required

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


Download Inventory Levels

Download inventory levels from ManageOrders and store them in a table in a MySQL database.


Variables

Source Parameters
manage_orders_credentials required

Credentials to use to access ManageOrders.

last_run required

Date stamp indicating the starting point, based on updated date, of the data to download. Only data updated on or after the date specified will be downloaded. This field will be automatically updated after each successful Task execution. Formatted as YYYY-MM-DD.

process_increment required

Multiple submissions are made to request data. Too much data requested in a single submission will result in a failure. Specify the number of days worth of data to request in each submission.


Destination Parameters
mysql_connection required

MySQL database where the data will be loaded.

target_table required

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


Download Line Items

Download line items from ManageOrders and store them in a table in a MySQL database.


Variables

Source Parameters
manage_orders_credentials required

Credentials to use to access ManageOrders.

last_run required

Date stamp indicating the starting point, based on updated date, of the data to download. Only data updated on or after the date specified will be downloaded. This field will be automatically updated after each successful Task execution. Formatted as YYYY-MM-DD.

process_increment required

Multiple submissions are made to request data. Too much data requested in a single submission will result in a failure. Specify the number of days worth of data to request in each submission.


Destination Parameters
mysql_connection required

MySQL database where the data will be loaded.

target_table required

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