{
  "$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.

{
  "$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
1000
​
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"
]
​
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
}
]
​
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"
]
​
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"