Connect Halo Service Solutions and SeaTable

Both apps 31Halo Service Solutions 16SeaTable 15

• Trigger
  New Ticket

  Triggers when a new ticket is logged in Halo.

• Trigger
  Ticket Updated

  Triggers when a ticket is created or updated in Halo.

• Action
  Add action to ticket

  Adds a new action (note, update or outcome) to an existing Halo ticket.

• Action
  Add project

  Creates a new project in Halo and returns the created project record.

• Action
  Create Site

  Creates a new site for a customer in Halo.

• Action
  Create Ticket

  Creates a new ticket in Halo with a summary, description and optional customer, user, type, priority, status and assignment.

• Action
  Create User

  Creates a new end user in Halo under the chosen site.

• Action
  Get customer

  Returns a single Halo customer (client) by its ID, optionally with extra details and ticket activity.

• Action
  Get project

  Returns a single Halo project by its ID, including its details and custom fields.

• Action
  Get ticket

  Returns a single Halo ticket by its ID, optionally with extra details and its last action.

• Action
  Get user

  Returns a single Halo user (end-user contact) by ID, with optional details, ticket activity and pop-ups.

• Action
  List customers

  Returns a list of customers (clients) in Halo, optionally filtered by search text or top level.

• Action
  List tickets

  Returns tickets from Halo, optionally filtered by customer, agent, status, dates, search text and more.

• Action
  List users

  Returns the users (end-user contacts) in Halo, optionally filtered by customer, site, search text and other criteria.

• Action
  Update ticket

  Updates an existing Halo ticket's summary, details, customer, assignment, status, priority and category. Fields left blank are not changed.

• Action
  Update user

  Updates an existing Halo user's name, site, email or phone number. Fields left blank keep their current values.

• Trigger
  New or Updated Row

  Triggers when a row is added to or changed in a SeaTable table.

• Trigger
  New Row

  Triggers when a new row is added to a SeaTable table.

• Action
  Add column

  Adds a new column to a SeaTable table, optionally after a given column, and returns the created column.

• Action
  Add row link

  Links rows in one table to rows in another table through a link column in a SeaTable base.

• Action
  Add table

  Creates a new table, with the columns you specify, in a SeaTable base.

• Action
  Create Row

  Adds a new row to a table in a SeaTable base.

• Action
  Delete Row

  Deletes a row from a table in a SeaTable base.

• Action
  Find Many Rows (With Line Item Support)

  Finds every row (up to 1,000) in a SeaTable table whose column equals a value.

• Action
  Find Row

  Finds the first row in a SeaTable table whose column equals a value.

• Action
  Get base metadata

  Returns the structure of a SeaTable base: its tables, columns, views and settings (no row data).

• Action
  Get row

  Returns one row of a SeaTable table with all its column values, by row ID.

• Action
  Lock Row

  Locks a row in a SeaTable table so it cannot be edited.

• Action
  Run SQL query

  Runs a SQL statement (SELECT, UPDATE, DELETE, or INSERT) against a SeaTable base and returns the resulting rows and column metadata.

• Action
  Unlock Row

  Unlocks a locked row in a SeaTable table so it can be edited again.

• Action
  Update Row

  Updates the column values of an existing row in a SeaTable table.

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