Español
English
Artículo
Compartir artículo
Pitzui X Pitzui Reddit Pitzui Facebook Pitzui Youtube Pitzui Linkedin
August 5, 2025

Connect to External APIs with Pitzui — Real Example Using CoinGecko

Portada

Connecting your system to external sources through APIs is one of the most effective ways to enrich your data and automate processes. In this article, you'll learn how to use Pitzui's External Connections module to connect to a real, public API: the CoinGecko API, which offers cryptocurrency price information.

What is the External Connections Module?

Pitzui's External Connections module allows you to integrate your system with any REST API. You can connect to third-party services, obtain updated data, and use it directly within your processors to feed tables, reports, or dashboards.

Public API we'll be using: CoinGecko

CoinGecko offers a free, public API with no authentication required to obtain cryptocurrency information.

📘 Endpoint we'll use:

https://api.coingecko.com/api/v3/simple/price?ids=bitcoin,ethereum&vs_currencies=usd

This endpoint returns the current USD price of Bitcoin and Ethereum in JSON format.

📘 Expected response:

{ "bitcoin": { "usd": 29347 }, "ethereum": { "usd": 1847 } }

Step-by-step guide to creating the connection in Pitzui

1. Create a new connection

In the External Connections module, click "New Connection."

Assign a name like: Crypto Prices - CoinGecko.

HTTP Method:

GET: https://api.coingecko.com/api/v3/simple/price

New Connection

2. Add URL Parameters

Click on the URL Parameters tab and add the following key/value pairs:

id: bitcoin, ethereum

vs_currencies: usd

Parameters URL

3. Headers

This API does not require custom headers or authentication, so you can leave these sections empty.

4. Test and view the response

Click Submit to run a test. Pitzui will show you:

  • HTTP status code (200 OK)
  • Response time
  • The body in JSON format
  • Formatted and structured view for easy data exploration

View the response

5. Using the connection in processors

Once you have verified that the API responds correctly, you can use this connection in a Pitzui processor to:

  1. Extract current Bitcoin and Ethereum prices
  2. Transform the JSON into a tabular structure
  3. Insert the data into a table you have previously created (example: CryptocurrencyPrices

You can also schedule the processor to run every hour to keep your data updated automatically.

What can you do with this data?

With just this API, you can:

  • Create an updated cryptocurrency price dashboard
  • Send alerts if the price rises or falls below a certain threshold
  • Cross-reference this information with internal data (for example, if your sales are related to crypto payments)

And this is just the beginning. The same approach can be applied to any other public or private API: weather, exchange rates, economic indicators, ERP systems, or CRMs.

Benefits of integrating external APIs into Pitzui

  • Complete automation of the data import process
  • Consolidation of multiple sources into a single platform
  • Real-time updates of dashboards and indicators
  • Scalability by reusing connections across multiple processors

Conclusion

Pitzui's external connections module allows you to access and integrate public or private APIs in minutes. With this real-world example using CoinGecko, you'll see how to:

  1. Bring in real-time cryptocurrency data
  2. Analyze it
  3. Use it in your reports or internal processes

Ready to try it?

Use this API as a practice run, or connect any other external data source and transform your Pitzui platform into a true automated information hub.

Visit app.pitzui.com, create your first instance. Read article, create your first instance, and discover why Pitzui is the ideal low-code platform for companies seeking efficiency and autonomy without relying on IT.

Compartir artículo