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:

Successful response

NameDatatypeDescription
namestringName of the tool.
descriptionstringDescription of the tool.
inputSchemaobjectJSON schema for the input parameters of the tool. (id: JsonSchema)
outputSchemaobjectJSON schema for the output of the tool. (id: JsonSchema)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprojectsId, locationsId, connectionsIdpageSize, pageTokenLists 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
pageSizeinteger (int32)
pageTokenstring

SELECT examples

Lists all available tools.

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

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 }}"
}';