{
  "$result_object_key": {
    "estimated_row_count": 1000,
    "partition": "2025-03-17",
    "schema_differences": [
      {
        "description": "Number of visits of this patient",
        "field": "number_of_visits",
        "field_addition": {},
        "field_type": "INTEGER",
        "field_update": {
          "new_description": "Number of visits of this patient",
          "new_field_type": "STRING",
          "new_repeated": true,
          "new_required": false
        },
        "nested_field_changes": null,
        "repeated": false,
        "required": true
      }
    ],
    "table_name": "healthie_patient_updated",
    "table_schema": [
      {
        "description": "Number of visits of this patient",
        "fields": null,
        "name": "number_of_visits",
        "repeated": false,
        "required": true,
        "type": "INTEGER"
      }
    ]
  }
}

{
  "$result_object_key": {
    "estimated_row_count": "Estimated total number of rows including the data just inserted",
    "partition": "Date partition the data was saved to",
    "schema_differences": {
      "description": "Field description",
      "field": "Field name",
      "field_addition": {},
      "field_type": "Field type",
      "field_update": {
        "new_description": "New description",
        "new_field_type": "New field type",
        "new_repeated": "New value for whether the field is a list",
        "new_required": "New value for whether the field is required"
      },
      "nested_field_changes": null,
      "repeated": "If the field is a list",
      "required": "If the field is required"
    },
    "table_name": "Table name used to save the data",
    "table_schema": {
      "description": "Field description",
      "fields": null,
      "name": "Field name",
      "repeated": "If the field is a list",
      "required": "If the field is required",
      "type": "Field type"
    }
  }
}

Parameters

Action

Parameters

Project ID

string

required

This field maps to the destination API projectID field.

Dataset ID

string

required

This field maps to the destination API datasetID field.

Table Name

string

This field maps to the destination API tableName field.

Fields

Map<string,dynamic (any)>

required

HI ID PII This field maps to the destination API fields field.

Additionally Include Event Fields At The Top Level

bool

This field maps to the destination API additionallyIncludeEventFieldsAtTheTopLevel field.

{
  "$result_object_key": {
    "estimated_row_count": 1000,
    "partition": "2025-03-17",
    "schema_differences": [
      {
        "description": "Number of visits of this patient",
        "field": "number_of_visits",
        "field_addition": {},
        "field_type": "INTEGER",
        "field_update": {
          "new_description": "Number of visits of this patient",
          "new_field_type": "STRING",
          "new_repeated": true,
          "new_required": false
        },
        "nested_field_changes": null,
        "repeated": false,
        "required": true
      }
    ],
    "table_name": "healthie_patient_updated",
    "table_schema": [
      {
        "description": "Number of visits of this patient",
        "fields": null,
        "name": "number_of_visits",
        "repeated": false,
        "required": true,
        "type": "INTEGER"
      }
    ]
  }
}

{
  "$result_object_key": {
    "estimated_row_count": "Estimated total number of rows including the data just inserted",
    "partition": "Date partition the data was saved to",
    "schema_differences": {
      "description": "Field description",
      "field": "Field name",
      "field_addition": {},
      "field_type": "Field type",
      "field_update": {
        "new_description": "New description",
        "new_field_type": "New field type",
        "new_repeated": "New value for whether the field is a list",
        "new_required": "New value for whether the field is required"
      },
      "nested_field_changes": null,
      "repeated": "If the field is a list",
      "required": "If the field is required"
    },
    "table_name": "Table name used to save the data",
    "table_schema": {
      "description": "Field description",
      "fields": null,
      "name": "Field name",
      "repeated": "If the field is a list",
      "required": "If the field is required",
      "type": "Field type"
    }
  }
}

Result Object Field Details

You can use the result of the action’s data as inputs to downstream workflow actions.

Each fetch action requires a result object key to be specified which will nest the action’s result data inside the downstream data context in the Workflow.

