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




Description

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


Purchasing Options



Available Actions

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.

create_table_if_dne

If the specified table does not exist, enable to automatically create it.

use_predefined_schema

If the table will be automatically generated, enable to use a predefined schema for column names and types.

table_config

If the table will be automatically generated and using the predefined schema is not enabled, select a Shared Config with the column names and types.

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.


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.

create_table_if_dne

If the specified table does not exist, enable to automatically create it.

use_predefined_schema

If the table will be automatically generated, enable to use a predefined schema for column names and types.

table_config

If the table will be automatically generated and using the predefined schema is not enabled, select a Shared Config with the column names and types.

post_sql_query

SQL Script to run after data retrieval is complete.