Skip to main content

Discussions

Ask for help or share an insight.

102 Topics
Nicolas Terpolilli
Community Manager
Nicolas TerpolilliCommunity Manager
published in Gather data
Geographical referentials availability plan 2025News

A geographical referential is a dataset providing spatial information, such as the administrative divisions of a country or a territory.For a couple years now, we have invested in developing data pipelines in order to make those geographical referentials available in the product.They are available as simple datasets that you can use via federation for example. But they are also available in services: Processors (Geojoin and Retrieve Administrative Divisions) Studio base maps Providing those geographical referential is not an easy work. We rely on external sources. Even if they are official sources, they are sometimes not consistent in their release date. Also the API may change, the schema may change. It’s hard to keep up with the release even for us, so we know it’s even harder for you. Here is our plan in releasing geographical referential in 2025.We will try to keep it as up-to-date as possible. Though keep in mind that those dates are a best case scenario based on our experience fo

33514
Nadia VBX
A
antoinebugeiaBeginner
asked in Managing data portal
API for style sheet

Hi,we would like to use ODS API to implement CICD on the style sheet of our portal.We are waiting since severals years now for this feature to appear in automation, I guess it won’t happen.Anyway ODS made previously a GH repo with a snippet of how to use management api to update the style sheet :https://web.archive.org/web/20201013231909/https://github.com/opendatasoft/ods-portal-devkit#expandUnfortunatly this repo is now deleted and the files ont the repo are gone.Is anyone aware on how to use the management API for the domain_theme ?

00
A
W
wpigouryBeginner
asked in Analyze usage
API rate limit for geonames-postal-code dataset

Hi,I can’t find clear information on any rate limit for the usage of the API on public dataset like geonames-postal-code.I see a quota in my profile but I’m not sure this applies to public dataset.We have a use case where we measured up to 7000 registrations a day and would like to add city autocompletion based on zip code, so possibly resulting in as many requests to the API, or probably more if users don’t find the city they’re looking for after the first 3 digits (the limit we plan on setting to start querying the API).Is it something that could be supported without risk of hitting a limit?Thanks

70
W
E
Eric MeyerBeginner
asked in Gather data
Use of [totals] in ods-adv-table widget

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 :) 

281
E
R
RyanBeginner
asked in Organize data
Multile filter selection on a multiple context dashboard

Hi All :)Ive been working on a dashboard based on the mutlple context code libary piece “https://codelibrary.opendatasoft.com/page-templates/dashboard-filter/#code-dashboard-with-filters-on-multiple-contexts-css-content” https://northernpowergrid.opendatasoft.com/pages/la_dashboard/ this is what we have, and it works for the most part, the only problem is i cant select more than one option in the drop down, as the list refines itself when I pick an option. Can anyone assist? Ive set the “multiple” option to true in the ODS-Select part Thanks RyanAuto-translation 🪄Bonjour à tous :) J'ai travaillé sur un tableau de bord basé sur la bibliothèque de codes à contexte multiple « https://codelibrary.opendatasoft.com/page-templates/dashboard-filter/#code-dashboard-with-filters-on-multiple-contexts-css-content » https://northernpowergrid.opendatasoft.com/pages/la_dashboard/ c'est ce que nous avons, et cela fonctionne pour la plupart, le seul problème est que je ne peux pas sélectionner plus d'

937
thomas.pagotto
ODS Team
R
RyanBeginner
asked in Share data
Studio Editor Graphs

Me again!Ive been looking at the studio editor for creating pages, is there anyway to make the charts cumulative? For example im wanting to total the amount of generation in one of our datasets over the last 5 years or so, currently i can only get it to sum the amount in 2020, then 2021, 2022 etc, and not add these figures to show a trend over that time period. Apologies if its very obvious but currently I cant see it! Thanks Ryan

291
Rémy
Community Manager
Johannes Hool
Johannes HoolBeginner
asked in Share data
Iframe embeddings without "details-area"

