Rapidminer and JSON
Hello!
How can I convert a JSON object into a table that Rapidminer can handle?
This is the JSON that I am working on:
[{"date":1465632900,"high":0.00199281,"low":0.00199281,"open":0.00199281,"close":0.00199281,"volume":0.00078269,"quoteVolume":0.39276167,"weightedAverage":0.00199281},{"date":1465633200,"high":0.00199281,"low":0.00199281,"open":0.00199281,"close":0.00199281,"volume":0.00034535,"quoteVolume":0.17329899,"weightedAverage":0.00199281},{"date":1465633500,"high":0.00198761,"low":0.00198761,"open":0.00198761,"close":0.00198761,"volume":0.00126317,"quoteVolume":0.63552206,"weightedAverage":0.00198761},{"date":1465633800,"high":0.00200383,"low":0.00199217,"open":0.00199217,"close":0.00200383,"volume":0.99928894,"quoteVolume":499.17633002,"weightedAverage":0.00200187}]
I tried:
Get Page (url) ---> JSON to XML
However I got this message:
"A JSONObject text must begin with '{' at character 1"
I also realized that my JSON has not any root/enclosing name and I guess this may be the problem.
What can I do to read this JSON as a table? Thanks!