Read Json Data and put it into Variables

Hi Jokob,
I have to do this on every project, so I will share the technique I use. Use the puzzles that Yuri pointed out, but here are a few tips.
1. The “load data” puzzle is asynchronous. Don’t assume your data is loaded on the first frame. Use the “once ready do” slot to initiate whatever actions you need to perform.
2. Check if a key is in a dictionary before using it. See puzzle screenshot. Catch the error and do something if the key is missing. Typos and other data errors happen.
3. The dictionary data type in the puzzle system is implemented as a JS object. So if your JSON has nested JS objects, you will need to use the dictionary puzzles to pick through the JSON. See color values in the puzzle screenshot.

Hi,

you should use nested get key puzzles to retrieve the inner value

Hello,
Thanks for the information!

Unfortunately I can’t get it to work as I needed.

Even if I simply try to read the loaded data I get an error in the console “Read JSON Puzzle: could not interpret data.” I don’t get it as the JSON I think is the same as in the example of Jem, just with strings.

I added my current puzzles in the attachment, pretty sure it would not work that way.

What I want to archive:
I have a JSON-File where IDs and corresponding RGB-color values are stored.

In my parent HTML UI document there are buttons with the IDs of the JSON.

When one of those buttons is clicked, I want to have the color of one material changed to the corresponding RGB-color value.

How to do that?

Thank You!

I also did post my question in this topic, but I guess it makes more sense here:

find text in specific row/column in list(table)

@yuri

Just sent you an email because of the “Read JSON Puzzle: could not interpret data.” error.

I get this error also in an empty project, where I try to load the data.json file which is used by jem in his tutorial.

Thank You for looking into this!

Thank you for the fast response and the helpful tip. Currently debugging and trying different puzzle/approaches to get my functionality working. Still struggling.

Would be grateful for any input on how this would work.

Hello,
I have the problem that after the update to 4.2 my puzzle logic for importing and reading a json-file via a rest API does not work anymore.
The solution described above that you no longer need a “read json” puzzle I have already adapted.
It all works when I load a local jason-file, but as soon as I want to load the json-file via a REST_API I get an error message (see photo). I think it has something to do with the response of the server.
Would be very happy if someone has a solution.

Link to the REST API with the json file:
https://hook.eu1.make.com/qbgjk8a1f52jbwmv1qv95hz126c8j9dy

Thanks a lot and best regards
jakob