I created a custom visualization for a dataset which is a searchable table in our corporate style. When embedding this visualization through an iframe the details-area is sticking to the bottom of the frame.In the following example you can see the rather prominent details-area at the bottom of the element.Is there a possibility to suppress this element? At the beginning I thought I could do this with the url parameter “datasetcard” (see example link below). However, I must have misinterpreted this parameter as it does not influence the details-area.<iframe src="https://data.bl.ch/explore/embed/dataset/adressen-der-gemeindeverwaltungen-januar-2025-kopieren/webtabelle/?disjunctive.name&disjunctive.plz&disjunctive.ort&static=false&datasetcard=false" width="400" height="300" frameborder="0"></iframe>Any help would be greatly appreciated.Best,Johannes

271
Johannes Hool
Y
yvonneBeginner
asked in The world of data
Geofilter on a dataset

I’ve been trying to use the Geofilter.polygon to refine the results in a dataset per this documentation:https://userguide.opendatasoft.com/en/articles/2257346#:~:text=geofilter.polygon,%2C2.386968)However it always looks like it does a text search in the records.  Is there a setting I need to activate at the dataset level to accept geofilter options? 

220
Y
M
mranshu6290Beginner
asked in Gather data
Authentication and Limit of 100 objects

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 

301
Y
Community Manager
Y
yvonneBeginner
asked in Organize data
Join datasets spatially

HiI’m trying to join a couple of datasets spatially.In Dataset A I have a geopoint (lat/long)In Dataset B I have a list of attributes in a polygon (shape) I want to use the geopoint in Dataset A as the key for Dataset B and return one or more columns from Dataset B…  Thank you for any options :)

140
Y
natalia.morozova
Community Manager
natalia.morozovaCommunity Manager
published in The world of data
New! Instantly translate posts and replies

Hello Community!Great news—posts are now available in 9 different languages! 🎉If a post is in a language you’re not comfortable with, just click “Translate” below the post and select your preferred language. AI will handle the rest. 📌 Bonus: You can also translate all replies to a post at once, just like this: Try it out and let us know what you think! 🚀

120
natalia.morozova
Community Manager
Y
yvonneBeginner
asked in The world of data
Replace via Regular Expression Processor

Hi we are trying to truncate the first 5 characters of a field and for some reason the Replace via Regular Expression processor doesn’t seem to ‘work”We have tried:^(.{1,5})(?:|$)Regex101.com seems to match it correctly and which replaces the first 5 characters with blank so then we tried this^.{5}(.*)which seems to replace all of it with a blank…  Help please.  If anyone can create a small library of useful regex strings for use that would be really appreciated!  

291
cyprien.oger
ODS Team
R
RyanBeginner
asked in Organize data
Adding descriptions in schema

Hi,Im trying to add descriptions to my schema, however when I enter my description the apply box stays greyed out.Any ideas why i cant seem to apply this change? Thanks RyanAuto-translation 🪄Bonjour, j'essaie d'ajouter des descriptions à mon schéma, mais lorsque je saisis ma description, la case d'application reste grisée. Avez-vous une idée de la raison pour laquelle je n'arrive pas à appliquer ce changement ? Merci Ryan

755
R
M
matthew.parryBeginner
asked in Analyze usage
Finding initial date of publication of every dataset.

I’m trying to find the date that we made each of our datasets publicly available, I can see when datasets last had their data or metadata changed, but I’m looking for when we first changed the security settings to make it visible to all users. The closest I have found is the “ods-activity_log-monitoring” back office analytics dataset, but this only has activity from the last 3 months, and we’re looking to get the dates since the beginning of our portal. Is there a way to use the API to inspect historical versions of datasets to determine this date for each dataset?   Auto-translation 🪄J'essaie de trouver la date à laquelle nous avons rendu chacun de nos ensembles de données accessible au public. Je peux voir quand les données ou les métadonnées des ensembles de données ont été modifiées pour la dernière fois, mais je recherche quand nous avons modifié les paramètres de sécurité pour la première fois pour les rendre visibles à tous les utilisateurs. Le plus proche que j'ai trouvé est l

