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

Description

Use data from BigQuery to create information in Zen Planner.

Purchasing Options

BigQuery to Zen Planner Loader - $99.99 / month

Available Actions

Create Prospects

Read data from the BigQuery and use it to create new prospects in Zen Planner.

Variables

BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

column_to_attribute_map required

Shared Config containing mappings between BigQuery column names and Zen Planner attribute names.

sql_query required

SQL Query to find new prospects in BigQuery.

zenplanner_identifier_column required

Column that holds the id associated with the prospect in Zen Planner.

zenplanner_response_code_column required

Column that holds the response code from the prospect creation request.

zenplanner_response_message_column required

Column that holds the response content from the prospect creation request.

pointer

Datetime stamp indicating the starting point of the data to process. Formatted as YYYY-MM-DD HH:MM:SS in the UTC timezone. This field will be automatically updated at the end of each Task execution.

lookback

Fixed amount to adjust the Next Run Start Point.


Zen Planner Parameters
zenplanner_credentials required

Credentials to use to access Zen Planner.