Connect Grist to Open Government, Queensland Government

Both apps 36Grist 25Open Government, Queensland Government 11

• Trigger
  New or Updated Record

  Triggered when a row in a Grist table is created or updated.

• Trigger
  New or Updated Record (Instant)

  Triggers when a Record is updated, or a new Record is added.

• Trigger
  New Record

  Triggered when a new row is added to a Grist table.

• Trigger
  New Record (Instant)

  Triggers when a new Record is created

• Action
  Add Column

  Adds a column to a table in a Grist document.

• Action
  Add Table

  Creates a new table in a Grist document, optionally with a starting set of columns.

• Action
  Create Document

  Creates a new document in a Grist workspace and returns its document ID.

• Action
  Create or Update Record

  Adds a row to a Grist table, or updates the existing row when the match column already holds the match value. Returns the row ID.

• Action
  Create Record

  Adds a new row to a Grist table and returns its row ID.

• Action
  Create Workspace

  Creates a new workspace in a Grist organization and returns its ID.

• Action
  Delete Document

  Deletes a Grist document permanently.

• Action
  Delete Records

  Deletes one or more rows from a Grist table by row ID.

• Action
  Delete Workspace

  Deletes a Grist workspace along with every document inside it.

• Action
  Find Record

  Searches a Grist table for a row whose column holds a given value and returns that row's ID and column values.

• Action
  Get Document

  Returns the details of one Grist document — its name, web address, workspace, and organization.

• Action
  Get Org

  Returns the details of one Grist organization (team site) — its name, subdomain, owner, and your access level.

• Action
  Get Workspace

  Returns the details of one Grist workspace, including the documents it contains.

• Action
  List Columns

  Returns the columns of a Grist table, with each column's ID, label, and type.

• Action
  List Orgs

  Returns every Grist organization (team site) this connection can reach.

• Action
  List Tables

  Returns the tables in a Grist document.

• Action
  List Workspaces

  Returns the workspaces in a Grist organization, each with the documents it contains.

• Action
  Run SQL Query

  Runs a read-only SELECT statement against a Grist document and returns the rows.

• Action
  Update Document

  Renames a Grist document or changes whether it is pinned. Anything left blank stays as it is.

• Action
  Update Record

  Changes the column values of one row in a Grist table. Columns left blank keep their current values.

• Action
  Update Workspace

  Renames a Grist workspace.

• Trigger
  New dataset

  Fires when a new dataset is published on the Queensland Government open data portal.

• Action
  Find datasets by criteria

  Search datasets on the portal by keyword, tag, organization, or other facets.

• Action
  Find resources by criteria

  Search across all data resources by field/value criteria.

• Action
  Get dataset

  Retrieve the full metadata and resource list for a single dataset by its id or name.

• Action
  Get group

  Returns one thematic group of the Queensland open data catalogue by its short name, with its title, description and dataset count. The portal blocks its own group endpoint, so the group is read from a dataset search instead; a group with no datasets is reported as not found.

• Action
  Get organization

  Returns one publishing organisation of the Queensland open data catalogue by its short name, with its title, description and dataset count. The portal blocks its own organisation endpoint, so the organisation is read from a dataset search instead; an organisation with no datasets is reported as not found.

• Action
  Get resource

  Returns one published file or service of the Queensland open data catalogue by its file id, including its download link, format and size.

• Action
  List datasets

  Returns the short name of each dataset on the Queensland Government open data portal, up to 1000 per call.

• Action
  List groups

  Returns every thematic group datasets are filed under on the Queensland open data portal, with a dataset count for each. The portal blocks its own group-list endpoint, so the groups are read from the dataset search's grouped counts.

• Action
  List organizations

  Returns every publishing organisation on the Queensland open data portal, with a dataset count for each. The portal blocks its own organisation-list endpoint, so the organisations are read from the dataset search's grouped counts.

• Action
  List tags

  Returns the tags used to label datasets on the Queensland open data portal, optionally narrowed to tags containing given text or belonging to one vocabulary.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.