Connect Pleo and SQL Server

Both apps 37Pleo 26SQL Server 11

• Trigger
  New Employee

  Triggered when a new employee is added in Pleo.

• Trigger
  New Tag

  Triggers when a new tag is added to the selected tag group.

• Action
  Add account

  Creates an account in a Pleo company's chart of accounts, matching a record in your accounting system, and returns the new account.

• Action
  Add tag group

  Creates a new tag group (a cost-centre dimension such as Projects or Departments) in Pleo.

• Action
  Add tax code

  Creates a tax code in a Pleo company, with its name, rate and type.

• Action
  Add team

  Creates a new team in a Pleo company or organisation and returns the created team.

• Action
  Create Tag

  Creates a new tag in a Pleo tag group, such as a cost centre or project, and returns the created tag.

• Action
  Delete tag

  Deletes a tag from Pleo by its ID.

• Action
  Delete tag group

  Deletes a tag group from Pleo by its ID.

• Action
  Delete tax code

  Deletes a tax code from a Pleo company.

• Action
  Get an Employee

  Returns one Pleo employee by ID, including their name, email, job title, phone, role, company and avatar.

• Action
  Get company balance

  Returns the current balance of every Pleo account belonging to a company, including available funds, pending debits and overdraft.

• Action
  Get Expense

  Returns a single Pleo expense (accounting entry) by its ID, including its amounts, merchant, category, tags, review and export status, and receipt IDs.

• Action
  Get tag

  Returns a Pleo tag by its ID, including its name, code, tag group and archived status.

• Action
  Get tag group

  Returns a tag group by its ID, including its name, code, archived status, metadata and total number of tags.

• Action
  Get Tax Code

  Returns a single tax code from Pleo, including its name, rate, type and archived status.

• Action
  Get team

  Returns a Pleo team by its ID, including its name, code, company, organisation and employee IDs. An error occurs if the team is not found.

• Action
  List accounts

  Returns the accounts in a Pleo company's chart of accounts, optionally narrowed by name, code, external ID, account ID or archived status.

• Action
  List employees

  Returns the employees in your Pleo company, optionally filtered by company, email or external ID.

• Action
  List tag groups

  Returns the tag groups for a Pleo company, or for all companies in an organisation.

• Action
  List tags

  Returns the tags in a Pleo tag group, optionally including archived tags.

• Action
  List tax codes

  Returns the tax codes for a Pleo company, optionally filtered by code, type, archived status or specific tax code IDs.

• Action
  List teams

  Returns the teams in a Pleo company or organisation, optionally filtered by name, member employee or team.

• Action
  Update tag

  Updates a tag's code, name, archived state and additional dimension values in Pleo, and returns the updated tag.

• Action
  Update tag group

  Updates a tag group's name, code, archived status and metadata. All values replace the tag group's current ones.

• Action
  Update tax code

  Updates an existing tax code in Pleo, including its name, rate, type and archived status, and returns the updated tax code.

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

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