Do everything in one place
Customize your Brex and JDBC integration with the following
triggers and actions.
Triggers
When this happens…
JDBC
- New rowNew row in a table in JDBC source
- New rows BatchNew batch of rows in a table in JDBC source
- New rows via custom SQL BatchNew batch of rows via custom SQL in JDBC source
- Scheduled query BatchScheduled query using custom SQL in JDBC source
- New/updated rows via custom SQL BatchNew/updated batch of rows via custom SQL in JDBC source
Any other trigger you can think up
Actions
Do this…
Brex
- List users in BrexThis endpoint lists all users.
- Invite user to BrexThis endpoint invites a new user as an employee.
- Get current user in BrexThis endpoint returns the user associated with the OAuth2 access token.
- Get user in BrexThis endpoint returns a user by ID.
- Update user in BrexThis endpoint updates a user. Any parameters not provided will be left unchanged.
- Get limit for the user in BrexThis endpoint gets the monthly limit for the user including the monthly available limit.
- Set limit for the user in BrexThis endpoint sets the monthly limit for a user. The limit amount must be non-negative.
- List locations in BrexThis endpoint lists all locations.
- Create location in BrexThis endpoint creates a new location.
- Get location in BrexThis endpoint gets a location by ID.
- List departments in BrexThis endpoint lists all departments.
- Create department in BrexThis endpoint creates a new department.
- Get department in BrexThis endpoint gets a department by ID.
- Lists all cards by a user_id in BrexLists all cards by a user_id. Only cards with limit_type = CARD have spend_controls.
- Create card in BrexThis endpoint creates a new card.
- Get card in BrexThis endpoint retrieves a card by ID.
- Update card in BrexThis endpoint updates an existing vendor card.
- Lock card in BrexThis endpoint locks an existing card.
- Get card number in BrexThis endpoint retrieves card number, CVV, and expiration date of a card by ID.
- Terminate card in BrexThis endpoint terminates an existing card.
- Unlock card in BrexThis endpoint unlocks an existing card.
- Get company in BrexThis endpoint returns the company associated with the OAuth2 access token.
- Lists vendors in BrexThis endpoint lists all existing vendors for an account. Takes an optional parameter to match by vendor name.
- Create vendor in BrexThis endpoint creates a new vendor.
- Get vendor in BrexThis endpoint retrieves a vendor by ID.
- Update vendor in BrexThis endpoint updates an existing vendor.
- Delete vendor in BrexThis endpoint deletes an existing vendor.
- Lists transfers in BrexThis endpoint lists existing transfers for an account Currently, the API can only return transfers for the following payment rails: ACH, DOMESTIC_WIRE, CHEQUE, INTERNATIONAL_WIRE
- Create transfer in BrexThis endpoint creates a new transfer.
- Get transfer in BrexThis endpoint retrieves a transfer by ID.
- List transactions for the primary card account in BrexThis endpoint lists all settled transactions for the primary card account.
- List transactions for the selected cash account in BrexThis endpoint lists all transactions for the cash account with the selected ID.
- List card accounts in BrexThis endpoint lists all accounts of card type
- List primary card account statements in BrexThis endpoint lists all finalized statements for the primary card account.
- List cash accounts in BrexThis endpoint lists all the existing cash accounts with their status.
- List cash account statements in BrexThis endpoint lists all finalized statements for the cash account by ID.
- List referrals in BrexThis endpoint lists unexpired referrals.
- Create a referral in BrexThis endpoint creates a referral.
- Get referral by ID in BrexThis endpoint gets a referral by ID.
- Create a new document upload in BrexThis endpoint creates a referral.
Any other action you can think up
JDBC
- Export query resultExport query result as a CSV file in JDBC source
- Run custom SQL BatchRun custom SQL in JDBC source
- Run long query using custom SQLRun long query using custom SQL in JDBC source
- Select rows BatchSelect rows in a table in JDBC source
- Select rows using custom SQL BatchSelect rows using custom SQL in JDBC source
Any other action you can think up
The wonders of Workato
Easily set up as many intelligent automations you need.
- 1000s of ready-to-use templates
- Accelerate work with intelligent automation
- Do it yourself, faster
- Build bots. Put them to work