Huwise discussions

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 ?

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

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.

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,

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"

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,

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

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;}

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

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?

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'

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

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 

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

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

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

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

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 ?

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

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

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

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

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