Connect ServiceM8 and Snowflake

Both apps 35ServiceM8 25Snowflake 10

• Trigger
  Job Queued

  Triggers when a Job is assigned to a Queue.

• Trigger
  New Job

  Triggers when a new job is created.

• Action
  Add attachment

  Uploads a file and attaches it to a job (or another ServiceM8 record), so it appears in that record's diary.

• Action
  Add company contact

  Creates a new contact person on a ServiceM8 client (company), such as a billing or job contact.

• Action
  Add job allocation

  Allocates a ServiceM8 job to a staff member, optionally with a scheduled date and allocation window.

• Action
  Add job material

  Adds a material line item to a ServiceM8 job, with quantity, pricing and tax details.

• Action
  Add job payment

  Records a payment against a ServiceM8 job, with its amount, method, date and optional note.

• Action
  Add note

  Adds a note to a job, client or other ServiceM8 record.

• Action
  Create Client

  Creates a new client (company) record in ServiceM8.

• Action
  Create Job

  Creates a new job in ServiceM8, optionally linked to a client, category and queue, and returns the new job's UUID.

• Action
  Delete client

  Deletes (archives) a client in ServiceM8.

• Action
  Delete job

  Deletes (archives) a job in ServiceM8. The job is hidden in the app and can be restored later.

• Action
  Get attachment

  Returns the details of a single file attachment (photo, PDF or other file) by its UUID.

• Action
  Get client

  Returns one ServiceM8 client (company) record by its UUID, including its name, address and billing details.

• Action
  Get job

  Returns a single ServiceM8 job by its UUID, including its status, client, address and totals.

• Action
  Get Job Allocation

  Returns a single job allocation — which staff member a job is allocated to, its window, dates and status.

• Action
  List clients

  Returns the clients (companies) in your ServiceM8 account, optionally narrowed by a filter.

• Action
  List job materials

  Returns the materials (line items) recorded on jobs, optionally filtered, for example to a single job.

• Action
  List job payments

  Returns the payments recorded against jobs, optionally filtered (for example to a single job).

• Action
  List Job Queues

  Returns the job queues set up in the ServiceM8 account.

• Action
  List jobs

  Returns the jobs in your ServiceM8 account, optionally narrowed by a filter.

• Action
  List notes

  Returns the notes in your ServiceM8 account, optionally filtered and sorted.

• Action
  List staff members

  Returns the staff members in your ServiceM8 account, optionally narrowed by a filter.

• Action
  Update client

  Updates an existing client (company) in ServiceM8. Only the fields you fill in are changed.

• Action
  Update job

  Updates an existing job in ServiceM8, changing only the fields you fill in.

• Trigger
  New Column

  Triggers when a new column is added to a table in the chosen Snowflake database, optionally limited to one schema or table.

• Trigger
  New or Updated Row

  Triggers when a row is added to or changed in a Snowflake table, checking the most recently updated rows by a timestamp column you choose.

• Trigger
  New Row

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

• Trigger
  New Table

  Triggers when a new table is created in a Snowflake database.

• Trigger
  New View

  Triggers when a new view is created in the selected Snowflake database (optionally limited to one schema).

• Action
  Create Rows

  Inserts one or more rows into a Snowflake table.

• Action
  Delete Rows

  Deletes every row in a Snowflake table whose chosen column equals the value you supply.

• Action
  Execute SQL

  Runs a SQL statement in Snowflake and returns its result rows and column metadata.

• Action
  Find Row

  Finds the first row in a Snowflake table whose chosen column equals a given value and returns its column values.

• Action
  Update Rows

  Updates a column's value on every row in a Snowflake table whose match column equals the given value.

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