Connect Oracle Database to Onfleet

Both apps 40Oracle Database 12Onfleet 28

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

• 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 Oracle database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle 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 Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

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

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle 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.

• Action
  Add hub

  Create a new hub location.

• Action
  Add team

  Creates a new team in the Onfleet organization.

• Action
  Clone Task

  Clone an existing task by ID.

• Action
  Create Destination

  Create a destination (address).

• Action
  Create Recipient

  Create a recipient.

• Action
  Create Task

  Create a delivery/pickup task in Onfleet.

• Action
  Create Worker

  Create a worker (driver).

• Action
  Delete Task

  Delete a task by ID.

• Action
  Delete team

  Deletes a team from the Onfleet organization.

• Action
  Delete worker

  Deletes a worker from the Onfleet organization. Workers with an active task cannot be deleted until the task has been completed.

• Action
  Find Recipient by Name

  Find a recipient by name.

• Action
  Find Recipient by Phone

  Find a recipient by phone number.

• Action
  Get Destination

  Retrieve a destination by ID.

• Action
  Get Organization

  Retrieve details of your own Onfleet organization.

• Action
  Get Recipient

  Retrieve a recipient by ID.

• Action
  Get Task

  Retrieve a single task by its Onfleet ID.

• Action
  Get Task by Short ID

  Retrieve a single task by its shortId.

• Action
  Get Team

  Retrieve a single team by ID.

• Action
  Get Worker

  Retrieve a single worker by ID.

• Action
  List Hubs

  List all hubs in the organization.

• Action
  List Tasks

  List tasks in a time range. from is required (ms epoch); optional to and state filters.

• Action
  List Teams

  List all teams in the organization.

• Action
  List Workers

  List all workers (drivers) in the organization.

• Action
  Update hub

  Update an existing hub's name or address.

• Action
  Update Recipient

  Update a recipient by ID.

• Action
  Update Task

  Update an existing task by ID.

• Action
  Update team

  Update an existing team's name, workers or hub.

• Action
  Update worker

  Updates an existing Onfleet worker (driver): name, teams, display name, capacity, vehicle, routing address and metadata. A worker's phone number cannot be changed through the API.

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