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

Description

Obtain data from SupplyLogic and load it into MySQL.

Purchasing Options

SupplyLogic to MySQL Loader - $149.99 / month

Available Actions

Load Purchase Orders

Download purchase order data from SupplyLogic and store it in MySQL.

Variables

Source Parameters
supply_logic_connection required

Credentials to use to connect to SupplyLogic.

supply_logic_server required

Select which environment to download data from.

supplier required

ID of the Supplier to download purchase orders for.

part_to_remove

Optionally specify a portion of the XML tags to remove.


Range Parameters
pointer

Date indicating the starting point, based on order date, of the data to download. Only orders created on or after the date specified will be downloaded. This field will be automatically updated after each increment of data is downloaded. Formatted as YYYY-MM-DD.

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. Date indicating the stopping point, based on order date, of the data to download. Only data created on or before the date specified will be downloaded. If blank, the current date will be used. Formatted as YYYY-MM-DD.

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
db required

Credentials to use to connect to the MySQL database where the data will be stored.

target_table required

Name of the table, in schema.table format, where data will be stored.

create_table_if_dne required

If the specified table does not exist, enable to automatically create it.

table_config required

Select a Shared Config with the SupplyLogic tag path to MySQL column name mappings and definitions.