Obtain data from Syncore and load it into a MySQL database.
Download data of the selected type from Syncore and store it in a MySQL database.
Variables
Credentials to use to access Syncore.
Type of data to download from Syncore.
SQL query returning a list of Job IDs. Required when SalesOrders or PurchaseOrders is selected for Data Type.
Parameters to use in your SQL Query, if any.
Filters to limit the data to download. Refer to slide out help for more information.
Continue downloading subsequent data if an error occurs.
Optional name of the table, in schema.table format, where errors will be stored.
Optional. Datetime stamp indicating the starting point, based on creation datetime, of the data to process. Not used if Suppliers, CommissionCodes and ProductIndices is selected for Data Type. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone. If specified, this field will be automatically updated.
Optional. SQL Query to use to determine the start point of the data to process. If specified, Next Run Start Point will be ignored.
Optional. Datetime stamp indicating the stopping point, based on creation datetime, of the data to process. If blank, the current datetime will be used. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.
Optional. SQL Query to use to determine the stopping point of the data to process. If specified, End Point will be ignored.
This Task will process data in increments. Set a value in this field to determine the size of each increment.
Credentials to use to access the MySQL Database.
Name of the table, in schema.table format, where data will be stored.
Automatically create the Target Table, if it does not exist.
Select a Shared Config with the Syncore data property to MySQL column name mappings and MySQL column definitions.
Automatically create columns in the Target Table for data properties that exist in data from Syncore but not in the API to SQL Shared Config.