Gather data

For over ten years, you have been publishing, exploring, and using open data with our tools. To support these uses, we have made available two portals powered by Opendatasoft:data.opendatasoft.com, showcasing public data published by Opendatasoft platform clients, public.opendatasoft.com, where we republish complementary open data, maintained by Opendatasoft.These spaces have made it possible to expose a wide diversity of datasets, build enriched use cases, and inspire the community. Today, we are evolving this offering to make it clearer, more sustainable, and more useful for all members of our ecosystem.Clarifying the offer, strengthening the impactWe want to focus our efforts on what is truly useful to you: well-selected, carefully maintained datasets, accessible within a clear framework. To achieve this, we will evolve our system: Closure of data.opendatasoft.com: This portal will no longer be accessible as a public showcase. All existing access will remain functional: datasets wil

Hello Opendatasoft Community, I’m Prakash Hinduja, I’m currently working on a dataset that needs to stay up to date, and I’d like to schedule automatic data updates in Opendatasoft.I’d really appreciate any guidance, examples, or tips from your experience. Thanks in advance for your help! RegardsPrakash Hinduja 

I’m trying to use some Openstreetmap data in ODS.However some of the data is formed where there are multiple lat/lon for an ID and when bringing it into ODS, ODS takes none of the lat/lon pairs when there are multiple.  See screenshot of the multiple lat/lon pairs The records with multiple happen to be at the bottom as I think (assume) ODS uses the first 20 rows to determine a pattern.  I want ODS to at least take the first pair of lat/lon so the data is somewhat accurate (at the moment it just ignores this and leaves the lat and lon fields blank. Query used for bringing in the data is here:https://overpass-api.de/api/interpreter?data=%2F*%0AThis%20query%20looks%20for%20nodes%2C%20ways%20and%20relations%20%0Awith%20the%20given%20key%2Fvalue%20combination.%0AChoose%20your%20region%20and%20hit%20the%20Run%20button%20above%21%0A*%2F%0A%5Bout%3Ajson%5D%5Btimeout%3A25%5D%3B%0A%2F%2F%20gather%20results%0Anwr%5B%22highway%22%3D%22elevator%22%5D%28-27.870644599673355%2C152.0219421386719%2C-26.

Hello!I am currently working on visualizing a table in a dashboard, and I would like to have a final row where I can freely sum or average the values in the table. The table is updated daily and evolves over time. The [totals] argument in ods-adv-table exists, but as far as I know, it only allows summing the column values.The only workaround we have found so far is to create a second table, removing the "group-by" per day and computing the sum/average where needed. However, this solution has a visual drawback: the legend remains, and the data in the second table is not perfectly aligned with the first one.Do you have any other ideas to improve the visualization? I would greatly appreciate your help :) 

Hi folks.Is there a way to proper case text with a processor i.e change biomass to Biomass?Sometimes our source is a little sloppy in their data management and I would like to correct it on publish. Thanks,

Hi, Im really struggling to get the JSON processor to work with https://api.carbonintensity.org.uk/regionalI think I have it pulling in correctly but when I try and extract using the JSON processor using Extract from JSON or Expand JSON array it isnt populating the field. I’ve re-read the academy docs and asked ChatGPT but nothing is working in the output. Many Thanks,

Dear TeamI hope this message finds you well.I am new here and currently working on using the sensor’s API. I have noticed that the results seem to be limited to what I see even if I am not authenticated. I am unsure if I am using the API authentication correctly.I have attached a screenshot of my current setup for your reference. Could you please guide me on the following:API Authentication: Am I using the correct authentication method? If not, could you please provide the correct steps 

Après plusieurs tests de configuration, le support Opendatasoft nous a indiqué que le connecteur HTTP en OAuth2 ne permet pas encore de limiter l’autorisation d’accès à un site SharePoint en particulier “Sites.Selected” (voir Controlling app access on a specific SharePoint site collections - ESPC Conference, 2025). Pour le moment, il est uniquement possible d’accorder une autorisation sur tous les sites SharePoint de notre organisation ce qui n’est pas conforme aux bonnes pratiques de sécurité « least privilege access ».Nous espérons que ce développement sera programmé dès que possible par Opendatasoft. Nous vous remercions d’avance de soutenir ce besoin et de partager votre expérience à ce sujet.Nadia (Ville de Bruxelles)Auto-translation 🪄After several configuration tests, Opendatasoft support informed us that the HTTP connector in OAuth2 does not yet allow to limit the access authorization to a particular SharePoint site “Sites.Selected” (see Controlling app access on a specific Sha

Hi Is there a way to update the (new) dataset schema via an API?https://userguide.opendatasoft.com/en/articles/2044866Auto-translation 🪄Hi Is there a way to update the (new) dataset schema via an API?https://userguide.opendatasoft.com/en/articles/2

I’m looking to load data from an API that has a value in each record that is a link to a json file that has geographical data in it. Is there a way to extract the data from each of those geojsons into their corresponding row on the Open Data Portal?Currently I am using the extract URL processor and the load file processor, but this only creates a hyperlink to the json file, rather than pulling the data out of those files as a geoshape.Is there a processor I can use to do this, or perhaps something I can do with the data source settings?Auto-translation 🪄Je cherche à charger des données à partir d'une API qui a une valeur dans chaque enregistrement qui est un lien vers un fichier json contenant des données géographiques. Existe-t-il un moyen d'extraire les données de chacun de ces geojsons dans leur ligne correspondante sur le portail de données ouvertes ? Actuellement, j'utilise le processeur d'extraction d'URL et le processeur de chargement de fichier, mais cela crée uniquement un li

I’m having troubles opening the Excel version of the catalog downloaded from the main ODS Data portal:https://data.opendatasoft.com/explore/ (bottom left hand corner) The Excel version does not open.  The CSV version is messy Screenshot of CSV of catalog download Auto-translation 🪄J'ai des difficultés à ouvrir la version Excel du catalogue téléchargé à partir du portail principal de données ODS : https://data.opendatasoft.com/explore/ (coin inférieur gauche) La version Excel ne s'ouvre pas. La version CSV est désordonnée Capture d'écran du fichier CSV du téléchargement du catalogue

hifor how long it is possible to run the connector to a given Sharepoint file without interaction?regardsChristianAuto-translation 🪄Salut, combien de temps est-il possible d'exécuter le connecteur sur un fichier Sharepoint donné sans interaction ? Cordialement, Christian

why is the way of displaying the different projections (north/east) in a geojson not used in the conversion?EPGSG: 3857Normalize Projection Reference processor - Opendatasoft : User guide and documentationAuto-translation 🪄pourquoi la manière d'afficher les différentes projections (nord/est) dans un geojson n'est-elle pas utilisée dans la conversion ?EPGSG : 3857Normalize Projection Reference processeur - Opendatasoft : Guide utilisateur et documentation

How does the FTP connector work behind the scenes?Auto-translation 🪄Comment le connecteur FTP fonctionne-t-il en coulisse ?