Connect Oracle Database to Jobber

Both apps 25Oracle Database 12Jobber 13

• 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 note to job

  GraphQL mutation jobCreateNote.

• Action
  Add Note to Request

  Adds a note to a request

• Action
  Add Tags to Client

  Adds one or more tags to an existing Jobber client, keeping the tags it already has.

• Action
  Create Client

  Creates a new client.

• Action
  Create Job

  Creates a new job. This will create the job for the client's first property.

• Action
  Create Quote

  Creates a quote for a client's property in Jobber, with its line items.

• Action
  Create Request

  Creates a new request. This will create the request for the client's first property.

• Action
  Find Client

  Finds the client that aligns most closely with the search criteria.

• Action
  Find invoices

  Returns up to 50 invoices that match the specified search term and filters.

• Action
  Find quotes

  Returns up to 50 Jobber quotes that match the search text and filters.

• Action
  Find requests

  GraphQL query requests.

• Action
  Update client

  Updates an existing Jobber client by ID. Only the fields you fill in are changed.

• Action
  Update job

  Updates an existing job in Jobber: title, instructions, number, schedule, invoicing, salesperson, tax rate, job forms and custom fields. Only the fields you fill in are changed.

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