Connect Hermes to Google BigQuery and Confluence

Run a SQL query and return results inline (synchronous, bounded by timeout).

Page through the results of a (possibly async) query job.

Start a query / load / extract / copy job (async).

Fetch a job's status and statistics (poll until DONE).

List jobs in a project (filter by state, time range).

Request cancellation of a running job.

Delete a job's metadata.

List datasets in the project.

Fetch dataset metadata.

Create a new dataset.

Full replace of dataset metadata (PUT).

Partial update of dataset metadata (PATCH).

Delete a dataset.

List tables/views in a dataset.

Fetch table metadata/schema.

Create a table or view with a schema.

Partial update of a table (add columns, set expiration, etc.).

Full replace of table metadata (PUT).

Delete a table or view.

Streaming insert of JSON rows into a table (real-time append).

Read rows from a table directly (paginated, no SQL).

List stored procedures / UDFs / TVFs in a dataset.

Fetch a routine definition.

Create a stored procedure / UDF / TVF.

List BigQuery ML models in a dataset.

Fetch BQML model metadata.

Delete a BQML model.

Return the BigQuery service account for the project (KMS/transfer grants).

List projects the caller can access (for project picker UIs).

Restore a dataset within its time-travel window (datasets.undelete).

Replace a routine's full definition (routines.update, PUT).

Delete a routine (routines.delete).

Update mutable BQML model metadata (models.patch).

Get the IAM policy for a table (tables.getIamPolicy).

Set the IAM policy for a table (tables.setIamPolicy).

Test the caller's permissions on a table (tables.testIamPermissions).

List row access policies on a table (rowAccessPolicies.list).

Get a single row access policy (rowAccessPolicies.get).

List pages, optionally filtered by space, status, or title.

Get a single page by ID, optionally including its body.

Create a page in a space.

Update a page. Requires the new version number (current + 1).

Trash (or permanently purge) a page.

List all pages within a given space.

List the direct child pages of a page.

List the version history of a page.

Get the ancestor pages (breadcrumb path) of a page.

List blog posts, optionally filtered by space or status.

Get a single blog post by ID, optionally including its body.

Create a blog post in a space.

Update a blog post. Requires the new version number (current + 1).

Delete a blog post.

List spaces, optionally filtered by key, type, or status.

Get a single space by ID.

Create a new Confluence space.

List labels applied to a space.

List footer comments on a page.

Add a footer comment to a page or blog post.

Update the body of a footer comment.

Delete a footer comment.

List footer comments on a blog post.

List inline (highlight) comments on a page.

Create an inline comment anchored to selected text on a page or blog post.

Update the body of an inline comment.

Delete an inline comment.

List inline comments on a blog post.

List attachments on a page.

Get attachment metadata, including its download link.

Upload a file as an attachment to a page (v1 multipart API).

Delete an attachment.

List labels attached to a page.

Add a label to content (page or blog post). Uses the v1 API.

Remove a label from content (page or blog post). Uses the v1 API.

List custom content properties (key/value metadata) on a page.

Set a custom content property on a page.

Update an existing content property on a page (requires the property ID and current version).

Delete a content property from a page.

List inline tasks (checkboxes) across the site or filtered by space/page.

Get a single inline task by ID.

Update an inline task (e.g., mark as complete or incomplete).

Full-text / structured search via CQL (v1). Returns search results.

CQL search returning content objects only (v1).

Get the authenticated user's account info (v1).