<?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: SSTEmpresarial</title>
    <description>The latest articles on DEV Community by SSTEmpresarial (@sstempresarial).</description>
    <link>https://dev.to/sstempresarial</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%2F4161817%2Fb90ba595-db00-42ae-9e87-4b86b6a3219b.png</url>
      <title>DEV Community: SSTEmpresarial</title>
      <link>https://dev.to/sstempresarial</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/sstempresarial"/>
    <language>en</language>
    <item>
      <title>Official fuel prices for France, Spain and Italy in one API call (and from an AI agent via MCP)</title>
      <dc:creator>SSTEmpresarial</dc:creator>
      <pubDate>Sun, 04 Oct 2026 14:49:38 +0000</pubDate>
      <link>https://dev.to/sstempresarial/official-fuel-prices-for-france-spain-and-italy-in-one-api-call-and-from-an-ai-agent-via-mcp-2aon</link>
      <guid>https://dev.to/sstempresarial/official-fuel-prices-for-france-spain-and-italy-in-one-api-call-and-from-an-ai-agent-via-mcp-2aon</guid>
      <description>&lt;p&gt;France, Spain and Italy require every fuel station to report its prices, and all three governments publish them as open data. That makes station-level petrol and diesel prices one of the best free datasets in Europe. The catch: each country publishes it in a completely different shape.&lt;/p&gt;

&lt;h2&gt;
  
  
  The four official feeds
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Region&lt;/th&gt;
&lt;th&gt;Publisher&lt;/th&gt;
&lt;th&gt;Format&lt;/th&gt;
&lt;th&gt;Freshness&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;France&lt;/td&gt;
&lt;td&gt;Ministère de l'Économie (DGCCRF)&lt;/td&gt;
&lt;td&gt;JSON/CSV export, ~9,800 stations&lt;/td&gt;
&lt;td&gt;~10 min&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Spain&lt;/td&gt;
&lt;td&gt;Ministerio para la Transición Ecológica&lt;/td&gt;
&lt;td&gt;REST JSON with decimal commas, ~11,500 stations&lt;/td&gt;
&lt;td&gt;~30 min&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Italy&lt;/td&gt;
&lt;td&gt;MIMIT (Osservaprezzi)&lt;/td&gt;
&lt;td&gt;two pipe-separated CSVs you must join, ~23,900 stations&lt;/td&gt;
&lt;td&gt;daily (08:00 prices)&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Western Australia&lt;/td&gt;
&lt;td&gt;FuelWatch&lt;/td&gt;
&lt;td&gt;RSS, prices in cents&lt;/td&gt;
&lt;td&gt;daily fixed price&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;If you only need one country, use the raw feed directly. If you need several, the work is mostly normalization. Quirks I hit:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;France:&lt;/strong&gt; the export labels timestamps as &lt;code&gt;+00:00&lt;/code&gt;, but they are Paris local time (they match the raw &lt;code&gt;@maj&lt;/code&gt; value). Taken literally, every price looks up to 2 h in the future.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Italy:&lt;/strong&gt; some station names contain the CSV delimiter (&lt;code&gt;STOIL SIMPLE | gestori.prezzibenzina.it&lt;/code&gt;), which shifts columns unless you repair the row. Self-service and attended prices are separate rows.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Spain:&lt;/strong&gt; decimal commas everywhere, and some stations sell only to members (cooperatives, fleets).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Fuel names:&lt;/strong&gt; Gazole, Gasóleo A, Gasolio and Diesel are the same product; Italy alone has ~60 branded labels.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  One schema for all of them
&lt;/h2&gt;

&lt;p&gt;I packaged the normalization as an API: one row per fuel price per station, with coordinates, an ISO 8601 timestamp with time zone, currency, unit (L or kg), a normalized &lt;code&gt;fuelType&lt;/code&gt; (the original label stays in &lt;code&gt;fuelName&lt;/code&gt;) and the source + licence on every row. It supports a radius search sorted cheapest-first, with &lt;code&gt;distanceKm&lt;/code&gt; on each row.&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="s2"&gt;"https://api.apify.com/v2/acts/sste~official-fuel-prices/run-sync-get-dataset-items"&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;"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;'{"latitude":48.8566,"longitude":2.3522,"radiusKm":3,"fuelTypes":["diesel"],"maxResults":10}'&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The country is detected from the coordinates, so only the needed feed is downloaded. Python:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;from&lt;/span&gt; &lt;span class="n"&gt;apify_client&lt;/span&gt; &lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;ApifyClient&lt;/span&gt;

&lt;span class="n"&gt;client&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nc"&gt;ApifyClient&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;&amp;lt;APIFY_TOKEN&amp;gt;&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;run&lt;/span&gt; &lt;span class="o"&gt;=&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="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;sste/official-fuel-prices&lt;/span&gt;&lt;span class="sh"&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="n"&gt;run_input&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;latitude&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;41.3874&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;longitude&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;2.1686&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;radiusKm&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;5&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;fuelTypes&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;gasoline_95&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;maxResults&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;10&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
&lt;span class="p"&gt;})&lt;/span&gt;
&lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;r&lt;/span&gt; &lt;span class="ow"&gt;in&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="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;defaultDatasetId&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]).&lt;/span&gt;&lt;span class="nf"&gt;iterate_items&lt;/span&gt;&lt;span class="p"&gt;():&lt;/span&gt;
    &lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;r&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;price&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt; &lt;span class="n"&gt;r&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;currency&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt; &lt;span class="n"&gt;r&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;brand&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt; &lt;span class="n"&gt;r&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;distanceKm&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;km&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  From an AI agent (MCP)
&lt;/h2&gt;

&lt;p&gt;The same tool can be called by Claude, Cursor, VS Code or any MCP client through the Apify MCP server:&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;"mcpServers"&lt;/span&gt;&lt;span class="p"&gt;:&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;span class="nl"&gt;"fuel-prices"&lt;/span&gt;&lt;span class="p"&gt;:&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;span class="nl"&gt;"url"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://mcp.apify.com?tools=sste/official-fuel-prices"&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;span class="p"&gt;}&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;p&gt;Then ask: "Find the 5 cheapest diesel stations within 5 km of 48.8566, 2.3522." Tip for agents: always pass coordinates (there is no geocoding) and a small &lt;code&gt;maxResults&lt;/code&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  Disclosure and links
&lt;/h2&gt;

&lt;p&gt;I built this (SSTE). It runs on Apify with pay-per-use pricing ($0.005 per run + $0.0005 per row, so a 10-station query costs about a cent). The raw government feeds above stay free if you prefer to build it yourself.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;API on Apify: &lt;a href="https://apify.com/sste/official-fuel-prices" rel="noopener noreferrer"&gt;https://apify.com/sste/official-fuel-prices&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;Docs and guides: &lt;a href="https://fuel-prices-api.pages.dev" rel="noopener noreferrer"&gt;https://fuel-prices-api.pages.dev&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;Runnable examples: &lt;a href="https://github.com/SSTEmpresarial/official-fuel-prices-api-examples" rel="noopener noreferrer"&gt;https://github.com/SSTEmpresarial/official-fuel-prices-api-examples&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Data: DGCCRF (Licence Ouverte v2.0), MITECO (Ley 37/2007), MIMIT (IODL 2.0), FuelWatch. Independent project, not affiliated with these agencies.&lt;/p&gt;

</description>
      <category>api</category>
      <category>opendata</category>
      <category>python</category>
      <category>mcp</category>
    </item>
  </channel>
</rss>
