<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Cee Data</title>
    <description>The latest articles on DEV Community by Cee Data (@cee-data).</description>
    <link>https://dev.to/cee-data</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4216321%2Fc1fce0cd-ea33-45f3-8957-18987a655d36.webp</url>
      <title>DEV Community: Cee Data</title>
      <link>https://dev.to/cee-data</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/cee-data"/>
    <language>en</language>
    <item>
      <title>Estonian company financials as JSON: revenue, assets and profit without joining official CSV archives</title>
      <dc:creator>Cee Data</dc:creator>
      <pubDate>Fri, 30 Oct 2026 03:35:29 +0000</pubDate>
      <link>https://dev.to/cee-data/estonian-company-financials-as-json-revenue-assets-and-profit-without-joining-official-csv-9b1</link>
      <guid>https://dev.to/cee-data/estonian-company-financials-as-json-revenue-assets-and-profit-without-joining-official-csv-9b1</guid>
      <description>&lt;h1&gt;
  
  
  Estonian company financials as JSON: revenue, assets and profit without joining official CSV archives
&lt;/h1&gt;

&lt;p&gt;The Estonian e-Business Register publishes excellent open data, including annual-report key indicators. Using it in an application has one practical drawback: the company identity, annual-report metadata and financial indicators live in separate ZIP/CSV archives. Indicator rows use &lt;code&gt;report_id&lt;/code&gt;, not a company registry code, so you need to join the files before getting a simple company-year record.&lt;/p&gt;

&lt;p&gt;I packaged that pipeline as an Apify Actor that returns normalized JSON for one or more Estonian companies:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://apify.com/cee-data/estonia-company-financials-scraper" rel="noopener noreferrer"&gt;https://apify.com/cee-data/estonia-company-financials-scraper&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  What the API returns
&lt;/h2&gt;

&lt;p&gt;Each result includes:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;company code, name, legal form, status and VAT number;&lt;/li&gt;
&lt;li&gt;report ID, financial year, reporting period and submission date;&lt;/li&gt;
&lt;li&gt;cash, current and non-current assets and total assets;&lt;/li&gt;
&lt;li&gt;current and non-current liabilities, equity and share capital;&lt;/li&gt;
&lt;li&gt;revenue, employee expense, depreciation, operating profit and net profit;&lt;/li&gt;
&lt;li&gt;retained earnings and average full-time-equivalent employees;&lt;/li&gt;
&lt;li&gt;calculated net profit margin, equity ratio and current ratio;&lt;/li&gt;
&lt;li&gt;the official monthly source cut and source URL.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Empty values remain &lt;code&gt;null&lt;/code&gt;; they are not converted to zero. The Actor intentionally excludes owners, directors, beneficial owners and personal contacts.&lt;/p&gt;

&lt;h2&gt;
  
  
  Call it with curl
&lt;/h2&gt;

&lt;p&gt;Create a token in Apify Console → API &amp;amp; Integrations, then run:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;curl &lt;span class="nt"&gt;-X&lt;/span&gt; POST &lt;span class="se"&gt;\&lt;/span&gt;
  &lt;span class="nt"&gt;-H&lt;/span&gt; &lt;span class="s2"&gt;"Authorization: Bearer &lt;/span&gt;&lt;span class="nv"&gt;$APIFY_TOKEN&lt;/span&gt;&lt;span class="s2"&gt;"&lt;/span&gt; &lt;span class="se"&gt;\&lt;/span&gt;
  &lt;span class="nt"&gt;-H&lt;/span&gt; &lt;span class="s2"&gt;"Content-Type: application/json"&lt;/span&gt; &lt;span class="se"&gt;\&lt;/span&gt;
  &lt;span class="nt"&gt;-d&lt;/span&gt; &lt;span class="s1"&gt;'{
    "companyCodes": ["10234957"],
    "historyYears": 3,
    "maxItems": 3
  }'&lt;/span&gt; &lt;span class="se"&gt;\&lt;/span&gt;
  &lt;span class="s2"&gt;"https://api.apify.com/v2/acts/cee-data~estonia-company-financials-scraper/run-sync-get-dataset-items"&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The response is an array with one item per company-year, newest first. Here is a shortened real result for Telia Eesti AS:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"companyCode"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"10234957"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"companyName"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Telia Eesti AS"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"reportYear"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;2025&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"periodStart"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"2025-01-01"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"periodEnd"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"2025-12-31"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"revenue"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;363164000&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"assets"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;372013000&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"equity"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;151234000&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"currentLiabilities"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;162062000&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"operatingProfit"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;86806000&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"netProfit"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;69590000&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"netProfitMargin"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mf"&gt;0.191621&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"equityRatio"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mf"&gt;0.406529&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"currentRatio"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mf"&gt;0.501265&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"sourceCut"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"2026-09-30"&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Use it in n8n
&lt;/h2&gt;

&lt;p&gt;Import the free &lt;a href="https://api.apify.com/v2/key-value-stores/2adhfhT2wfW54leSK/records/estonia-company-financials-lookup.json" rel="noopener noreferrer"&gt;&lt;code&gt;estonia-company-financials-lookup.json&lt;/code&gt; workflow&lt;/a&gt;. The flow is:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;enter an 8-digit Estonian registry code;&lt;/li&gt;
&lt;li&gt;call the Actor with &lt;code&gt;run-sync-get-dataset-items&lt;/code&gt;;&lt;/li&gt;
&lt;li&gt;receive normalized financial fields ready for Sheets, Airtable or a database.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The exported workflow contains no credentials. Use n8n Header Auth credentials for your Apify token.&lt;/p&gt;

&lt;h2&gt;
  
  
  Source freshness and pricing
&lt;/h2&gt;

&lt;p&gt;The Actor uses official e-Business Register open data under CC BY 4.0. Basic company data is updated daily; annual-report files are updated monthly. Every result includes the source cut so you do not mistake it for real-time financial data.&lt;/p&gt;

&lt;p&gt;Cold runs download only the archives required for the requested years and stream the CSV rows. Both source archives and normalized company results are cached for 168 hours by default. A cold lookup can take several minutes; the default cached example completes much faster.&lt;/p&gt;

&lt;p&gt;The price is &lt;strong&gt;$0.025 per company-year with financial data&lt;/strong&gt;. Unknown companies and metadata-only rows are not charged. There is no start fee.&lt;/p&gt;

&lt;p&gt;Possible uses include supplier due diligence, credit analysis, financial monitoring and feeding structured company data into an AI agent. If you build an integration, I would be interested to hear which additional fields or output format would make it more useful.&lt;/p&gt;

</description>
      <category>api</category>
      <category>webdev</category>
      <category>opendata</category>
      <category>automation</category>
    </item>
  </channel>
</rss>
