Connect JOIN and Oracle Database

Both apps 31JOIN 19Oracle Database 12

• Trigger
  Application Created

  Triggers when a new job application is received in JOIN.

• Trigger
  Job Published

  Triggers when a job is published (goes online) in JOIN.

• Trigger
  Job Unpublished

  Triggers when a job is taken offline or archived in JOIN.

• Action
  Add candidate note

  Adds a note to a candidate in JOIN.

• Action
  Add job

  Creates a job in JOIN. New jobs are activated and multiposted to job boards automatically.

• Action
  Add location

  Creates a new office location in JOIN that job ads can be assigned to.

• Action
  Create Application

  Creates an application for a candidate on a JOIN job, optionally attaching documents such as a CV.

• Action
  Get application

  Returns one job application, including its candidate, job, attachments, screening answers and pipeline stage.

• Action
  Get candidate

  Returns a single JOIN candidate by id, including contact details, tags, consent status and their applications, with notes optionally embedded.

• Action
  Get job

  Returns a single JOIN job by its ID, including its title, status, office and optionally its full content.

• Action
  Get Jobs

  Returns jobs in your JOIN account, optionally filtered by status, title, country, external id, or creation/update dates.

• Action
  Get Online Jobs

  Returns the jobs currently published (online) in your JOIN account, optionally filtered by title, country, dates or external id.

• Action
  List applications

  Returns the applications in your JOIN account, optionally filtered by job, dates, country, hiring state or pipeline stage.

• Action
  List candidate notes

  Returns all notes recorded on a candidate in JOIN, including replies.

• Action
  List candidates

  Returns the candidates in your JOIN company, optionally filtered by a name/email search or creation date.

• Action
  List candidate scorecards

  Returns the scorecards submitted for a candidate's job application, including each interviewer's overall recommendation, attribute ratings and question answers.

• Action
  List locations

  Returns the office locations in your JOIN account, optionally filtered by country or city.

• Action
  Update job

  Updates an existing job's details, such as title, description, office, salary, and application requirements. Fields you leave blank stay unchanged.

• Action
  Update Job Status

  Changes a JOIN job's status to online, offline or archived, and returns the job's ID.

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

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