501
Y
Community Manager
luciaonmatteo
luciaonmatteoBeginner
asked in Organize data
How Does OpenDataSoft Integrate with Popular Cloud Platforms Like AWS, Azure, and Google Cloud?

Hi everyone,I’ve been working on a project that involves handling large datasets, and I’m exploring how OpenDataSoft can be integrated with cloud computing platforms like AWS, Microsoft Azure, and Google Cloud.Here are some specific questions and thoughts I’d like to dive into:Built-In Connectors or APIs: Does OpenDataSoft provide native connectors for AWS, Azure, and Google Cloud? For example, can it easily connect to services like S3 (AWS), Blob Storage (Azure), or Google Cloud Storage? Setting Up Data Pipelines: How straightforward is it to establish data pipelines between OpenDataSoft and these cloud platforms? Are there any step-by-step guides or best practices for automating data transfers and updates? Real-Time Data Processing: Can OpenDataSoft handle real-time data streaming from cloud-based sources like Azure Event Hubs, AWS Kinesis, or Google Pub/Sub? If so, how is latency managed to ensure smooth operation? Data Security and Compliance: With data moving between OpenDataSoft

421
Rémy
Community Manager
Nadia VBX
Nadia VBXBeginner
posted in Gather data
Limiter la connexion HTTP OAuth2 en App Registration à un site SharePoint en particulier

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

200
Nadia VBX
M
mehdiBeginner
asked in Share data
Help with Adjusting Label Rotation and Truncated Y-Axis Labels

Hi everyone,I’m currently working on a couple of charts and need some help with the following: Removing Label Rotation on X-Axis: I have a column chart where the X-axis labels are rotated by 45°. I would like to keep them horizontal (no rotation). I’ve tried using the x-label-rotation="0" attribute, but it doesn’t seem to work. Does anyone know how to remove the rotation and keep the labels straight? Fixing Truncated Labels on Y-Axis: In another chart, the labels on the Y-axis are too long and are getting truncated. I’d like to ensure that the full labels are visible without cutting off any text. Does anyone have a solution for adjusting the Y-axis to accommodate longer labels? Any help or suggestions would be greatly appreciated!Thanks in advance!Auto-translation 🪄Bonjour à tous, Je travaille actuellement sur quelques graphiques et j'ai besoin d'aide pour les points suivants : Suppression de la rotation des étiquettes sur l'axe des X : J'ai un graphique à colonnes où les étiquettes

351
M
ODS Team
natalia.morozova
Community Manager
natalia.morozovaCommunity Manager
posted in The world of data
Share your highlights 2024!

Hello Community, the New Year is approaching and I thought we could share a few things - personal achievements, movies, songs, books, and other stuff (in data or not) — that have inspired us over the last 12 months.One of my achievements: Community launch, love it!🤩 Another one: 16 min in a wall sit challenge with my colleagues - it makes me question my career choices 🤔😅 My fav podcast of the year (in French): Raphaël Gaillard - Notre cerveau ne se supporte plus: on pharmacology, psychology, psychedelics, and brain chips…What are yours??Auto-translation 🪄Bonjour la communauté, la nouvelle année approche et j'ai pensé que nous pourrions partager quelques éléments - réalisations personnelles, films, chansons, livres et autres choses (en données ou non) - qui nous ont inspirés au cours des 12 derniers mois. Une de mes réalisations : le lancement de la communauté, j'adore ! 🤩 Une autre : un défi de 16 minutes assis contre un mur avec mes collègues - cela me fait remettre en question m

1284
Yiu-Shing Pang
T
TristanBeginner
asked in Managing data portal
Stop auto unzip

