Colombia Company Data — RUES Registry 🇨🇴

🎉 Turn the Colombian RUES registry into clean, structured company data — no login, no API key, one row per entity, with the NIT, legal form, chamber of commerce, CIIU code and registration status. Built for B2B sales, lead generation, KYB / compliance and market-research teams.

🔍 What is the Colombia Company Data — and when should you use it?

Give this actor company names or Colombian NITs and it returns matching companies from the Colombian Unified Business and Social Registry (RUES, datos.gov.co open data) — as clean, deduplicated rows you can filter, export or feed to an AI agent. Every run queries the source live, so the data is as fresh as the registry itself.

Use it when you need: a Colombia company list for outreach; formation / status monitoring; or a canonical registry record for KYB and due diligence.

Use something else when: you need firmographics the registry doesn’t hold (revenue, headcount, website, email) — pair this with an enrichment actor from Fox Labs.

🤖 Use with AI agents

Already on the Apify MCP server? Ask for this Actor by name: foxlabs/colombia-company-data.

Your agent can pay for its own runs. This Actor is pay-per-event with agentic payments, so an agent can discover it, run it and settle the bill over x402 (USDC on Base) or Skyfire — no Apify account or API token of its own. Billing is the same either way: per delivered record, never for errors.

Otherwise paste this into Claude, ChatGPT, Cursor or any MCP-enabled assistant:

I want to pull Colombia company records using the Apify Actor `foxlabs/colombia-company-data`.
Input: `queries` is a list of company names or Colombian NITs. `maxResultsPerQuery` caps rows per query.
Start with: {"queries":["830095213","Rappi"],"maxResultsPerQuery":50}
Ask me what to look up, run the Actor, then summarise the rows as a table.

The machine-readable API, MCP config and OpenAPI definition live at apify.com/foxlabs/colombia-company-data.md.

📋 Overview

Everything you need to turn the Colombian Unified Business and Social Registry (RUES, datos.gov.co open data) into clean, structured data — in one actor, with no login, cookies or API key.

Why teams pick this actor:

• ✅ Whole registry, one call — name or ID in, matching companies out.
• 🧹 No empty-promise columns — only fields this registry actually fills; degenerate columns are removed.
• 🔗 Stable join key — registrationNumber ties rows across runs and to other Fox Labs actors.
• 💰 Pay only for results — per-row pricing, empty/failed lookups never billed.
• 🤖 Agent-ready — MCP + x402 agentic payments.

✨ Features

• 🔍 Name or ID lookup — relevance-ranked name search or exact registry-ID lookup.
• 🏢 Full entity profile — status, legal form, formation date, address and the registry’s own contact fields.
• 🧹 Clean schema — deduplicated camelCase rows, ready for CSV/Excel/JSON.

🎬 Quick Start

curl -X POST "https://api.apify.com/v2/acts/foxlabs~colombia-company-data/runs?token=YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"queries":["830095213","Rappi"],"maxResultsPerQuery":50}'

🚀 Getting Started (3 steps)

1. Choose your targets — company names or Colombian NITs.
2. Set the cap — maxResultsPerQuery limits rows per query.
3. Run and export — get a clean dataset as JSON, CSV or Excel.

📥 Input

{"queries":["830095213","Rappi"],"maxResultsPerQuery":50}

Field	Type	Description
queries	array	Company names or Colombian NITs.
maxResultsPerQuery	integer	Caps rows per query.
maxConcurrency	integer	How many queries to fetch at once.
includeRaw	boolean	Attach the source’s untouched record under raw.

📤 Output

One row per company, saved to the dataset. Every row also carries query, scrapedAt, and — when a lookup fails — an error explaining why (never silently dropped, never billed).