Here we demonstrate how to refer to this data using the prefix $result_object_key.

SaveToBigQueryResponse

Fetch Action Response Object

partition

values.v1.Date

required

Date partition the data was saved to

CEL

$result_object_key.partition

Example

"2025-03-17"

estimated_row_count

uint64

required

Estimated total number of rows including the data just inserted

CEL

$result_object_key.estimated_row_count

Example

schema_differences

object

required

Description coming soon

CEL

$result_object_key.schema_differences

Example

[
{
"description": "Number of visits of this patient",
"field": "number_of_visits",
"field_addition": {},
"field_type": "INTEGER",
"field_update": {
"new_description": "Number of visits of this patient",
"new_field_type": "STRING",
"new_repeated": true,
"new_required": false
},
"nested_field_changes": null,
"repeated": false,
"required": true
}
]

schema_differences.map(x, x.field)

[]string

required

Mapped array of: Field name

CEL

$result_object_key.schema_differences.map(x, x.field)

Example

[
"number_of_visits"
]

schema_differences.map(x, x.description)

[]string

required

Mapped array of: Field description

CEL

$result_object_key.schema_differences.map(x, x.description)

Example

[
"Number of visits of this patient"
]

field_type

google.bigquery.v1.FieldType

required

Mapped array of: Field type

CEL

field_type

Example

STRING
BYTES
INTEGER
FLOAT
BOOLEAN
TIMESTAMP
RECORD
DATE
TIME
DATETIME
NUMERIC
GEOGRAPHY
BIGNUMERIC
INTERVAL
JSON
RANGE

schema_differences.map(x, x.repeated)

[]bool

required

Mapped array of: If the field is a list

CEL

$result_object_key.schema_differences.map(x, x.repeated)

Example

[
false
]

schema_differences.map(x, x.required)

[]bool

required

Mapped array of: If the field is required

CEL

$result_object_key.schema_differences.map(x, x.required)

Example

[
true
]

schema_differences.map(x, x.nested_field_changes)

[]bool

required

Description coming soon

CEL

$result_object_key.schema_differences.map(x, x.nested_field_changes)

Example

[
[
{
"description": "Number of visits of this patient",
"field": "number_of_visits",
"field_addition": {},
"field_type": "INTEGER",
"field_update": {
  "new_description": "Number of visits of this patient",
  "new_field_type": "STRING",
  "new_repeated": true,
  "new_required": false
},
"nested_field_changes": null,
"repeated": false,
"required": true
}
]
]

schema_differences.map(x, x.field_addition)

[]bool

required

Description coming soon

CEL

$result_object_key.schema_differences.map(x, x.field_addition)

Example

[
{}
]

schema_differences.map(x, x.field_update)

[]bool

required

Description coming soon

CEL

$result_object_key.schema_differences.map(x, x.field_update)

Example

[
{
"new_description": "Number of visits of this patient",
"new_field_type": "STRING",
"new_repeated": true,
"new_required": false
}
]

schema_differences.map(x, x.field_update)

[]string

required

Description coming soon

CEL

$result_object_key.schema_differences.map(x, x.field_update)

Example

[
{
"new_description": "Number of visits of this patient",
"new_field_type": "STRING",
"new_repeated": true,
"new_required": false
}
]

field_update.new_field_type

google.bigquery.v1.FieldType

New field type

CEL

field_update.new_field_type

Example

STRING
BYTES
INTEGER
FLOAT
BOOLEAN
TIMESTAMP
RECORD
DATE
TIME
DATETIME
NUMERIC
GEOGRAPHY
BIGNUMERIC
INTERVAL
JSON
RANGE

schema_differences.map(x, x.field_update)

[]bool

required

Description coming soon

CEL

$result_object_key.schema_differences.map(x, x.field_update)

Example

[
{
"new_description": "Number of visits of this patient",
"new_field_type": "STRING",
"new_repeated": true,
"new_required": false
}
]

