Problem with Baserow response (can`t decode)

[dmitr]

Hi !
(https://github.com/oseamiya/Baserow)
Documentation
Extension Version: 4.1
Date Built: 2022-04-27

I use "GetAllRows" and should be response at .JSON format, but both web.jsonTextDecode and web.jsonTextDecodeWithDictionaries fails to decode.

I think that becouse Baserow :

• "response" looks like ["{"key":"value",
• "values" looks like [[value1, value2, value3],[....],[...]].

Normal JSON can`t contain "[", its only operate with "{".

How to use/convert such Baserow responses ?

[Peter]

You sometimes have to use [ and ] in JSON

So the extension is working great. Show your response content and the blocks you use to decode.

Edit:

For my latest Baserow projects I used this extension from @Juan_Antonio and that makes JSON much more easy to use.

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…