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.


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 required

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.

api_calls_limit

Number of API calls allowed per execution.


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 required

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.

buffer

Fixed amount to adjust the Next Run Start Point.

api_calls_limit

Number of API calls allowed per execution.


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 required

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.

buffer

Fixed amount to adjust the Next Run Start Point.

api_calls_limit

Number of API calls allowed per execution.


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.