schema_differences.map(x, x.field_update)

[]bool

required

Description coming soon

CEL

$result_object_key.schema_differences.map(x, x.field_update)

Example

[
{
"new_description": "Number of visits of this patient",
"new_field_type": "STRING",
"new_repeated": true,
"new_required": false
}
]

table_schema

object

required

Description coming soon

CEL

$result_object_key.table_schema

Example

[
{
"description": "Number of visits of this patient",
"fields": null,
"name": "number_of_visits",
"repeated": false,
"required": true,
"type": "INTEGER"
}
]

table_schema.map(x, x.name)

[]string

required

Mapped array of: Field name

CEL

$result_object_key.table_schema.map(x, x.name)

Example

[
"number_of_visits"
]

type

google.bigquery.v1.FieldType

required

Mapped array of: Field type

CEL

type

Example

STRING
BYTES
INTEGER
FLOAT
BOOLEAN
TIMESTAMP
RECORD
DATE
TIME
DATETIME
NUMERIC
GEOGRAPHY
BIGNUMERIC
INTERVAL
JSON
RANGE

table_schema.map(x, x.repeated)

[]bool

required

Mapped array of: If the field is a list

CEL

$result_object_key.table_schema.map(x, x.repeated)

Example

[
false
]

table_schema.map(x, x.required)

[]bool

required

Mapped array of: If the field is required

CEL

$result_object_key.table_schema.map(x, x.required)

Example

[
true
]

table_schema.map(x, x.description)

[]string

required

Mapped array of: Field description

CEL

$result_object_key.table_schema.map(x, x.description)

Example

[
"Number of visits of this patient"
]

table_schema.map(x, x.fields)

[]bool

required

Description coming soon

CEL

$result_object_key.table_schema.map(x, x.fields)

Example

[
[
{
"description": "Number of visits of this patient",
"fields": null,
"name": "number_of_visits",
"repeated": false,
"required": true,
"type": "INTEGER"
}
]
]

table_name

string

required

Table name used to save the data

CEL

$result_object_key.table_name

Example

"healthie_patient_updated"

Fetch Contacts Send Conversion Event

{
  "$result_object_key": {
    "estimated_row_count": 1000,
    "partition": "2025-03-17",
    "schema_differences": [
      {
        "description": "Number of visits of this patient",
        "field": "number_of_visits",
        "field_addition": {},
        "field_type": "INTEGER",
        "field_update": {
          "new_description": "Number of visits of this patient",
          "new_field_type": "STRING",
          "new_repeated": true,
          "new_required": false
        },
        "nested_field_changes": null,
        "repeated": false,
        "required": true
      }
    ],
    "table_name": "healthie_patient_updated",
    "table_schema": [
      {
        "description": "Number of visits of this patient",
        "fields": null,
        "name": "number_of_visits",
        "repeated": false,
        "required": true,
        "type": "INTEGER"
      }
    ]
  }
}

{
  "$result_object_key": {
    "estimated_row_count": "Estimated total number of rows including the data just inserted",
    "partition": "Date partition the data was saved to",
    "schema_differences": {
      "description": "Field description",
      "field": "Field name",
      "field_addition": {},
      "field_type": "Field type",
      "field_update": {
        "new_description": "New description",
        "new_field_type": "New field type",
        "new_repeated": "New value for whether the field is a list",
        "new_required": "New value for whether the field is required"
      },
      "nested_field_changes": null,
      "repeated": "If the field is a list",
      "required": "If the field is required"
    },
    "table_name": "Table name used to save the data",
    "table_schema": {
      "description": "Field description",
      "fields": null,
      "name": "Field name",
      "repeated": "If the field is a list",
      "required": "If the field is required",
      "type": "Field type"
    }
  }
}

Events

Actions

Integrations

Save To Bigquery

Parameters

Result Object Field Details

Events

Actions

Integrations

​Parameters

​Result Object Field Details

Parameters

Result Object Field Details