Connect QuickBase to Brex

Both apps 50QuickBase 23Brex 27

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

• Action
  Create Department

  Creates a new department in your Brex account and returns its ID, name and description.

• Action
  Create Location

  Creates a new location in your Brex account and returns its ID, name and description.

• Action
  Create User

  Creates a new Brex employee user without sending an invitation, leaving the user inactive until they are invited later. Returns the id of the new user.

• Action
  Create Vendor

  Creates a new vendor in Brex, with optional contact details and payment accounts, and returns the created vendor.

• Action
  Disable User

  Disables (suspends) an active Brex user and returns the updated user. Optionally changes the user's manager, department, location, title, cost center, legal entity or metadata at the same time.

• Action
  Email Card Details

  Sends a secure email containing a card's number, CVV, and expiration date to the recipient you specify.

• Action
  Find a Card by ID

  Returns a single Brex card by its ID, including its owner, status, type, spend controls, addresses and expiration date.

• Action
  Find a User

  Returns the Brex users that match a name, email address or identity-provider ID, optionally narrowed by status, manager, department, location, title, cost center, legal entity or custom field value.

• Action
  Find Department by Name

  Returns the Brex departments that match the specified department name.

• Action
  Find Location by Name

  Returns the Brex locations that match the specified name.

• Action
  Find User by Email

  Returns the Brex user whose email address exactly matches the one you specify, or reports that no user was found.

• Action
  Find Vendor by Name

  Returns the vendors whose name matches the name you supply.

• Action
  Get Card Number

  Returns the full card number, CVV, expiration date and cardholder name for a Brex card.

• Action
  Get Card Transactions

  Returns settled card transactions across all of the company's Brex card accounts, optionally narrowed by user or posted date.

• Action
  Get Cash Transactions

  Returns the transactions for a Brex cash account, optionally only those posted on or after a given date.

• Action
  List cards

  Returns the company's Brex cards, optionally only those belonging to one user.

• Action
  List Cash Accounts

  Returns all of the company's Brex cash accounts with their status, balances, account and routing numbers, and which one is primary.

• Action
  List departments

  Returns the departments in your Brex account, optionally filtered by name.

• Action
  List Expenses

  Returns the expenses on the Brex account, optionally narrowed by user, budget, type, status or date range. Admins and bookkeepers see every expense; other users see only their own.

• Action
  List locations

  Returns the locations in your Brex account, optionally filtered by name.

• Action
  List users

  Returns the users in your Brex account, optionally narrowed by name, email, status, manager, department, location, title, cost center, legal entity or custom field value.

• Action
  List vendors

  Returns the vendors in the Brex account, optionally only those matching a vendor name.

• Action
  Terminate card

  Permanently terminates a Brex card and returns the updated card. The card owner is notified.

• Action
  Update a Budget - “Brex Empower” Customers Only

  Updates an existing Brex budget's name, description, parent, owners, period, amount or dates. Available to Brex Empower customers only.

• Action
  Update card

  Updates an existing Brex vendor card's spend controls and metadata, and returns the updated card.

• Action
  Update User

  Updates a Brex user's status, manager, department, location, title, cost center, legal entity or metadata. Anything left blank is unchanged.

• Action
  Update Vendor by Name

  Finds a Brex vendor by its company name and updates that vendor's name, email, phone, beneficiary name or payment accounts.

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