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

Description

Use information in Zen Planner to update data in BigQuery.

Purchasing Options

Zen Planner to BigQuery Loader - $99.99 / month

Available Actions

Update People

Use Person information in Zen Planner to update data in BigQuery.

Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.

pointer

Datetime stamp indicating the begin date of the data to update for data types that are date based. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

flush_after required

Number of results to gather before loading into the table.


ID Query Parameters
scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.

skip_invalid_scope_id

Continue processing remaining Scope IDs if an invalid Scope ID is encountered.


Update Classes

Use Class information in Zen Planner to update data in BigQuery.

Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.

pointer

Datetime stamp indicating the begin date of the data to update for data types that are date based. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

flush_after required

Number of results to gather before loading into the table.


ID Query Parameters
scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.

skip_invalid_scope_id

Continue processing remaining Scope IDs if an invalid Scope ID is encountered.


Update Events

Use Event information in Zen Planner to update data in BigQuery.

Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

flush_after required

Number of results to gather before loading into the table.


ID Query Parameters
scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.

events_query

Query to execute in BigQuery that will return a list of Event ID's.

skip_invalid_scope_id

Continue processing remaining Scope IDs if an invalid Scope ID is encountered.


Update Event Registrations

Use Event Registration information in Zen Planner to update data in BigQuery.

Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

flush_after required

Number of results to gather before loading into the table.


ID Query Parameters
scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.

events_query required

Query to execute in BigQuery that will return a list of Event ID's.

skip_invalid_scope_id

Continue processing remaining Scope IDs if an invalid Scope ID is encountered.


Update Event Schedules

Use Event Schedule information in Zen Planner to update data in BigQuery.

Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.

include_future_dated_records

Some data types have future dated records. Enable to include future dated records.

pointer

Datetime stamp indicating the begin date of the data to update for data types that are date based. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

flush_after required

Number of results to gather before loading into the table.


ID Query Parameters
scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.

skip_invalid_scope_id

Continue processing remaining Scope IDs if an invalid Scope ID is encountered.


Update Event Registration Forms

Use Event Registration Form information in Zen Planner to update data in BigQuery.

Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

flush_after required

Number of results to gather before loading into the table.


ID Query Parameters
scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.

events_query required

Query to execute in BigQuery that will return a list of Event ID's.

persons_query required

Query to execute in BigQuery that will return a list of Person ID's.

skip_invalid_scope_id

Continue processing remaining Scope IDs if an invalid Scope ID is encountered.


Update Memberships

Use Membership information in Zen Planner to update data in BigQuery.

Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.

pointer

Datetime stamp indicating the begin date of the data to update for data types that are date based. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

flush_after required

Number of results to gather before loading into the table.


ID Query Parameters
scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.

persons_query

Optional query to execute in BigQuery that will return a list of Person ID's.

skip_invalid_scope_id

Continue processing remaining Scope IDs if an invalid Scope ID is encountered.


Update Groups

Use Group information in Zen Planner to update data in BigQuery.

Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

flush_after required

Number of results to gather before loading into the table.


ID Query Parameters
scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.

skip_invalid_scope_id

Continue processing remaining Scope IDs if an invalid Scope ID is encountered.


Update Groups by Person

Use Group information from a list of people in Zen Planner to update data in BigQuery.

Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.

pointer

Datetime stamp indicating the begin date of the data to update for data types that are date based. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

flush_after required

Number of results to gather before loading into the table.


ID Query Parameters
scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.

persons_query required

Query to execute in BigQuery that will return a list of Person ID's.

skip_invalid_scope_id

Continue processing remaining Scope IDs if an invalid Scope ID is encountered.


Update Class Attendances

Use Class Attendance information from a list of classes in Zen Planner to update data in BigQuery.

Variables

Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.

pointer

Datetime stamp indicating the begin date of the data to update for data types that are date based. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.

nrsp_sql_only

Enable to use the Next Run Start Point as a parameter in SQL Queries only and not as a filter with the modification date of Zen Planner records.


BigQuery Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

gcp_project_id required

Name of the project with the dataset where the data will be updated.

gcp_dataset_id required

Name of the dataset with the table where the data will be updated.

gcp_table required

Name of the table where the data will be updated.

create_dataset_if_not_exists

Enable to create the specified dataset if it does not exist.

load_pattern

Select which pattern to use when loading the data.

flush_after required

Number of results to gather before loading into the table.


ID Query Parameters
scope_query required

Query to execute in BigQuery that will return a list of Scope ID's.

classes_query required

Query to execute in BigQuery that will return a list of Class ID's.

skip_invalid_scope_id

Continue processing remaining Scope IDs if an invalid Scope ID is encountered.