Skip to main content

tools

Creates, updates, deletes, gets or lists a tools resource.

Overview

Nametools
TypeResource
Idgoogle.connectors.tools

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringName of the tool.
_metaobjectMetadata for the tool.
annotationsobjectAnnotations for the tool. (id: ToolAnnotations)
dependsOnarrayList of tool names that this tool depends on.
descriptionstringDescription of the tool.
inputSchemaobjectJsonSchema representation of schema metadata (id: JsonSchema)
outputSchemaobjectJsonSchema representation of schema metadata (id: JsonSchema)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprojectsId, locationsId, connectionsIdpageToken, toolNames, executionConfig.headers, pageSizeLists all available tools.
executeexecprojectsId, locationsId, connectionsId, toolsIdExecutes a specific tool.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
connectionsIdstring
locationsIdstring
projectsIdstring
toolsIdstring
executionConfig.headersstring
pageSizeinteger (int32)
pageTokenstring
toolNamesstring

SELECT examples

Lists all available tools.

SELECT
name,
_meta,
annotations,
dependsOn,
description,
inputSchema,
outputSchema
FROM google.connectors.tools
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND connectionsId = '{{ connectionsId }}' -- required
AND pageToken = '{{ pageToken }}'
AND toolNames = '{{ toolNames }}'
AND executionConfig.headers = '{{ executionConfig.headers }}'
AND pageSize = '{{ pageSize }}'
;

Lifecycle Methods

Executes a specific tool.

EXEC google.connectors.tools.execute
@projectsId='{{ projectsId }}' --required,
@locationsId='{{ locationsId }}' --required,
@connectionsId='{{ connectionsId }}' --required,
@toolsId='{{ toolsId }}' --required
@@json=
'{
"parameters": "{{ parameters }}",
"executionConfig": "{{ executionConfig }}",
"toolDefinition": "{{ toolDefinition }}"
}'
;