Field	Description
country	Country
registry	Registry
companyName	Company / entity name
registrationNumber	Registry ID — the join key
taxNumber	Tax identifier
status	active / inactive / dissolved
statusRaw	Status exactly as the registry words it
legalForm	Legal form / entity type
incorporatedOn	Formation / registration date (ISO)
dissolvedOn	Dissolution date where applicable (ISO)
countryName	Country
industryCode	Primary industry code (NACE)
sourceUrl	Public registry URL for the record
identificationType	Identification Type
chamberOfCommerce	Chamber Of Commerce
chamberCode	Chamber Code
registrationCategory	Registration Category
lastRenewalYear	Last Renewal Year
validUntil	Valid Until

💼 Use cases

1. Colombia B2B lead lists — registered Colombian entities by name. Input: name searches. Output: entities + chamber + CIIU. Use: a ready list.

2. Renewal / status monitoring — track registration status and renewal year. Input: name searches on a schedule. Output: status + renewal + validity. Use: flag lapsed registrations.

3. KYB / due diligence — verify a Colombian entity by NIT. Input: the NIT or name. Output: the canonical RUES record. Use: confirm existence and standing.

🔗 Integration

JavaScript / Node.js

import { ApifyClient } from 'apify-client';
const client = new ApifyClient({ token: 'YOUR_TOKEN' });
const run = await client.actor('foxlabs/colombia-company-data').call({"queries":["830095213","Rappi"],"maxResultsPerQuery":50});
const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(items[0]);

Python

from apify_client import ApifyClient
client = ApifyClient('YOUR_TOKEN')
run = client.actor('foxlabs/colombia-company-data').call(run_input={"queries":["830095213","Rappi"],"maxResultsPerQuery":50})
for item in client.dataset(run['defaultDatasetId']).iterate_items():
    print(item)

Automation (n8n / Zapier / Make): schedule or webhook → HTTP request to the actor API with your queries → handle the JSON dataset → push to a sheet, CRM or dashboard.

📊 Pricing

Pay-per-event: per delivered record. Empty or failed lookups are never billed. View current pricing.

❓ FAQ

Do I need an account, login or API key? No. This reads the Colombian Unified Business and Social Registry (RUES, datos.gov.co open data).

What do I search by? Company names or Colombian NITs.

How current is the data? Every run queries the source live, so results are as fresh as the registry.

Why are firmographics like revenue or website missing? A public business registry doesn’t hold them; we don’t ship empty columns. Pair with an enrichment actor from Fox Labs.

Can I export to CSV / Excel / JSON? Yes — directly from the Apify dataset.

🐛 Troubleshooting

• Fewer rows than expected — raise maxResultsPerQuery, or refine the name.
• A name returns an unexpected entity — it matched a similar registered name; search the exact registry ID.
• No rows for a name — try the entity’s exact legal name or its registry ID.

⚖️ Is it legal to scrape this data?

This actor reads a public government business registry published as open data. Results can still contain personal data (e.g. a registered agent’s name); personal data is protected by the GDPR and similar laws, so only process it with a legitimate basis. See Apify’s blog post on the legality of web scraping.

🤝 Support & contact

• 🌐 Website: data.foxlabs.com.tr
• 📧 Email: info@foxlabs.com.tr
• 🐛 Issues: open a ticket in the Actor’s Issues tab
• 🧰 More clean B2B data actors: Fox Labs on Apify

Changelog

0.1 — 2026-09-07

• Dropped empty-promise columns. Removed address, city, postalCode, industry, employees, capital, website, email, phone, officers, lastUpdatedInRegister — Colombian Unified Business and Social Registry (RUES, datos.gov.co open data) does not carry them, so they were shipped as always-null columns. Only fields this registry actually fills are now emitted.
• README rebuilt to the full standard (What-is / when, AI-agents + x402 agentic payments + MCP, Overview, Features, Use cases, Integration, FAQ, Troubleshooting, Support & contact).

0.1.0

• Initial release: company lookup from the Colombian Unified Business and Social Registry (RUES, datos.gov.co open data) by name or registry ID.