MySQL to SupplyLogic Loader

Description

Use data from MySQL to create objects in SupplyLogic.

Purchasing Options

MySQL to SupplyLogic Loader - $149.99 / month

Available Actions

Create Invoices

Use data from MySQL to create invoices in SupplyLogic.

Variables

Source Parameters

db required

Credentials to use to connect to the MySQL database.

query_template required

Query to obtain the cXML data for the objects to create.

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 processed. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

start_point_query

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

end_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

supply_logic_connection required

Credentials to use to connect to SupplyLogic.

supply_logic_server required

Select which environment to create objects in.

Create Fulfill Notices

Use data from MySQL to create fulfill notices in SupplyLogic.