Connect Samsara and SQL Server

Both apps 29Samsara 18SQL Server 11

• Trigger
  New Document Submitted

  Triggers when a driver submits a new document in Samsara (documents created in the last 7 days are checked).

• Trigger
  New Route Added

  Triggers when a new route is added in Samsara (routes scheduled from 7 days ago to 30 days ahead are checked).

• Trigger
  New Route Job Completion

  Triggers on each new route stop event in Samsara (arrived, departed/completed, skipped, and other stop updates); the event name is in the operation field, so filter on it for completions.

• Action
  Create Address

  Creates an address in your Samsara organization's address book, with a circular geofence around it.

• Action
  Create Contact

  Creates a contact in your Samsara organization.

• Action
  Create Route

  Creates a route from a start address to an end address (both existing Samsara addresses), optionally assigned to a driver or vehicle.

• Action
  Delete route

  Deletes a dispatch route from your Samsara organization.

• Action
  Get document

  Returns a single driver document, including its type, status, driver, vehicle and submitted field values.

• Action
  Get vehicle

  Returns a single vehicle in your Samsara fleet, including its name, VIN, make, model, tags and external IDs.

• Action
  List addresses

  Returns the addresses (geofenced locations) in your Samsara address book, optionally filtered by tag or creation time.

• Action
  List assets

  Returns the assets (vehicles, trailers, equipment and other tracked assets) in your Samsara organization.

• Action
  List contacts

  Returns the contacts in your Samsara organization.

• Action
  List documents

  Returns driver documents submitted or updated in Samsara within a time range, optionally limited to one document type.

• Action
  List drivers

  Returns the drivers in your Samsara organization, optionally filtered by status, tags or update time.

• Action
  List routes

  Returns the routes scheduled within a time window, including their stops, driver and vehicle.

• Action
  List trailers

  Returns the trailers in your Samsara fleet, optionally filtered by tag.

• Action
  List vehicles

  Returns the vehicles in your Samsara fleet, optionally filtered by tag, attribute or creation/update time.

• Action
  Update route

  Updates an existing Samsara route's name, notes, assigned driver or assigned vehicle.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

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