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

Description

Obtain information from Bright Sites and store it in a MySQL database.

Purchasing Options

Bright Sites to MySQL Loader - $99.99 / month

Available Actions

Load Inventory

Download inventory data from the Bright Sites and store it in a MySQL database.

Variables

Source Parameters
brightsites_connection required

Credentials used to access Bright Sites.

api_calls_limit

Number of API calls allowed per execution.

skip_errors

Continue downloading subsequent data if an error occurs.


Destination Parameters
mysql_connection required

MySQL database where the data will be stored.

table_name required

Table name, in schema.table format, where the data will be stored.

fields_to_skip

Comma-separated list of object properties. Null will be loaded instead of the property's actual value.

create_table_if_dne required

Create the table, if it does not exist, otherwise end the Task.


Load Orders

Download order data from Bright Sites and store it in a MySQL database.

Variables

Source Parameters
brightsites_connection required

Credentials used to access Bright Sites.

start_point

Datetime stamp indicating the starting point, based on updated date, of the data to download. This field will be automatically updated. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

start_point_query

Optional SQL Query to use to determine the starting point of the information to retrieve. If specified, Next Run Start Point will be ignored.

api_calls_limit

Number of API calls allowed per execution.

skip_errors

Continue downloading subsequent data if an error occurs.


Destination Parameters
mysql_connection required

MySQL database where the data will be stored.

table_name required

Table name, in schema.table format, where the data will be stored.

fields_to_skip

Comma-separated list of object properties. Null will be loaded instead of the property's actual value.

create_table_if_dne required

Create the table, if it does not exist, otherwise end the Task.


Load Products

Download product data from the Bright Sites and store it in a MySQL database.

Variables

Source Parameters
brightsites_connection required

Credentials used to access Bright Sites.

start_point

Datetime stamp indicating the starting point, based on updated date, of the data to download. This field will be automatically updated. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

start_point_query

Optional SQL Query to use to determine the starting point of the information to retrieve. If specified, Next Run Start Point will be ignored.

buffer

Fixed amount to adjust the Next Run Start Point.

api_calls_limit

Number of API calls allowed per execution.

skip_errors

Continue downloading subsequent data if an error occurs.


Destination Parameters
mysql_connection required

MySQL database where the data will be stored.

table_name required

Table name, in schema.table format, where the data will be stored.

fields_to_skip

Comma-separated list of object properties. Null will be loaded instead of the property's actual value.

create_table_if_dne required

Create the table, if it does not exist, otherwise end the Task.


Load Product Images

Download product image data from the Bright Sites and store it in a MySQL database.

Variables

Source Parameters
brightsites_connection required

Credentials used to access Bright Sites.

products_ids_query required

SQL query to return a list of product ids.

start_point

Datetime stamp indicating the starting point, based on updated date, of the data to download. This field will be automatically updated. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

start_point_query

Optional SQL Query to use to determine the starting point of the information to retrieve. If specified, Next Run Start Point will be ignored.

buffer

Fixed amount to adjust the Next Run Start Point.

api_calls_limit

Number of API calls allowed per execution.

skip_errors

Continue downloading subsequent data if an error occurs.


Destination Parameters
mysql_connection required

MySQL database where the data will be stored.

table_name required

Table name, in schema.table format, where the data will be stored.

fields_to_skip

Comma-separated list of object properties. Null will be loaded instead of the property's actual value.

create_table_if_dne required

Create the table, if it does not exist, otherwise end the Task.