Skip to main content

Discussions

Ask for help or share an insight.

132 Topics
Johannes Hool
Johannes HoolGuide
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

493
Johannes Hool
A
antoinebugeiaSeeker
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 ?

803
G
Y
yvonneGuide
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 :)

321
M
Community Manager
T
TMSSeeker
asked in Share data
Dashboard without visible dataset?

We have created some dashboards for students that are not yet publicly visible. The charts and KPIs on the dashboards are very aggregated, but the underlying datasets could be sensitive in terms of data protection. Is there a way that the datasets can only be used for the dashboards without a visitor to our ODS website being able to access the dataset itself?An alternative would be to hide some columns in the data set, but these are included again when exporting. Or is there a restriction option so that only the data that is visible on the ODS website can be exported?As an addendum: the dashboards were created with no-code-editor.

475
M
Community Manager
E
Eric MeyerSeeker
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 :) 

482
A
Y
yvonneGuide
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? 

431
M
Community Manager
Nicolas Terpolilli
Community Manager
Nicolas TerpolilliCommunity Manager
posted in The world of data
Future of Analytics teams

I’ve found this article very interesting :  https://open.substack.com/pub/benn/p/disband-the-analytics-team

321
D
danny.oneill
danny.oneillGuide
asked in Gather data
Possible to proper case text?

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,

191
R
Yanik Kipfer
Yanik KipferSeeker
asked in Share data
Sorting a stacked bar pl

Dear ODS Community Is there a way to sort a stacked bar plot according to the total value of the individual bars. Looking at the example in the image, I would like the bar for “Wohnzonen” to be on top and the bar for “weitere_Bauzonen” to be at the bottom. Here is the code for the barplot: <ods-chart scientific-display="false" single-y-axis="true" labels-x-length=100 label-x="Hauptnutzung"> <ods-chart-query context="dvsareraum20250224" field-x="ch_hauptnutzung_name" reverse-stacks="true" stacked="normal" series-breakdown="standueberbauung_aggregiert" sort="serie1-1"> <ods-chart-serie expression-y="flaeche_ha" chart-type="bar" index="0" function-y="SUM" color="range-custom" display-values="true"

362
Yanik Kipfer
danny.oneill
danny.oneillGuide
asked in Gather data
Help with JSON API source

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,

192
danny.oneill
W
wpigourySeeker
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

362
W
R
rb26Seeker
asked in The world of data
Thanks to the api, get geographical data in France per year

Hello,  I’m student, and I need to use OpenDataSoft for French municipalities per year, I want to know if it’s possible to get an API key to get this kind of data without limitations please. This is the data that I need between 2015 and 2024. https://public.opendatasoft.com/explore/embed/dataset/georef-france-commune-millesime/table/?disjunctive.reg_name&disjunctive.dep_name&disjunctive.arrdep_name&disjunctive.ze2020_name&disjunctive.epci_name&disjunctive.ept_name&disjunctive.com_name&disjunctive.ze2010_name&disjunctive.com_is_mountain_area&disjunctive.bv2022_name&sort=com_name

281
Y
Community Manager
S
Steve CrawshawSeeker
posted in Managing data portal
Height of map in custom views

When you include a map widget in a custom view for a dataset you may notice that the height is not optimal for screens. You can change this with the following css in the Custom View tab of Visualisations in the backoffice. Adjust the min-height value to suit. .odswidget-map {    height:-webkit-fill-available;    min-height: 600px;}.odswidget-map__map {    height: 100%;    min-height: 600px;}

130
S
R
RenatoFSeeker
asked in Organize data
Retrieve column types through Automation API 1.0

Hi everyone,I'm working with the ODS Automation API (v1) and I'm trying to retrieve the data types of columns in a dataset. When using the `/datasets/{dataset_uid}/fields` endpoint, I receive a list of field configurations that includes annotations (facet, timerangeFilter, etc.) and rename operations, but I'm having trouble finding the actual data types of the columns (like text, date, integer).Here's an example of what I get from the endpoint (for fields related to the ‘end_date’ field, which is of type ‘date’):[{'annotation': 'facet', 'args': [], 'field': 'end_date', 'label': '', 'type': 'annotation', 'uid': 'pr_toc04f'}{'annotation': 'facetsort', 'args': ['alphanum'], 'field': 'end_date', 'label': '', 'type': 'annotate', 'uid': 'pr_adjonu'}{'annotation': 'timerangeFilter', 'args': [], 'field': 'end_date', 'label': '', 'type': 'annotate', 'uid': 'pr_yv06h9'}{'field_label': 'Enddatum', 'from_name': 'end_date', 'label': '', 'to_name': 'end_date', 'type': 'rename', 'uid': 'pr_xh8w8e'}]W

221
R
Yanik Kipfer
Yanik KipferSeeker
asked in Share data
GPT-Model for API and Visualizations

Has anyone tried training a GPT-Model using the ODS documentation to be able to write HTML code that can be directly used in ODS to create visualizations?

180
Yanik Kipfer
R
RyanGuide
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'

1147
thomas.pagotto
ODS Team
R
RyanGuide
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

461
Rémy
Community Manager
M
mranshu6290Seeker
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 

471
Y
Community Manager
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! 🚀

220
natalia.morozova
Community Manager
Y
yvonneGuide
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!  

431
cyprien.oger
ODS Team
R
RyanGuide
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

805
R
M
matthew.parrySeeker
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

551
Y
Community Manager
luciaonmatteo
luciaonmatteoSeeker
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

551
Rémy
Community Manager
Nadia VBX
Nadia VBXSeeker
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

250
Nadia VBX
M
mehdiSeeker
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

411
M
ODS Team

Hello there!

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