Subscribe Bookmark RSS Feed

what kind of data is this and how to import the date and value as columns

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

Hi all,

I have a link for raw data and when I paste it to jmp internet open window I receive hundreds of column headers but empty rows.

Does anybody know what kind of data is this and how to import it to JMP as a data table?

http://connect.reviewpro.com/v1/lodging/index/daily?pid=300929&rt=VALUE&fd=2015-01-01&td=2015-06-09&...

[{2015-06-10_16-28-45.png



   
"name": "XXXXXXX",
   
"data": {
       
"rating_type": "VALUE",
       
"date_range_from": "2015-01-01",
       
"date_range_to": "2015-06-09",
       
"value": [{
           
"value": 0.874,
           
"timestamp": 1420066800000
       
}, {
           
"value": 0.874,
           
"timestamp": 1420153200000
       
}, {
           
"value": 0.874,
           
"timestamp": 1420239600000
       
}, {
           
"value": 0.874,
           
"timestamp": 1420326000000
       
}, {
           
"value": 0.874,
           
"timestamp": 1420412400000
       
}, {
           
"value": 0.874,
           
"timestamp": 1420498800000
       
}, {
           
"value": 0.874,
           
"timestamp": 1420585200000
       
}, {
           
"value": 0.874,
           
"timestamp": 1420671600000
       
}, {
           
"value": 0.874,
           
"timestamp": 1420758000000
       
}, {
           
"value": 0.874,
           
"timestamp": 1420844400000
       
}, {
           
"value": 0.874,
           
"timestamp": 1420930800000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421017200000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421103600000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421190000000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421276400000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421362800000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421449200000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421535600000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421622000000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421708400000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421794800000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421881200000
       
}, {
           
"value": 0.874,
           
"timestamp": 1421967600000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422054000000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422140400000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422226800000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422313200000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422399600000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422486000000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422572400000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422658800000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422745200000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422831600000
       
}, {
           
"value": 0.874,
           
"timestamp": 1422918000000
       
}, {
           
"value": 0.874,
           
"timestamp": 1423004400000
       
}, {
           
"value": 0.874,
           
"timestamp": 1423090800000
       
}, {
           
"value": 0.874,
           
"timestamp": 1423177200000
       
}, {
           
"value": 0.874,
           
"timestamp": 1423263600000
       
}, {
           
"value": 0.874,
           
"timestamp": 1423350000000
       
}, {
           
"value": 0.874,
           
"timestamp": 1423436400000
       
}, {
           
"value": 0.874,
           
"timestamp": 1423522800000
       
}, {
           
"value": 0.877,
           
"timestamp": 1423609200000
       
}, {
           
"value": 0.877,
           
"timestamp": 1423695600000
       
}, {
           
"value": 0.877,
           
"timestamp": 1423782000000
       
}, {
           
"value": 0.877,
           
"timestamp": 1423868400000
       
}, {
           
"value": 0.877,
           
"timestamp": 1423954800000
       
}, {
           
"value": 0.877,
           
"timestamp": 1424041200000
       
}, {
           
"value": 0.877,
           
"timestamp": 1424127600000
       
}, {
           
"value": 0.877,
           
"timestamp": 1424214000000
       
}, {
           
"value": 0.854,
           
"timestamp": 1424300400000
       
}, {
           
"value": 0.854,
           
"timestamp": 1424386800000
       
}, {
           
"value": 0.854,
           
"timestamp": 1424473200000
       
}, {
           
"value": 0.854,
           
"timestamp": 1424559600000
       
}, {
           
"value": 0.854,
           
"timestamp": 1424646000000
       
}, {
           
"value": 0.854,
           
"timestamp": 1424732400000
       
}, {
           
"value": 0.854,
           
"timestamp": 1424818800000
       
}, {
           
"value": 0.854,
           
"timestamp": 1424905200000
       
}, {
           
"value": 0.854,
           
"timestamp": 1424991600000
       
}, {
           
"value": 0.854,
           
"timestamp": 1425078000000
       
}, {
           
"value": 0.852,
           
"timestamp": 1425164400000
       
}, {
           
"value": 0.852,
           
"timestamp": 1425250800000
       
}, {
           
"value": 0.852,
           
"timestamp": 1425337200000
       
}, {
           
"value": 0.852,
           
"timestamp": 1425423600000
       
}, {
           
"value": 0.852,
           
"timestamp": 1425510000000
       
}, {
           
"value": 0.852,
           
"timestamp": 1425596400000
       
}, {
           
"value": 0.852,
           
"timestamp": 1425682800000
       
}, {
           
"value": 0.852,
           
"timestamp": 1425769200000
       
}, {
           
"value": 0.852,
           
"timestamp": 1425855600000
       
}, {
           
"value": 0.852,
           
"timestamp": 1425942000000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426028400000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426114800000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426201200000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426287600000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426374000000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426460400000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426546800000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426633200000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426719600000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426806000000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426892400000
       
}, {
           
"value": 0.852,
           
"timestamp": 1426978800000
       
}, {
           
"value": 0.852,
           
"timestamp": 1427065200000
       
}, {
           
"value": 0.852,
           
"timestamp": 1427151600000
       
}, {
           
"value": 0.852,
           
"timestamp": 1427238000000
       
}, {
           
"value": 0.858,
           
"timestamp": 1427324400000
       
}, {
           
"value": 0.858,
           
"timestamp": 1427410800000
       
}, {
           
"value": 0.858,
           
"timestamp": 1427497200000
       
}, {
           
"value": 0.858,
           
"timestamp": 1427583600000
       
}, {
           
"value": 0.858,
           
"timestamp": 1427666400000
       
}, {
           
"value": 0.858,
           
"timestamp": 1427752800000
       
}, {
           
"value": 0.858,
           
"timestamp": 1427839200000
       
}, {
           
"value": 0.858,
           
"timestamp": 1427925600000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428012000000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428098400000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428184800000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428271200000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428357600000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428444000000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428530400000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428616800000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428703200000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428789600000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428876000000
       
}, {
           
"value": 0.858,
           
"timestamp": 1428962400000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429048800000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429135200000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429221600000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429308000000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429394400000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429480800000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429567200000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429653600000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429740000000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429826400000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429912800000
       
}, {
           
"value": 0.858,
           
"timestamp": 1429999200000
       
}, {
           
"value": 0.858,
           
"timestamp": 1430085600000
       
}, {
           
"value": 0.859,
           
"timestamp": 1430172000000
       
}, {
           
"value": 0.859,
           
"timestamp": 1430258400000
       
}, {
           
"value": 0.859,
           
"timestamp": 1430344800000
       
}, {
           
"value": 0.859,
           
"timestamp": 1430431200000
       
}, {
           
"value": 0.859,
           
"timestamp": 1430517600000
       
}, {
           
"value": 0.859,
           
"timestamp": 1430604000000
       
}, {
           
"value": 0.859,
           
"timestamp": 1430690400000
       
}, {
           
"value": 0.859,
           
"timestamp": 1430776800000
       
}, {
           
"value": 0.859,
           
"timestamp": 1430863200000
       
}, {
           
"value": 0.859,
           
"timestamp": 1430949600000
       
}, {
           
"value": 0.859,
           
"timestamp": 1431036000000
       
}, {
           
"value": 0.859,
           
"timestamp": 1431122400000
       
}, {
           
"value": 0.859,
           
"timestamp": 1431208800000
       
}, {
           
"value": 0.859,
           
"timestamp": 1431295200000
       
}, {
           
"value": 0.867,
           
"timestamp": 1431381600000
       
}, {
           
"value": 0.867,
           
"timestamp": 1431468000000
       
}, {
           
"value": 0.866,
           
"timestamp": 1431554400000
       
}, {
           
"value": 0.866,
           
"timestamp": 1431640800000
       
}, {
           
"value": 0.866,
           
"timestamp": 1431727200000
       
}, {
           
"value": 0.873,
           
"timestamp": 1431813600000
       
}, {
           
"value": 0.873,
           
"timestamp": 1431900000000
       
}, {
           
"value": 0.873,
           
"timestamp": 1431986400000
       
}, {
           
"value": 0.873,
           
"timestamp": 1432072800000
       
}, {
           
"value": 0.873,
           
"timestamp": 1432159200000
       
}, {
           
"value": 0.873,
           
"timestamp": 1432245600000
       
}, {
           
"value": 0.874,
           
"timestamp": 1432332000000
       
}, {
           
"value": 0.874,
           
"timestamp": 1432418400000
       
}, {
           
"value": 0.874,
           
"timestamp": 1432504800000
       
}, {
           
"value": 0.874,
           
"timestamp": 1432591200000
       
}, {
           
"value": 0.874,
           
"timestamp": 1432677600000
       
}, {
           
"value": 0.874,
           
"timestamp": 1432764000000
       
}, {
           
"value": 0.875,
           
"timestamp": 1432850400000
       
}, {
           
"value": 0.875,
           
"timestamp": 1432936800000
       
}, {
           
"value": 0.884,
           
"timestamp": 1433023200000
       
}, {
           
"value": 0.872,
           
"timestamp": 1433109600000
       
}, {
           
"value": 0.881,
           
"timestamp": 1433196000000
       
}, {
           
"value": 0.884,
           
"timestamp": 1433282400000
       
}, {
           
"value": 0.884,
           
"timestamp": 1433368800000
       
}, {
           
"value": 0.884,
           
"timestamp": 1433455200000
       
}, {
           
"value": 0.886,
           
"timestamp": 1433541600000
       
}, {
           
"value": 0.9,
           
"timestamp": 1433628000000
       
}, {
           
"value": 0.9,
           
"timestamp": 1433714400000
       
}, {
           
"value": 0.908,
           
"timestamp": 1433800800000
       
}]
   
},
   
"pid": 300929
}]

1 REPLY
XanGregg

Staff

Joined:

Jun 23, 2011

Looks like JSON. You might try the JSON parsing JSL functions I wrote a few months ago:

JSON Parsing Functions