Perform joins with large datasets using the new processor 🎉
Ask questions, get answers, and engage with your peers
Don't know where to start?
Initiatives produced by our community.
Documentation, Academy and other useful resources
APIs documentations, templates, and widgets
In a few days, you'll be able to perform joins on very large datasets with no size limit. 🎉 👉 To help you prepare for this change, you’ll receive an email with the list of affected datasets and the actions to take. Stay tuned!
What is the Automation API?The Automation API streamlines the back-office management of an Opendatasoft portal by automating over 150 actions—from data publication to domain and user permissions management—without using the interface. New endpoints to manage your metadata translationsAutomatically set translations for your metadata with the new Automation API endpoints. No need to re-enter them manually if they already exist in your information system tools or within the portal. The result: significant time savings and simplified multilingual management.Try it nowIf your plan includes the Automation API, you can now explore the updated technical documentation to try it out:Translation suggestions Code editor pages translations Studio pages translations Dataset translationsLearn moreDiscover real-world use cases and the benefits of the Automation API in this dedicated article Contact your Customer Success Manager or sales representative
Is there a way to add metadata and dataset schema translations (e.g. in english or italian) via the Automation API?
In order to create faster pages in the Studio, a button for duplicating a block could be great !Auto-translation 🪄Afin de créer des pages plus rapidement dans le Studio, un bouton pour dupliquer un bloc pourrait être génial !
Hi All,Is there any definitions for the possible “Actions” in the portal api monitoring? Ie what defines a “download” etc Thanks Ryan
What is a geographic reference dataset?A geographic reference dataset is a dataset describing the administrative divisions of a country or area. What new reference datasets are available?Reference datasets for Switzerland:Cantons Municipalities (Gemeinde) Districts (Bezirk) Postal codes (4 digits) Postal codes (6 digits)Reference datasets for the United Kingdom:Output Areas (new dataset) Local Authority Districts Lower Layer Super Output Areas Counties & Unitary Authorities Middle Layer Super Output Areas Regions Countries Parishes & Communities Wards & Electoral Divisions
Hello everybody,I have 2 maps in my dashboard (2 different years): I would like to have a shared “location” between those two.For example, if I zoom on the left one, I want the right one to be zoomed also.Is it possible ?Thanks in advance
Bonjour,Sauf inattention de ma part, le hub ne propose que 2 JDD sur les IRVE à l’échelle nationale :https://data.opendatasoft.com/explore/?disjunctive.language&disjunctive.source_domain_title&disjunctive.theme&sort=modified&disjunctive.semantic.classes&disjunctive.semantic.properties&q=IRVE&refine.federated=false&refine.source_domain_title=Public+by+OpendatasoftL’un semble à jour (OSM) mais est présenté comme complémentaire du JDD Etalab mais qui lui n’est plus à jour du tout.Je ne trouve pas de JDD IRVE (V2.3.1) sur le hub ODS tel que : https://www.data.gouv.fr/datasets/fichier-consolide-des-bornes-de-recharge-pour-vehicules-electriques/, il serait pourtant bien utile, notamment avec un traitement permettant de filtrer les données par département ou région ce qu’il n’est pas possible de faire actuellement à partir de data.gouv.fr.Merci à vous et à disposition pour plus de précisions sur ma demande,Bonne journée
Good news! You can now easily duplicate your blocks and pages in the no-code studio, providing a valuable time-saver to speed up creation of your pages and data visualizations!👉 To duplicate a page:Go to your back office Go to the Pages Editor section > Studio Create a page, or open an existing one Click the Duplicate icon: 👉 To duplicate a block in a page:Still in the Studio, open the page of your choice Hover over the block you want to duplicate Click the Duplicate icon: Note: a section can only contain 4 blocks. If the limit is reached, the duplication option is disabled (to duplicate a block, first drag and drop it into another section).
I have a date selector on a custom view: https://cityobservatory.birmingham.gov.uk/explore/dataset/percentage-universal-credit-claimants-in-employment-wmca-wards-2025/insight/ The date selector is based on the date field which is set to type of month. However its only showing years. How can I have this show months? <div ods-facet-results="date" ods-facet-results-facet-name="date"ods-facet-results-context="ctxfiltered" ods-facet-results-sort="-alphanum"> <ods-selectselected-values="ctxfiltered.parameters['refine.date']"multiple="false"options="date"label-modifier="name"value-modifier="name"placeholder="Date"></ods-select></div>
Hi everyone,I’m Dario Schiraldi currently working on a project where I need to join multiple datasets, and I’d love to hear your suggestions on the best practices for performing data joins. Specifically, I’m interested in methods for both SQL and Python.I’d appreciate any insights, tips, or resources you have! Thanks in advance!RegardsDario Schiraldi CEO of Travel Works
Does anyone have any tips on how to shape data in our portals to work better with the AI tools? The concern from our leadership is someone will ask a question and if the data contains too many filterable items it could return an incorrect result.Is there any guidelines on how to better shape the data to make it easier for AI to understand and provide results?
Are there plans to add more mapping capability for Studio Maps - for example clusters, dots and shapes and heat maps - same functionality that is shown in Map Builder?
As I’m trying to create a page with the code editor, I’m facing an issue with the refinement of datasets.To automate a line chart for different contexts, so that I can select one dataset of a list of many datasets and use the same ods-chart tag, I want to refine all the contexts before referencing on them in the chart widget. But the important aspect of my question is this: For this refinement, it would be more convenient for me to define the values that should be excluded, instead of the ones that should be included.Is there a possibility to do so?Thank you all in advance! :)
Hi,My name is Prakash Hinduja (Hinduja Family Swiss) , I want to know about the Schema management for datasets and why it is important . Regards:Prakash Hinduja (Hinduja Family Switzerland)
Hello,Using the dataset named “ods-api-monitoring”, I am able to know the number of download for a specific dataset. However, I would like to perform this task every month, that’s why I want to automate this process using python. I tried to filter the dataset and take the link of the csv generated in order to upload it on python. Nevertheless, I have an error while launching the program, it seems that it has a link with the authentification on the plateform. Do we have access to an API for the dataset “ods-api-monitoring” ? Or is there another recommended way to retrieve this information?Thank you for your help.Best regards,Eva Berry
Hello everyone,I’m Kamal Hinduja from Geneva, Switzerland. I’m new to this community and look forward to contributing positively to the discussions while learning from your insights. Could someone please explain how Open data soft integrates with public datasets? Thanks in Advance!Kamal Hinduja Geneva, Switzerland
I have two datasets, one with polygons and names and one with data.I load the map in the LHS of the screen and use the refine-on-click feature within <ods-map-layer to load a HTML table on the RHS of the screen.However, I’d like to be able to have the map show the selection.I’ve tried using highlight-on-refine="true" but I suspect this doesn’t work because the data on the map is not actually being refreshed!Here is my code:!--scriptorendfragment--><div class="row ods-box"> <ods-dataset-context context="dfesmap,dfesdata" dfesmap-dataset="dfes-primary-polygons" dfesdata-dataset="dfes-2023-primary-data0"> <div class="col-md-8"> <ods-map style="height:560px" scroll-wheel-zoom="true"> <ods-map-layer context="dfesmap" display="choropleth" refine-on-click-context="dfesdata" refine-on-click
Need to discuss a more specific issue? Contact our support team and we’ll be happy to help you get up and running!
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.