Webclient to table data

Hi I am trying to get data from a api, the webclient is working, but wondering how to separate the data in one line into table ( as the screenshot shown below), line 14 has all the data, but I have no idea on how to put it into table like Central | 0.

You can try to get results using a jsonDAT and by disabling the “include header”-parameter on the webclient. Then, check the OPsnippets for the jsonDAT. You will find an example on how to transform JSON-Data in to a table.

I use a combination of this two tools, but it is not as streight forward if you have no experience with python.

1 Like