Problem with a Json File

[igor]

Hello,
I'm trying to obtain a list from a JSON file.
The JSON file is here : https://raw.githubusercontent.com/openeventdatabase/datasources/master/fr.prix-carburants/stations.json

My blocks are here :

There is no results and I don't understand where is the problem.
Could you help me, please ?

Many thanks.

[ABG]

Your responseContent is not well formed JSON text.
It needs [ ] at file begin and end and ',' between each object and the next, to make it a list of objects.

Use Do It on the output of your JSONTextDecode attempt for confirmation.

[Juan_Antonio]

• Convert your text to valid json.
• Use KIO4_DecoJson extension.

[igor]

Hello,
Why do you advise KIO4 extension ? Is not possible to use Web1.JsonTextDecoceWithDictionaries / jsonText / get global my_json ?
Many thanks.

[Juan_Antonio]

@igor

Why do you advise KIO4 extension ?

KIO4_DecoJson extension can be a bit complicated to handle, but if you do it right it uses less blocks, in image you get the data of the record whose id is 20110003.
If you prefer to use the JsonTextDecodeWithDictionaries block, I imagine that would be a good option as well.

Extension. JSON Decode. JsonPATH. Get the value easily. Convert XML <> JSON

Hello friends, with this extension we can obtain the values ​​of a JSON text, writing its path. We can also convert string XML to JSON and from JSON to XML. JSON: https://www.json.org/json-es.html In JSON we can find: Object, the elements is in {brace}, for example: {"age": 25, "name": "Juan Antonio", "value": true} Array, the elements is in [square bracket], for example: ["24", "Pedro Luis", false] In Array the elements are numbered: store.book [1] 1.- JSON Examples: https://jso…

[Juan_Antonio]

Another example.
Shows in pretty json all records whose commune is AJACCIO.

ooooooooooooooooooooooooooooooooooooo

commune AJACCIO and marque BP

[Juan_Antonio]

Here with list: