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

Description

Create objects in ShipHero using data from MySQL.

Purchasing Options

MySQL to ShipHero Loader - $149.99 / month

Available Actions

Update Objects

Create or update objects in ShipHero using data obtained from a MySQL database.

Variables

Source Parameters
db required

MySQL database where the data will be stored.

query required

SQL query to return the JSON representations of the objects to create or update.

user_params

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


Range Parameters
pointer

Datetime stamp indicating the starting point, based on creation datetime, of the data to process. Only data created after the datetime specified will be processed. This field will be automatically updated after each increment of data is loaded. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

range_start_point_query

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

end_range_pointer

Optional datetime stamp indicating the stopping point, based on creation datetime, of the data to process. Only data created before the datetime specified will be processed. If blank, the current datetime will be used. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

process_increment required

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


Destination Parameters
shiphero_connection required

Credentials to use to connect to ShipHero.