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

Description

Use information in Zen Planner to update data in BigQuery.

Purchasing Options

everything plan - $0.0 / day

Available Actions

Update Data

Use information in Zen Planner to update data in BigQuery.

Variables

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.

scope_query required

Query to pull list of Scope ID's to sync from the Zen Planner Locations

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.


Zen Planner Parameters
zenplanner_credentials required

Credentials used to access Zen Planner.

data_type required

Select the type of data to update.

include_future_dated_records

Some data types, such as Classes, 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, such as Classes. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.