Syncore Web to MySQL Loader

Obtain data from Syncore's web interface and store it in a MySQL database.

Load Proposals

Gather proposals from the Syncore website and load them into a MySQL table.

Variables

Source Parameters

syncore_connection required

Credentials to use to access Syncore via the web.

mysql_connection required

Credentials to use to access the MySQL database with contact ids.

contacts_ids_sql_query required

SQL Query to get contact ids. Only one SQL step is allowed.

user_params

Parameters to use in your Query, if any. Refer to slide out help for more information.

Destination Parameters

target_mysql_connection required

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

target_table_name required

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

post_sql_query

SQL Script to run after data retrieval is complete.

Load Quotes

Gather quotes from the Syncore website and load them into a MySQL table.