Connect Pleo and QuickBase

Both apps 49Pleo 26QuickBase 23

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

  Polling trigger. Fires for each record added or modified in the specified Quickbase table, ordered by Date Modified. Records are deduped by their Record ID# (field 3).

• Trigger
  New record

  Polling trigger. Fires for each new record added to the specified Quickbase table, ordered by Record ID#. Records are deduped by their Record ID# (field 3).

• Action
  Add app

  Creates a new Quickbase application in the connected realm, optionally with a description, app variables and security properties.

• Action
  Add field

  Creates a new field in a Quickbase table, optionally with display settings, type-specific properties and per-role permissions.

• Action
  Add table

  Create a new table in a QuickBase app.

• Action
  Delete app

  Delete a QuickBase app by id.

• Action
  Delete field

  Delete one or more QuickBase fields from a table.

• Action
  Delete records

  Delete records from a Quickbase table that match a query (Quickbase query language in the where clause).

• Action
  Delete table

  Deletes a table from a Quickbase app, including all of the data within it.

• Action
  Get app

  Get the properties of a Quickbase application by its app ID.

• Action
  Get field

  Get a single QuickBase field by id.

• Action
  Get report

  Get metadata for a single QuickBase report.

• Action
  Get table

  Get the properties of a single Quickbase table by table ID and app ID.

• Action
  Get table fields

  List all fields (columns) for a Quickbase table, including field IDs, labels, and types.

• Action
  Get tables for app

  List all tables belonging to a Quickbase application.

• Action
  Insert or update records

  Insert new records or update existing ones in a Quickbase table. Pass data as an array of record objects keyed by field ID. Include the table's key field (or record ID field 3) to update; omit to insert.

• Action
  List reports

  Lists all reports defined on a Quickbase table.

• Action
  Query records

  Query records from a Quickbase table. Optionally pass select (array of field IDs), where (Quickbase query language), sortBy, groupBy, and options (skip/top).

• Action
  Run formula

  Runs a Quickbase formula against a table (and optionally a record) and returns the result as text.

• Action
  Run report

  Run a Quickbase report by report ID and table ID and return its result rows.

• Action
  Update app

  Updates an app's name, description, app variables and/or security properties. Properties left blank stay unchanged.

• Action
  Update field

  Updates the properties and per-role permissions of an existing field in a Quickbase table. Properties left blank stay unchanged.

• Action
  Update table

  Update an existing QuickBase table's properties.

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