Hi,
In Ghent there are a lot of underground parking lots. The data is available via the following link:
Unfortunately I don’t have the knowledge to develop an integration of my own. Is there somebody who can help?
Basicly it would suffice to show how many spaces there are available per location.
Thanks in advance.
Meerkater
Developing a end-2-end integration will require quite a bit of time/effort.
However, seeing the existing API you probably can use the rest integration already, which you will have to analyse/steer on how to get the data you want.
I can try to help but I need to know if it is worth my time and that you will invest yours as well.
RESTful - Home Assistant (home-assistant.io)
EDIT: what are you really expecting to have as output of this intergation?
Hi,
Thanks for your quick response.
Unfortunately I don’t really have any experience in developing such functionality so I don’t know whether I would be a big help.
The only output that I would expect is the amount of free spaces per parking lot. That is the minimum.
A nice addition would be free spaces and total spaces available per parking lot.
So the data would be rather limited.
Kind regards,
Robin
I suggest two options
rest:
- authentication: basic
scan_interval: 30000
verify_ssl: false
resource: https://data.stad.gent/api/records/1.0/search/?dataset=bezetting-parkeergarages-real-time&q=&sort=-occupation&facet=name&facet=lastupdate&facet=description&facet=categorie
sensor:
- name: Ghent0
value_template: "{{ value_json.records.0.fields.name }}"
json_attributes_path: $.records.0.fields
json_attributes:
- name
- totalcapacity
- avaialablecapacity
- name: Ghent1
value_template: "{{ value_json.records.1.fields.name }}"
json_attributes_path: $.records.1.fields
json_attributes:
- name
- totalcapacity
- avaialablecapacity
etc.
etc.
up: easier to read what you are doing
down: if garages go/leave from the api then the sensors would show off results. Also the order may change
2. load all data into one set of attributes for one (1) sensor and then run a report on it
up: all data always in one sensor
down: more complex to write a report
this is my personal preference btw. but I donot know what you want
sensor:
- platform: command_line
name: Ghent All
scan_interval: 1500
command: >
echo "{\"garages\":" $(
curl
-s 'https://data.stad.gent/api/records/1.0/search/?dataset=bezetting-parkeergarages-real-time&q=&sort=-occupation&facet=name&facet=lastupdate&facet=description&facet=categorie'
) "}"
value_template: >
{{ value_json | length }}
json_attributes:
- garages
Thanks for your feedback. I will have to take a look at this because I don’t have experience with rest. But I’ll look into it. 
I’ll keep you posted if I have questions along the way.
No probs…just try it out, this is one of the core elements integrating with HA and although it is a bit techy, it provide a huge flexibility towards getting data in/out.
I myself am not a developer and did not know anything on rest/json 2 yrs ago and now I am a big fan, there are so many free API out there and if you understand the gist, the world is your oyster
I’ll certainly check it out. But the time is limited with children. 
Hi,
I tried the first option and I can see the data in my cards. But you are right. It seems like the order changes from time to time. It is also not always possible to show all attributes in 1 card because apparently you can only use 1 with the default cards.
How can I create a card with the necessary data when I use the second option?
Thanks,
Robin
I have no access to my dev instance, can you send me the output of the second option, formatted as per my own posts above
And, what are you hoping to see, a list a names with number of free places?
This is the data I can find on the sensor:
Garages
nhits: 12
parameters:
dataset: bezetting-parkeergarages-real-time
rows: 10
start: 0
sort:
- '-occupation'
facet:
- name
- lastupdate
- description
- categorie
format: json
timezone: UTC
records:
- datasetid: bezetting-parkeergarages-real-time
recordid: 93250351d7870a99023bf38b2db81b8045637430
fields:
occupation: 0
isopennow: 1
operatorinformation: Indigo
locationanddimension: >-
{"specificAccessInformation": ["inrit"], "level": "0", "roadNumber":
"?", "roadName": "?", "coordinatesForDisplay": {"latitude":
51.065684935819604, "longitude": 3.7328389913720565}}
occupancytrend: unknown
availablecapacity: 550
urllinkaddress: https://be.parkindigo.com/nl/car-park/parking-dok-noord
id: https://be.parkindigo.com/nl/car-park/parking-dok-noord
description: Ondergrondse parkeergarage Dok noord in Gent
lastupdate: '2023-03-15T10:35:23+01:00'
name: Dok noord
openingtimesdescription: 24/7
temporaryclosed: 0
type: offStreetParkingGround
categorie: parking buiten LEZ
totalcapacity: 550
text: Opgelet! Enkel ingang B ligt buiten LEZ.
freeparking: 0
location:
- 51.065684935819604
- 3.7328389913720565
geometry:
type: Point
coordinates:
- 3.7328389913720565
- 51.065684935819604
record_timestamp: '2023-03-15T09:37:04.607Z'
- datasetid: bezetting-parkeergarages-real-time
recordid: 1a80f7b97d108cc01620f9b681def1c25a37b05b
fields:
occupation: 3
isopennow: 1
operatorinformation: Mobiliteitsbedrijf Gent
locationanddimension: >-
{"specificAccessInformation": ["inrit"], "level": "0", "roadNumber":
"?", "roadName": "?", "coordinatesForDisplay": {"latitude":
51.072569883800206, "longitude": 3.7148313576713052}}
occupancytrend: unknown
availablecapacity: 337
urllinkaddress: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-het-getouw
id: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-het-getouw
description: Bovengrondse parkeergarage Het Getouw in Gent
lastupdate: '2023-03-15T10:36:48+01:00'
name: Getouw
openingtimesdescription: 24/7
temporaryclosed: 0
type: offStreetParkingGround
categorie: parking buiten LEZ
totalcapacity: 350
freeparking: 0
location:
- 51.072569883800206
- 3.7148313576713052
geometry:
type: Point
coordinates:
- 3.7148313576713052
- 51.072569883800206
record_timestamp: '2023-03-15T09:37:04.607Z'
- datasetid: bezetting-parkeergarages-real-time
recordid: 2aa0b3f16b2a06fd1bc758d346a83136258ba6a2
fields:
occupation: 23
isopennow: 1
operatorinformation: Mobiliteitsbedrijf Gent
locationanddimension: >-
{"specificAccessInformation": ["inrit"], "level": "0", "roadNumber":
"?", "roadName": "?", "coordinatesForDisplay": {"latitude":
51.0637023559265, "longitude": 3.724968367281895}}
occupancytrend: unknown
availablecapacity: 115
urllinkaddress: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-tolhuis
id: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-tolhuis
description: Ondergrondse parkeergarage Tolhuis in Gent
lastupdate: '2023-03-15T10:36:48+01:00'
name: Tolhuis
openingtimesdescription: 24/7
temporaryclosed: 0
type: offStreetParkingGround
categorie: parking in LEZ
totalcapacity: 150
freeparking: 0
location:
- 51.0637023559265
- 3.724968367281895
geometry:
type: Point
coordinates:
- 3.724968367281895
- 51.0637023559265
record_timestamp: '2023-03-15T09:37:04.607Z'
- datasetid: bezetting-parkeergarages-real-time
recordid: daf0d7afc3add7045a6083c22a6879b7707022a3
fields:
occupation: 24
isopennow: 1
operatorinformation: Mobiliteitsbedrijf Gent
locationanddimension: >-
{"specificAccessInformation": ["inrit"], "level": "0", "roadNumber":
"?", "roadName": "?", "coordinatesForDisplay": {"latitude":
51.03634169048174, "longitude": 3.738571094371151}}
occupancytrend: unknown
availablecapacity: 374
urllinkaddress: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-ledeberg
id: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-ledeberg
description: Bovengrondse parkeergarage Ledeberg in Gent
lastupdate: '2023-03-15T10:36:48+01:00'
name: Ledeberg
openingtimesdescription: 24/7
temporaryclosed: 0
type: offStreetParkingGround
categorie: parking buiten LEZ
totalcapacity: 495
freeparking: 0
location:
- 51.03634169048174
- 3.738571094371151
geometry:
type: Point
coordinates:
- 3.738571094371151
- 51.03634169048174
record_timestamp: '2023-03-15T09:37:04.607Z'
- datasetid: bezetting-parkeergarages-real-time
recordid: b92b2311d5058fb130dd5e898d7b31d6d902bb01
fields:
occupation: 39
isopennow: 1
operatorinformation: Mobiliteitsbedrijf Gent
locationanddimension: >-
{"specificAccessInformation": ["inrit"], "level": "0", "roadNumber":
"?", "roadName": "Savaanstraat 13\n9000 Gent",
"contactDetailsTelephoneNumber": "Tel.: 09 266 29 40",
"coordinatesForDisplay": {"latitude": 51.04877362543108, "longitude":
3.7234627726667133}}
occupancytrend: unknown
availablecapacity: 322
urllinkaddress: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-savaanstraat
id: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-savaanstraat
description: Ondergrondse parkeergarage Savaanstraat in Gent
lastupdate: '2023-03-15T10:36:48+01:00'
name: Savaanstraat
openingtimesdescription: 24/7
temporaryclosed: 0
type: carPark
categorie: parking in LEZ
totalcapacity: 530
freeparking: 0
location:
- 51.04877362543108
- 3.7234627726667133
geometry:
type: Point
coordinates:
- 3.7234627726667133
- 51.04877362543108
record_timestamp: '2023-03-15T09:37:04.607Z'
- datasetid: bezetting-parkeergarages-real-time
recordid: a8f5bf9d3f18f7507167889bbb0b2c6ccab5573f
fields:
occupation: 39
isopennow: 1
operatorinformation: Mobiliteitsbedrijf Gent
locationanddimension: >-
{"specificAccessInformation": ["inrit"], "level": "0", "roadNumber":
"?", "roadName": "Seminariestraat 9\n9000 Gent",
"contactDetailsTelephoneNumber": "Tel.: 09 266 29 50",
"coordinatesForDisplay": {"latitude": 51.05215838523151, "longitude":
3.7298928896398924}}
occupancytrend: unknown
availablecapacity: 272
urllinkaddress: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-reep
id: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-reep
description: '? parkeergarage Reep in Gent'
lastupdate: '2023-03-15T10:36:48+01:00'
name: Reep
openingtimesdescription: 24/7
temporaryclosed: 0
type: carPark
categorie: parking in LEZ
totalcapacity: 449
freeparking: 0
location:
- 51.05215838523151
- 3.7298928896398924
geometry:
type: Point
coordinates:
- 3.7298928896398924
- 51.05215838523151
record_timestamp: '2023-03-15T09:37:04.607Z'
- datasetid: bezetting-parkeergarages-real-time
recordid: f612f188d3455124f38f8240970d00d51086ecf4
fields:
occupation: 40
isopennow: 1
operatorinformation: Mobiliteitsbedrijf Gent
locationanddimension: >-
{"specificAccessInformation": ["inrit"], "level": "0", "roadNumber":
"?", "roadName": "Sint-Michielsplein 8\n9000 Gent",
"contactDetailsTelephoneNumber": "Tel.: 09 266 29 20",
"coordinatesForDisplay": {"latitude": 51.05311004768356, "longitude":
3.719727740000235}}
occupancytrend: unknown
availablecapacity: 148
urllinkaddress: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-sint-michiels
id: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-sint-michiels
description: Ondergrondse parkeergarage Sint-Michiels in Gent
lastupdate: '2023-03-15T10:36:48+01:00'
name: Sint-Michiels
openingtimesdescription: 24/7
temporaryclosed: 0
type: carPark
categorie: parking in LEZ
totalcapacity: 250
freeparking: 0
location:
- 51.05311004768356
- 3.719727740000235
geometry:
type: Point
coordinates:
- 3.719727740000235
- 51.05311004768356
record_timestamp: '2023-03-15T09:37:04.607Z'
- datasetid: bezetting-parkeergarages-real-time
recordid: c402d3718a76d271602f3177def1803efe3b27db
fields:
occupation: 50
isopennow: 1
operatorinformation: Mobiliteitsbedrijf Gent
locationanddimension: >-
{"specificAccessInformation": ["inrit"], "level": "0", "roadNumber":
"?", "roadName": "Sint-Pietersplein 65\n9000 Gent",
"contactDetailsTelephoneNumber": "Tel.: 09 266 29 60",
"coordinatesForDisplay": {"latitude": 51.04202834988112, "longitude":
3.7259818626205483}}
occupancytrend: unknown
availablecapacity: 347
urllinkaddress: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-sint-pietersplein
id: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-sint-pietersplein
description: '? parkeergarage Sint-Pietersplein in Gent'
lastupdate: '2023-03-15T10:36:48+01:00'
name: Sint-Pietersplein
openingtimesdescription: 24/7
temporaryclosed: 0
type: carPark
categorie: parking in LEZ
totalcapacity: 708
freeparking: 0
location:
- 51.04202834988112
- 3.7259818626205483
geometry:
type: Point
coordinates:
- 3.7259818626205483
- 51.04202834988112
record_timestamp: '2023-03-15T09:37:04.607Z'
- datasetid: bezetting-parkeergarages-real-time
recordid: ed5f115cb880f172f3802a172cd2003cd7dbb4c6
fields:
occupation: 58
isopennow: 1
operatorinformation: Mobiliteitsbedrijf Gent
locationanddimension: >-
{"specificAccessInformation": ["inrit"], "level": "0", "roadNumber":
"23", "roadName": "Ramen 23\n9000 Gent",
"contactDetailsTelephoneNumber": "Tel.: 09 266 29 70",
"coordinatesForDisplay": {"latitude": 51.05532, "longitude": 3.71653}}
occupancytrend: unknown
availablecapacity: 108
urllinkaddress: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-ramen
id: >-
https://stad.gent/nl/mobiliteit-openbare-werken/parkeren/parkings-gent/parking-ramen
description: Ondergrondse parkeergarage Ramen in Gent
lastupdate: '2023-03-15T10:36:48+01:00'
name: Ramen
openingtimesdescription: 24/7
temporaryclosed: 0
type: carPark
categorie: parking in LEZ
totalcapacity: 260
freeparking: 0
location:
- 51.05532
- 3.71653
geometry:
type: Point
coordinates:
- 3.71653
- 51.05532
record_timestamp: '2023-03-15T09:37:04.607Z'
- datasetid: bezetting-parkeergarages-real-time
recordid: d7e8f1a51413d1ad2ed47737935522d97a5b47c9
fields:
occupation: 60
isopennow: 1
operatorinformation: Mobiliteitsbedrijf Gent
locationanddimension: >-
{"specificAccessInformation": ["inrit"], "level": "0", "roadNumber":
"?", "roadName": "?", "coordinatesForDisplay": {"latitude": 51.0369,
"longitude": 3.70502}}
occupancytrend: unknown
availablecapacity: 198
urllinkaddress: >-
https://www.belgiantrain.be/nl/station-information/car-or-bike-at-station/b-parking/my-b-parking/gentstpieters
id: >-
https://www.belgiantrain.be/nl/station-information/car-or-bike-at-station/b-parking/my-b-parking/gentstpieters
description: Ondergrondse parkeergarage NMBS Gent-Sint-Pieters in Gent
lastupdate: '2023-03-15T10:32:29+01:00'
name: B-Park Gent Sint-Pieters
openingtimesdescription: 24/7
temporaryclosed: 0
type: carPark
categorie: parking buiten LEZ
totalcapacity: 500
freeparking: 0
location:
- 51.0369
- 3.70502
geometry:
type: Point
coordinates:
- 3.70502
- 51.0369
record_timestamp: '2023-03-15T09:37:04.607Z'
facet_groups:
- name: name
facets:
- name: B-Park Dampoort
count: 1
state: displayed
path: B-Park Dampoort
- name: B-Park Gent Sint-Pieters
count: 1
state: displayed
path: B-Park Gent Sint-Pieters
- name: Dok noord
count: 1
state: displayed
path: Dok noord
- name: Getouw
count: 1
state: displayed
path: Getouw
- name: Ledeberg
count: 1
state: displayed
path: Ledeberg
- name: Ramen
count: 1
state: displayed
path: Ramen
- name: Reep
count: 1
state: displayed
path: Reep
- name: Savaanstraat
count: 1
state: displayed
path: Savaanstraat
- name: Sint-Michiels
count: 1
state: displayed
path: Sint-Michiels
- name: Sint-Pietersplein
count: 1
state: displayed
path: Sint-Pietersplein
- name: Tolhuis
count: 1
state: displayed
path: Tolhuis
- name: Vrijdagmarkt
count: 1
state: displayed
path: Vrijdagmarkt
- name: lastupdate
facets:
- name: '2023-03-15T10:36:48+01:00'
count: 9
state: displayed
path: '2023-03-15T10:36:48+01:00'
- name: '2023-03-15T10:32:29+01:00'
count: 1
state: displayed
path: '2023-03-15T10:32:29+01:00'
- name: '2023-03-15T10:34:01+01:00'
count: 1
state: displayed
path: '2023-03-15T10:34:01+01:00'
- name: '2023-03-15T10:35:23+01:00'
count: 1
state: displayed
path: '2023-03-15T10:35:23+01:00'
- name: description
facets:
- name: '? parkeergarage Reep in Gent'
count: 1
state: displayed
path: '? parkeergarage Reep in Gent'
- name: '? parkeergarage Sint-Pietersplein in Gent'
count: 1
state: displayed
path: '? parkeergarage Sint-Pietersplein in Gent'
- name: Bovengrondse parkeergarage Het Getouw in Gent
count: 1
state: displayed
path: Bovengrondse parkeergarage Het Getouw in Gent
- name: Bovengrondse parkeergarage Ledeberg in Gent
count: 1
state: displayed
path: Bovengrondse parkeergarage Ledeberg in Gent
- name: Bovengrondse parkeergarage NMBS Dampoort in Gent
count: 1
state: displayed
path: Bovengrondse parkeergarage NMBS Dampoort in Gent
- name: Ondergrondse parkeergarage Dok noord in Gent
count: 1
state: displayed
path: Ondergrondse parkeergarage Dok noord in Gent
- name: Ondergrondse parkeergarage NMBS Gent-Sint-Pieters in Gent
count: 1
state: displayed
path: Ondergrondse parkeergarage NMBS Gent-Sint-Pieters in Gent
- name: Ondergrondse parkeergarage Ramen in Gent
count: 1
state: displayed
path: Ondergrondse parkeergarage Ramen in Gent
- name: Ondergrondse parkeergarage Savaanstraat in Gent
count: 1
state: displayed
path: Ondergrondse parkeergarage Savaanstraat in Gent
- name: Ondergrondse parkeergarage Sint-Michiels in Gent
count: 1
state: displayed
path: Ondergrondse parkeergarage Sint-Michiels in Gent
- name: Ondergrondse parkeergarage Tolhuis in Gent
count: 1
state: displayed
path: Ondergrondse parkeergarage Tolhuis in Gent
- name: Ondergrondse parkeergarage Vrijdagmarkt in Gent
count: 1
state: displayed
path: Ondergrondse parkeergarage Vrijdagmarkt in Gent
- name: categorie
facets:
- name: parking in LEZ
count: 7
state: displayed
path: parking in LEZ
- name: parking buiten LEZ
count: 5
state: displayed
path: parking buiten LEZ
I would like to have the following result:
Not exactly…the output you sent comes form this one
sensor:
- platform: command_line
name: Ghent All
scan_interval: 1500
command: >
echo "{\"garages\":" $(
curl
-s 'https://data.stad.gent/api/records/1.0/search/?dataset=bezetting-parkeergarages-real-time&q=&sort=-occupation&facet=name&facet=lastupdate&facet=description&facet=categorie'
) "}"
value_template: >
{{ value_json | length }}
json_attributes:
- garages
I am assuming this sensor is called sensor.ghent_all
With that you can create a markdown card like this
Code is like this below, just let me know if you got it the same way
Note: you probably want to reformat a few things but that is where I leave you to it and learn this …or ask someone else 
type: markdown
content: |
<table>
<tr>
<td><h4>Garage<h3></td>
<td><h4>Plaatsen</td>
<td><h4>Vrij</td>
<td><h4>Bezetting</td>
<td><h4>Update</td>
</tr>
{% set list = state_attr('sensor.ghent_all', 'Garages').records %}
{% for x in range(0,list|count) %}
<tr>
<td><a href="{{list[x].fields.urllinkaddress}}">{{ list[x].fields.name }}</a></td>
<td>{{ list[x].fields.totalcapacity }}</td>
<td>{{ list[x].fields.availablecapacity }}</td>
<td>{{list[x].fields.occupation}}</td>
<td>{{list[x].fields.lastupdate}}</td>
{% endfor %}
</tr>
</table>
card_mod:
style:
.: |
ha-card ha-markdown {
padding:0px
}
ha-card ha-markdown.no-header {
padding:0px
}
ha-markdown $: |
h1 {
font-weight: normal;
font-size: 24px;
}
div {
background-color:rgb(100, 100, 100);
padding: 12px 12px;
color:white;
font-weight:normal;
font-size:1.2em;
border-top-left-radius: 5px;
border-top-right-radius: 5px;
}
table{
border-collapse: collapse;
font-size: 0.9em;
font-family: Roboto;
width: auto;
outline: 0px solid #393c3d;
margin-top: 10px;
} caption {
text-align: center;
font-weight: bold;
font-size: 1.2em;
} td {
padding: 5px 5px 5px 5px;
text-align: left;
border-bottom: 0px solid #1c2020;
}
tr {
border-bottom: 0px solid #1c2020;
}
tr:nth-of-type(even) {
background-color: rgb(54, 54, 54, 0.3);
}
tr:last-of-type {
border-bottom: transparent;
}
mark {
background: lightgreen;
color: #222627;
border-radius: 5px;
padding: 5px;
}
span {
background: orange;
color: #222627;
border-radius: 5px;
padding: 5px;
}
span {
padding: 5px;
}
tr:nth-child(n+2) > td:nth-child(2) {
text-align: left;
}
Thanks for all your help!!! Much appreciated! Reformating shouldn’t be a problem.
I copy/pasted the code above but this doesn’t seem to give any results.
The sensor is indeed: sensor.ghent_all
Am I missing something?
travelling, copy it into the code section of the card
or use a manual card to add and copy it there.
EDIT: note that the state_attr is case sensitive, so if your first attr is garages in stead of Garages then do change that
Thanks a lot for your help! It was indeed case sensitive;
And I was missing the module card-mod so I installed it via HACS.
2 final questions:
I can see only 10 (0 to 9)
You are hopefully not asking me why Ghent garages cannot calculate the diff between two figures 
But on 2 seriously, and where i live this is more than common…people take up more space quite a few times or the system is broken or calc is wrong indeed (doubt it)
Hi,
Ok. So only 10 are send by the API then?
On this URL I saw 12 garages but this isn’t in the API then.
Thanks for all the help!
Have a nice day!
I just copied your api/link and noticed the output. I have no clue about non-API data
Where do you see 12 garages?
EDIT, and if you want me to start a rant on discrepancies (as a Dutch guy living in France)…be really sure … 
