Connect PostgreSQL to Ashby

Both apps 27PostgreSQL 10Ashby 17

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

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected PostgreSQL database.

• Action
  Add Row

  Adds a new row.

• Action
  Delete Row

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

• Action
  Find Row

  Finds a row in a table via a lookup column.

• Action
  Find Rows via Custom Query

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

• Action
  Find Row via Custom Query

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

• Action
  Update Row

  Updates an existing row.

• Action
  Add candidate tag

  Adds an existing tag to a candidate in Ashby and returns the updated candidate.

• Action
  Add job

  Creates a new job in Ashby with a title, department/team and location, optionally applying a job template, interview plan, employment type and brand.

• Action
  Add offer

  Creates an offer for a candidate's application in Ashby by submitting the offer form for an offer process that has already been started.

• Action
  Change Job Consideration Stage

  Moves a candidate's application (their consideration for a job) to a different interview stage, optionally with an archive reason and rejection email when archiving.

• Action
  Consider Candidate for Job

  Considers a candidate for a job in Ashby by creating a new application, optionally placing it in a specific interview plan and stage with a source and credited user.

• Action
  Create Candidate

  Creates a new candidate in Ashby with their name, contact details, social profiles, location and source.

• Action
  Create Candidate Note

  Adds a note to a candidate's profile in Ashby, optionally as HTML, private, or with notifications to subscribed users.

• Action
  Find Candidate

  Returns up to 100 candidates whose email address and/or name match the values you supply.

• Action
  Find Job

  Returns up to 100 jobs whose title or requisition ID matches the text you search for.

• Action
  Find Job Consideration

  Returns the applications (candidates being considered) for a job in Ashby, optionally narrowed by application status and creation date.

• Action
  Find Opening

  Returns the openings whose identifier matches the one you supply, including each opening's state, jobs, locations, hiring team and custom fields.

• Action
  Get candidate

  Returns the full details of a single Ashby candidate, including contact info, tags, applications, files and custom field values.

• Action
  List departments

  Returns all departments and teams in your Ashby account, optionally including archived ones or only those changed since a previous sync.

• Action
  List locations

  Returns the office and remote locations set up in your Ashby account, optionally including archived locations and regions.

• Action
  Update Candidate

  Updates an existing candidate's name, contact details, social links, source, credited user and location in Ashby. Fields left blank are not changed.

• Action
  Update job

  Updates an existing job in Ashby — its title, team, location, default interview plan, employment type or requisition id.

• Action
  Update Opening

  Updates an existing opening in Ashby, such as its identifier, description, department, target dates, backfill flag or employment type. Returns the updated opening.

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