HelloI want to publish a dataset that is in a ZIP format. The source is a URL that I don’t want to share for safety/server load reasons. Unfortunately, ODS unzip it automatically.I just want an other URL pointing toward the same zip file… is it possible?Thank you Auto-translation 🪄BonjourJe souhaite publier un jeu de données au format ZIP. La source est une URL que je ne souhaite pas partager pour des raisons de sécurité/charge du serveur. Malheureusement, ODS le décompresse automatiquement. Je souhaite simplement une autre URL pointant vers le même fichier zip… est-ce possible ? Merci 

230
T
R
RyanBeginner
asked in Share data
Elements of maps showing on top of pop ups

Hi All! Maybe ( and hopefully ) a simple one, has anyone else had problems with pop ups not appearing on top of certain elements on their page? See below where certain parts of the map show over the top of the pop up. Is there anything to include in the code to ensure the pop-up appears over everything?  Auto-translation 🪄Bonjour à tous ! Peut-être (et j'espère) une question simple, quelqu'un d'autre a-t-il eu des problèmes avec des fenêtres contextuelles qui n'apparaissent pas au-dessus de certains éléments de sa page ? Voir ci-dessous où certaines parties de la carte s'affichent au-dessus de la fenêtre contextuelle. Y a-t-il quelque chose à inclure dans le code pour garantir que la fenêtre contextuelle s'affiche au-dessus de tout ?

272
R
R
RenatoFBeginner
asked in Managing data portal
Where are the filter settings?

Since you updated the backend and put the schema into a separate tab, I am only able to access the filter information through the explore api. Where in the new backend do I find the filter settings (in the web interface)? Also, and related, where are the facet settings in general?Regards,Renato

392
R
Christian Trachsel
Christian TrachselBeginner
asked in Managing data portal
Order of the Facets with the new backend

Hi how does I sort the facets. The button doesn’t work like I thought. when I push the UP button, nothing happenAuto-translation 🪄Bonjour, comment trier les facettes. Le bouton ne fonctionne pas comme je le pensais. Lorsque j'appuie sur le bouton UP, rien ne se passe

562
Valentine
ODS Team
R
RenatoFBeginner
asked in Managing data portal
Opendatasoft Documentation

HiWhere do I find the documentation for opendatasoft? Right know, I would like to know how exactly RTP behaves. E.g. what happens when I push a dataset with data that is already present, that is updated, or with just a few updates?But I am more interested in where your documentation is located. I am looking for something similar as the Automation v1 API documentation: https://help.opendatasoft.com/apis/ods-automation-v1/. When I have similar problems in the future, I would like to know where to search for the solution instead of asking in the community each time I run into a problem. Best,RenatoAuto-translation 🪄BonjourOù puis-je trouver la documentation d'opendatasoft ? Je voudrais savoir comment se comporte exactement RTP. Par exemple, que se passe-t-il lorsque je transmets un ensemble de données contenant des données déjà présentes, mises à jour ou avec seulement quelques mises à jour ? Mais je suis plus intéressé par l'emplacement de votre documentation. Je recherche quelque chose

384
R
David Guillaume
David GuillaumeBeginner
asked in Share data
refine date parameter with actual date in ods-dataset-context widget

Hello,I have the same question as this one, but unfortunately, the answer doesn’t satisfy me (the proposed solution leads to another issue specific to my case). Is there a way to directly refine with the current date in the ods-dataset-widget? A solution in the spirit of the image below:thank you in advance.DavidAuto-translation 🪄Bonjour, j'ai la même question que celle-ci, mais malheureusement, la réponse ne me satisfait pas (la solution proposée amène à une autre problématique propre à mon cas). Existe-t-il un moyen d'affiner directement avec la date du jour dans le widget ods-dataset ? Une solution dans l'esprit de l'image ci-dessous : merci d'avance. David

1046
M
ODS Team
Y
yvonneBeginner
asked in Gather data
API for dataset schema?

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

322
Y

Hello there!

Ask away and you shall receive an answer.
Terms & ConditionsCookie settings
Opendatasoft Terms & Conditions Cookie settings