Obtain orders from Bonfire and store them in a MySQL database.
Scrape orders from the Bonfire website and load them into a MySQL table.
Variables
E-mail address and password to access Bonfire.
MySQL database where the data from Bonfire will be loaded.
Target table name, in schema.table format, where the data will be stored.
Enable to ignore columns that exist in data downloaded, but not in the Target Table. Disable to fail the task execution when the columns don't match.
Place a check in the Products ordered checkbox for the order ids returned by an SQL Query.
Variables
MySQL database to query for order ids.
SQL Query to run.
SQL steps to run after marking the Products ordered checkboxes.
E-mail address and password to access Bonfire.
Retrieve order information from Bonfire by using orders ids and load it into a MySQL table.
Variables
E-mail address and password to access Bonfire.
MySQL database where the data from Bonfire will be loaded.
Target table name, in schema.table format, where the data will be stored.
SQL Query to retrieve order ids.
Enable to ignore columns that exist in data downloaded, but not in the Target Table. Disable to fail the task execution when the columns don't match.
Datetime stamp indicating the starting point to use to gather order ids. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone. Automatically updated after each task execution.
SQL Query to use to determine the end point of the data to process. Leave this field blank to process all records with a datetime stamp after the starting point.