Postgres and Short.io integration
How to connect Postgres and Short.io
Create a new workflow and add the first step
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.
Build your own Postgres and Short.io integration
Create custom Postgres and Short.io 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.
Supported API Endpoints for Short.io
Create link
This endpoint allows you to create a new short link.
List links
Retrieve a list of links.
Create short link
Create a new short link.
Archive URL
Archive an existing URL.
Update existing URL
Update an existing short link.
Delete URL
Delete a short link by its ID.
Generate QR code for short link
Generate a QR code for a specified link.
Get Open Graph data
Retrieve Open Graph data for a given link.
Update Open Graph data
Update Open Graph data for a specified link.
List links
Returns list of links
List links
Retrieve a list of links.
Delete URL
Delete a specified URL.
Create short link
Create a new short link.
Update existing URL
Update an existing URL.
Get link info
Retrieve detailed information about a specific link.
Expand link by long URL
Expand a link to its original long URL.
Create URL with public key
Create a URL using a public key for authorization.
Bulk create URLs
Create multiple URLs in a single request.
Delete URL
Deletes a short link by its ID
List domains
Retrieve a list of domains.
Create domain
Create a new domain entry.
Create domain
Create a new domain.
List domains
Retrieve a list of domains.
Clear statistics of domain
Clear statistics for a specified domain.
Create a domain
Creates a new domain
List Country Rules
Retrieve a list of country rules.
Create Country Rule
Create a new country rule.
Delete Country Rule
Delete a specified country rule.
List Region Rules
Retrieve a list of region rules.
Create Region Rule
Create a new region rule.
Get link statistics
Retrieves statistics for a specified link
Create link statistics
Creates statistics for a specified link
Get Open Graph data for link
Retrieve Open Graph data for a given link.
Update Open Graph data
Update Open Graph data for a given link.
Link statistics
Retrieve statistics data for a given link.
Link statistic
Update the statistics data for a given link.
Link statistics data by interval
Gets link statistics data for a specific interval.
Top column values for specified link path
Gets the top column values for a specified link path.
Clear statistics of specified domain
Clears statistics for a specified domain
Domain statistics data by interval
Retrieves domain statistics data for a specified interval
Create domain statistics
Creates statistics for a specific domain.
Get link clicks
Retrieves the clicks for links associated with a domain.
Create link clicks
Records clicks for links associated with a domain.
Get most popular links
Retrieves the most popular links within a time interval for a domain.
List of raw clicks
Retrieves a raw list of clicks on a domain.
Top values of specified column
Retrieves the top values for a specified column ordered by clicks.
Top values by interval
Retrieves top values of a specified column within a particular interval.
Create Region Rule
Create a new region rule.
List Region Rules
Retrieve a list of region rules.
Create Country Rule
Create a new country rule.
List Country Rules
Retrieve a list of country rules.
Update Open Graph data for a given link
Updates Open Graph data for a specific link.
Domain statistics
Retrieve statistics for a specific domain.
To set up Short.io 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 Short.io 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 Short.io official documentation to get a full list of all API endpoints and verify the scraped ones!
Postgres and Short.io integration details
Other integrations with Postgres
Postgres and Short.io integration tutorials
How to export data from PostgreSQL to CSV
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.
How to import CSV into PostgreSQL
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.
Database activity monitoring: How to automatically monitor and set alerts for a database
Learn what database activity monitoring is, why it's important, and how to automatically monitor a Postgres database containing IoT data with n8n workflows.
Automate your data processing pipeline in 9 steps
Learn how to build an n8n workflow that processes text, stores data in two databases, and sends messages to Slack.
FAQ
Can Postgres connect with Short.io?
Can I use Postgres’s API with n8n?
Can I use Short.io’s API with n8n?
Is n8n secure for integrating Postgres and Short.io?
How to get started with Postgres and Short.io integration in n8n.io?
Need help setting up your Postgres and Short.io integration?
Discover our latest community's recommendations and join the discussions about Postgres and Short.io integration.
Postgres node IN operator with parameters
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
Passing an array as query parameter in Postgresql
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
Self-Hosted n8n 1.59.3 does not have Postgres PGVector Store and Postgres Chat Memory nodes
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
Node does not return "enough items"
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
Sudden Spike in Database Request
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 Postgres and Short.io in your company?
The world's most popular workflow automation platform for technical teams including
Why use n8n to integrate Postgres with Short.io
Build complex workflows, really fast
