<?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: frscrape</title>
    <description>The latest articles on DEV Community by frscrape (@frscrape).</description>
    <link>https://dev.to/frscrape</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4255291%2F0534723d-58d6-4e7d-8b0c-9d79d8d8a019.png</url>
      <title>DEV Community: frscrape</title>
      <link>https://dev.to/frscrape</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/frscrape"/>
    <language>en</language>
    <item>
      <title>How to enrich a list of French companies (SIREN, SIRET or name) with official data, without scraping</title>
      <dc:creator>frscrape</dc:creator>
      <pubDate>Fri, 20 Nov 2026 09:42:39 +0000</pubDate>
      <link>https://dev.to/frscrape/how-to-enrich-a-list-of-french-companies-siren-siret-or-name-with-official-data-without-scraping-5252</link>
      <guid>https://dev.to/frscrape/how-to-enrich-a-list-of-french-companies-siren-siret-or-name-with-official-data-without-scraping-5252</guid>
      <description>&lt;p&gt;If you work with French B2B data, you have probably received a spreadsheet like this: a column of company names, a few SIREN numbers, some SIRET numbers, half of them with typos. You need the official address, activity code and headcount for each one.&lt;/p&gt;

&lt;p&gt;France publishes all of this for free in the &lt;strong&gt;Sirene database&lt;/strong&gt; (INSEE), through the official API Recherche d'entreprises. The data is open (Licence Ouverte 2.0), so commercial reuse is allowed. The hard part is the plumbing: cleaning the list, telling SIREN from SIRET, matching names, respecting rate limits and removing duplicates.&lt;/p&gt;

&lt;p&gt;I built two small tools on Apify to do this plumbing for me. Here is how they work.&lt;/p&gt;

&lt;h2&gt;
  
  
  Option 1: enrich a list you already have
&lt;/h2&gt;

&lt;p&gt;The &lt;a href="https://apify.com/frscrape/french-companies-enrich" rel="noopener noreferrer"&gt;French Companies Enrichment&lt;/a&gt; Actor takes a mixed list, one company per line:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;356000000
18002002600019
La Poste ; 75015
Caisse des dépôts et consignations
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Each line can be a SIREN (9 digits), a SIRET (14 digits) or a company name. Add &lt;code&gt;; postal code&lt;/code&gt; after a name to make the match more precise. You can paste a column straight from Excel.&lt;/p&gt;

&lt;p&gt;For each line, you get back the original input, whether it was found, a confidence level, and the official data: legal name, SIREN, head-office SIRET, address, postal code, activity, headcount band, legal form and status. Exports work in CSV, Excel or JSON.&lt;/p&gt;

&lt;p&gt;A few details that matter in practice:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Duplicates are merged.&lt;/strong&gt; The same company entered as a SIREN, a SIRET and a name counts once.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Every match is graded.&lt;/strong&gt; An exact SIREN, SIRET or official name (with a matching postal code if given) is marked "sûre" (sure). A close name is marked "probable". Partial names and look-alikes are marked "à vérifier" (to check).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Bad lines are explained.&lt;/strong&gt; A SIREN with 8 digits or a wrong check digit comes back as not found, with the reason.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;No personal data.&lt;/strong&gt; Sole proprietors are excluded, and so are directors' names. Companies that opted out of commercial use of their data are also left out.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Pricing is $3 per 1,000 companies found. Lines that are not found are not charged.&lt;/p&gt;

&lt;h2&gt;
  
  
  Option 2: build a list from scratch
&lt;/h2&gt;

&lt;p&gt;If you do not have a list yet, the &lt;a href="https://apify.com/frscrape/french-companies-search" rel="noopener noreferrer"&gt;French Companies Search&lt;/a&gt; Actor finds companies by activity code (NAF), location and company size. For example: every software company with 10 to 49 employees in Toulouse. The output has the same fields, so you can chain both tools.&lt;/p&gt;

&lt;h2&gt;
  
  
  Calling it from code
&lt;/h2&gt;

&lt;p&gt;Both Actors can be called through the Apify API. Here is the enrichment one with the official JavaScript client. Run &lt;code&gt;npm install apify-client&lt;/code&gt;, set your &lt;code&gt;APIFY_TOKEN&lt;/code&gt; environment variable, and save the script as &lt;code&gt;example.mjs&lt;/code&gt;:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight javascript"&gt;&lt;code&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="nc"&gt;ApifyClient&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="s1"&gt;'apify-client'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;client&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;new&lt;/span&gt; &lt;span class="nc"&gt;ApifyClient&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;token&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nb"&gt;process&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;env&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="no"&gt;APIFY_TOKEN&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;run&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="n"&gt;client&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;actor&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s1"&gt;'frscrape/french-companies-enrich'&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;call&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="n"&gt;entreprises&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'356000000\nLa Poste ; 75015'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;items&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="n"&gt;client&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;dataset&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;run&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;defaultDatasetId&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;listItems&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="nb"&gt;console&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;log&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;items&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;In my tests, a list of 200 lines took about 75 seconds. The public API allows a limited number of calls per second, so speed is between 2 and 6 lines per second.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why not call the State API directly?
&lt;/h2&gt;

&lt;p&gt;You can, and it is free. These Actors are worth it when you do not want to write the matching, deduplication and retry code yourself, or when the person who needs the data does not code.&lt;/p&gt;

&lt;p&gt;Data source: INSEE, Sirene database, through the API Recherche d'entreprises (DINUM), Licence Ouverte 2.0.&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Disclosure: I am the author of both Actors. This article was written with the help of AI.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>api</category>
      <category>javascript</category>
      <category>webscraping</category>
      <category>opendata</category>
    </item>
  </channel>
</rss>
