In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Create custom Brex and Postgres workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
List referrals
Returns referrals created, excluding expired ones.
Create referral
This creates new referrals and returns an identifier with a unique application link.
Get referral
Returns a referral object by ID if it exists.
Upload document
Create a new document upload using a presigned S3 URL.
List card accounts
This endpoint lists all accounts of card type.
List primary card account statements
This endpoint lists all finalized statements for the primary card account.
List cash accounts
This endpoint lists all the existing cash accounts with their status.
Get primary cash account
This endpoint returns the primary cash account with its status.
Get cash account by ID
This endpoint returns the cash account associated with the provided ID with its status.
List cash account statements
This endpoint lists all finalized statements for the cash account by ID.
List users
This endpoint lists all users.
Get current user
This endpoint returns the user associated with the OAuth2 access token.
Get user
This endpoint gets a user by ID.
Get limit for the user
This endpoint gets the monthly limit for the user including the monthly available limit.
Set user limit
This endpoint sets a limit for a user.
List locations
This endpoint lists all locations.
Create location
This endpoint creates a new location.
Get location
This endpoint gets a location by ID.
List departments
This endpoint lists all departments.
Create department
This endpoint creates a new department.
Create department
This endpoint creates a new department.
Get department
This endpoint gets a department by ID.
List titles
This endpoint lists all titles.
Get title
This endpoint gets a title by ID.
List cards
Lists all cards by a user_id.
Create card
Creates a new card requiring certain fields based on card type.
Get card
Retrieves a card by ID.
Lock card
Locks an existing, unlocked card.
Get card number
Retrieves card number, CVV, and expiration date of a card by ID.
Create secure email to send card number
Creates a secure email to send card number, CVV, and expiration date of a card by ID to the specified email.
Secure email card
Sends a secure email to a recipient regarding a card.
Terminate card
Terminates an existing card and notifies the card owner.
Unlock card
Unlocks an existing card.
List vendors
This endpoint lists all existing vendors for an account.
Get vendor
This endpoint gets a vendor by ID.
Update vendor
Updates an existing vendor by ID.
Delete vendor
This endpoint deletes a vendor by ID.
Create transfer
This endpoint creates a new transfer.
List transfers
This endpoint lists existing transfers for an account.
Create transfer
This endpoint creates a transfer between accounts.
Get transfer
This endpoint gets a transfer by ID.
List transactions
This endpoint lists all settled transactions for all card accounts.
List transactions
This endpoint lists all transactions for the cash account with the selected ID.
To set up Brex integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Brex to query the data you need using the API endpoint URLs you provide.
These API endpoints were generated using n8n
n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Brex official documentation to get a full list of all API endpoints and verify the scraped ones!
CSV is a universally accepted and easy-to-read format to interpret data, and PostgreSQL is one of the most popular relational databases. Read on to learn how to export PostgreSQL as a CSV file using the COPY command, \copy command, and n8n.
PostgreSQL remains one of the most popular relational database options among data enthusiasts. Read on to learn how to import a CSV file into PostgreSQL using pgAdmin, SQL statements, and n8n.
Learn what database activity monitoring is, why it's important, and how to automatically monitor a Postgres database containing IoT data with n8n workflows.
Learn how to build an n8n workflow that processes text, stores data in two databases, and sends messages to Slack.
Can Brex connect with Postgres?
Can I use Brex’s API with n8n?
Can I use Postgres’s API with n8n?
Is n8n secure for integrating Brex and Postgres?
How to get started with Brex and Postgres integration in n8n.io?
Discover our latest community's recommendations and join the discussions about Brex and Postgres integration.
Mikhail Savenkov
Describe the problem/error/question Postgres node is not working with IN Operator when the parameters is an Array. I suppose that’s because of the sanity checks. E.g. I have a list of some workflows that I’m returning v…
Open topic
Honza Pav
Hello, I have a follow-up question related to a topic that has been discussed but is closed: Postgres use array as a query parameters I want to pass an array into a Postgresql query as a query parameter. Ideally, I woul…
Open topic
Vyacheslav Karbovnichy
Describe the problem/error/question I have set up local n8n (latest stable v1.59.3) and wanted to try the solution from here https://www.youtube.com/watch?v=PEI_ePNNfJQ but when importing that workflow locally I have so…
Open topic
Dennis
Hey everyone, I have the following problem & one question. Problem I have an HTTP request and a split. The split node correctly splits the HTTP into 10 items. But the Postgres only returns 1 item. No matter what, which…
Open topic
Dennis
Hey everyone, I love N8N so far; as a newbie when it comes to databases and development, I am happy for this awesome solution. Situation I am, at best, an intermediate coder. Right now we are building an MVP, before h…
Open topic
Looking to integrate Brex and Postgres in your company?
The world's most popular workflow automation platform for technical teams including
Build complex workflows, really fast