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




Description

Obtain data from ShipStation and store it in a MySQL database.


Purchasing Options



Available Actions

Load Orders

Obtain order data from ShipStation and store it in a table in a MySQL database.


Variables

ShipStation Parameters
shipstation_credentials required

Credentials used to access ShipStation.

process_increment

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

last_run required

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

end_point

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


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.


Load Shipments

Obtain shipment data from ShipStation and store it in a table in a MySQL database.


Variables

ShipStation Parameters
shipstation_credentials required

Credentials used to access ShipStation.

process_increment

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

last_run required

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

end_point

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


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.