🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Rapidminer and JSON

User: "wirtcal"
New Altair Community Member
Updated by Jocelyn

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!

Find more posts tagged with