Connect SQL Server to intelliHR

Both apps 24SQL Server 11intelliHR 13

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

• Action
  Create Business Unit

  Creates a new business unit in intelliHR and returns the created business unit, including its custom field values.

• Action
  Create Training

  Creates a training record for a person in intelliHR, with its provider, type, status, cost, hours and completion date.

• Action
  Create User

  Creates a login user for an existing person who does not already have one, and returns the new user.

• Action
  Find Job

  Finds jobs matching the person, email, employee number, job title, status or other criteria you supply.

• Action
  Find Person

  Finds people in intelliHR matching a name, primary email address, employee number, intelliHR ID or job, and returns the matching people with their details.

• Action
  Get job

  Returns a single job by its ID, including its person, position, location, business unit, remuneration schedule and custom fields.

• Action
  Get person

  Returns a single person record from intelliHR, including contact details, jobs and custom field values.

• Action
  List jobs

  Returns jobs in intelliHR as at the current date, optionally filtered by person, job name, status, work type and more.

• Action
  List people

  Returns the people in your intelliHR account, optionally filtered by job, email, employee number, name, recent updates or extended-leave status.

• Action
  Set Job End Date

  Sets the end date on a job and, unless told not to, finalises the job's termination with a turnover type and reason.

• Action
  Update Business Unit

  Updates an existing business unit's name, code, notes, parent, enabled status and custom field values.

• Action
  Update User

  Updates an existing intelliHR user account — enable or disable sign-in, change the username, set when full access begins, or issue onboarding.

• Action
  Upload Person Document

  Uploads a file to a person's documents in intelliHR and marks the upload as successful. Returns the new document's id, filename and upload status.

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