Create your map from an OpenDataSoft database

OpenDataSoft is a software that allows companies, local authorities and administrations to organize, share and visualize all types of data, as well as make them available via APIs.

You can connect an OpenDataSoft dataset and import it onto the Wemap platform via the Json connector. Your content is therefore synchronized in real time: if a modification is made in the OpenDataSoft dataset, Wemap will update your map accordingly without any intervention on your part.

Here is the simple process that will allow you to connect your OpenDataSoft dataset to Wemap 😊: 

Step 1: Retrieve the dataset on the OpenDataSoft platform of your choice

Select API in order to retrieve your dataset in JSON format allowing real-time synchronization.

The dataset contains a certain number of results (records) visible on the right side of your screen.

❗ Remember to increase the number of result rows (Row) so that all results are included in your dataset. By default, it is set to 10, we recommend entering a value higher than the number of results.

Step 2: Click on "Send" at the bottom of the page and thus retrieve the URL provided by the API in JSON format

A new tab opens showing you all the available results (records) in JSON format.

❗ To make the elements more visible, we recommend downloading the JSON Viewer Plug-in

Here is what appears.

Each result (record) is formatted with the same properties (underlined in yellow)

Each property represents information that can be used on the map.

Copy the URL then go to your Wemap platform.

Step 3: Connectthe dataset to Wemap

• In the "Create" tab, choose "List" then "Connect an app"

• In the list, choose the JSON connector by clicking on "Connect"

• Paste the URL from OpenDataSoft in the indicated location then click on the icon on the right.

At this step, two object arrays are offered to you: facet groups and records

💡 Choose record because it contains the different locations to display on your map, then click on "Choose this path"

It's done 🎉! You now have access to the mapping that will allow you to drag and drop OpenDataSoft values into the corresponding Wemap properties.

❗ 3 important things to remember:

• Make sure to choose "recordid" as Unique ID (Wemap property) - not to be confused with the "datasetid" which corresponds to the entire dataset.
• Wemap absolutely needs the following values in order to correctly locate your points on the map: Unique ID - Name - Address (in the form of a postal address or latitude/longitude)
• Don't forget to give a name to your list!

Finally, if you want to modify or add certain elements to your dataset, it can be done in a few clicks, don't hesitate to contact the data manager within your organization or to use the contact section of your OpenDataSoft. 👍