<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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&api_key=aquqdcmfd4u7rd73pxqjwy2hf86cc928xxdwfq2b&sig=d1e3832209cd33b012dcbf753990f49266bc6b984f6d125aa5ce885549a69330
[{
"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
}]
