# ExecuteQuery Required Frends version: 5.5+ Required .NET version: 6.0 Compatible Agents: Crossplatform Source code: {% tabs %} {% tab title="Parameter: Connection" %} | Name | Description | | ---------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | ProjectId : `String` |

Project ID.


Default: -
Example: global-env-397309

| | DatasetId : `String` |

Dataset ID.


Default: -
Example: baseball

| | TableId : `String` |

Table ID.


Default: -
Example: games\_post\_wide

| | ReadJsonMethod : `ReadJsonMethods` |

Method to read Service account JSON.

Possible values:

Method to read Service account JSON.

Method to read Service account JSON.


Default: 1
Example: ReadJsonMethods.File

| | 🗝SecretJson : `String` |

Service account key file.


Default: -
Example: { "type": "service\_account", "project\_id": "your-project-id", ... }

| | CredentialsFilePath : `String` |

Filepath to service account key file.


Default: -
Example: C:\temp\jsonfile.json

| | {% endtab %} | | {% tab title="Parameter: Input" %} | Name | Description | | ------------------------------------------ | --------------------------------------------------------------------------------------------- | | Query : `String` |

Query.


Default: -
Example: SELECT \* FROM table

| | BigQueryParameter : `BigQueryParameters[]` |

Parameters.


Default: -
Example: parametername

| | {% endtab %} | | {% tab title="Parameter: Options" %} | Name | Description | | -------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | ThrowOnError : `Boolean` |

Throw an error on exception.

If set to false, exception message can be found in Result.ErrorMessage.


Default: True
Example: true

| | MaxRetryAttempts : `Int32` |

Maximum number of retry attempts before throwing an exception or ending this Task.


Default: -
Example: 1

| | Delay : `Int32` |

Delay in seconds between retry attempts.


Default: -
Example: 5

| | {% endtab %} | | {% tab title="Result: Result" %} | Name | Description | | ----------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Success : `Boolean` |

Operation complete without errors.
Example: true

| | Data : `Object` |

Result as JToken.
Example: { "integer\_field": 1, "string\_field": "Sample String", "date\_field": "2023-09-20T00:00:00", "float\_field": 3.14, "boolean\_field": true, "timestamp\_field": "2023-09-20T12:34:56Z", "time\_field": "12:34:56.7890000", "datetime\_field": "2023-09-20T12:34:56.789", "record\_field": { "nested\_string": "Nested String" }, "array\_field": \[ "Item 1", "Item 2" ], "name": "John Smith", "age": 30 }

| | ErrorMessage : `String` |

Error message.
Example: Error occured...

| | {% endtab %} | | {% tab title="Changelog" %} ## Changelog ### \[1.0.0] - 2023-09-20 #### Added * Initial implementation {% endtab %} {% endtabs %}