Page 1 of 2

Mapping Json to Grid

Posted: Tue Jun 19, 2012 12:30 pm
by Derrick Johnson

I am trying to map the output to a grid but am having problems. The dates are random as they are JSON output.

{
"Doctype": "FastSearchResponse",
"Dates": {
"2012-09-07": {
"cur": "USD",
"min": 1132.43
},
"2012-08-06": {
"cur": "USD",
"min": 1242.43
},
"2012-06-23": {
"cur": "USD",
"min": 1212.83
},
"2012-07-03": {
"cur": "USD",
"min": 1179.43
},
"2012-07-09": {
"cur": "USD",
"min": 1180.83
},
"2012-08-24": {
"cur": "USD",
"min": 1132.43
},
"2012-08-19": {
"cur": "USD",
"min": 1132.43
},
"2012-06-30": {
"cur": "USD",
"min": 1212.83
},
"2012-07-10": {
"cur": "USD",
"min": 1180.83
},
"2012-07-13": {
"cur": "USD",
"min": 1250.43
},
"2012-09-06": {
"cur": "USD",
"min": 1100.43
},
"2012-07-05": {
"cur": "USD",
"min": 1124.43
},
"2012-07-20": {
"cur": "USD",
"min": 1373.83
},
"2012-09-03": {
"cur": "USD",
"min": 1100.43
},
"2012-08-31": {
"cur": "USD",
"min": 1132.43
},
"2012-07-11": {
"cur": "USD",
"min": 1179.43
},
"2012-08-22": {
"cur": "USD",
"min": 1100.43
},
"2012-07-21": {
"cur": "USD",
"min": 1373.83
},
"2012-08-25": {
"cur": "USD",
"min": 1132.43
},
"2012-07-02": {
"cur": "USD",
"min": 1179.43
},
"2012-09-01": {
"cur": "USD",
"min": 1132.43
},
"2012-07-12": {
"cur": "USD",
"min": 1212.83
},
"2012-07-19": {
"cur": "USD",
"min": 1341.83
},
"2012-08-30": {
"cur": "USD",
"min": 1100.43
},
"2012-08-23": {
"cur": "USD",
"min": 1100.43
},
"2012-07-04": {
"cur": "USD",
"min": 1179.43
},
"2012-08-10": {
"cur": "USD",
"min": 1340.43
},
"2012-08-27": {
"cur": "USD",
"min": 1100.43
},
"2012-08-13": {
"cur": "USD",
"min": 1169.47
},
"2012-08-04": {
"cur": "USD",
"min": 1384.43
},
"2012-07-18": {
"cur": "USD",
"min": 1341.83
},
"2012-06-19": {
"cur": "USD",
"min": 1179.43
},
"2012-09-05": {
"cur": "USD",
"min": 1100.43
},
"2012-08-11": {
"cur": "USD",
"min": 1273.43
},
"2012-07-31": {
"cur": "USD",
"min": 1308.43
},
"2012-08-03": {
"cur": "USD",
"min": 1384.43
},
"2012-07-17": {
"cur": "USD",
"min": 1273.43
},
"2012-06-22": {
"cur": "USD",
"min": 1179.43
},
"2012-07-16": {
"cur": "USD",
"min": 1341.83
},
"2012-07-08": {
"cur": "USD",
"min": 1185.72
},
"2012-06-26": {
"cur": "USD",
"min": 1147.43
},
"2012-08-16": {
"cur": "USD",
"min": 1100.43
},
"2012-07-28": {
"cur": "USD",
"min": 1439.43
},
"2012-08-12": {
"cur": "USD",
"min": 1273.43
},
"2012-07-07": {
"cur": "USD",
"min": 1322.83
},
"2012-07-15": {
"cur": "USD",
"min": 1373.83
},
"2012-08-14": {
"cur": "USD",
"min": 1124.43
},
"2012-08-29": {
"cur": "USD",
"min": 1100.43
},
"2012-08-26": {
"cur": "USD",
"min": 1132.43
},
"2012-06-20": {
"cur": "USD",
"min": 1185.72
},
"2012-07-14": {
"cur": "USD",
"min": 1340.43
},
"2012-09-04": {
"cur": "USD",
"min": 1100.43
},
"2012-08-20": {
"cur": "USD",
"min": 1124.43
},
"2012-06-24": {
"cur": "USD",
"min": 1165.83
},
"2012-08-02": {
"cur": "USD",
"min": 1407.43
},
"2012-08-05": {
"cur": "USD",
"min": 1384.43
},
"2012-08-09": {
"cur": "USD",
"min": 1308.43
},
"2012-07-06": {
"cur": "USD",
"min": 1212.83
},
"2012-09-08": {
"cur": "USD",
"min": 1132.43
},
"2012-06-25": {
"cur": "USD",
"min": 1179.43
},
"2012-07-30": {
"cur": "USD",
"min": 1242.43
},
"2012-08-28": {
"cur": "USD",
"min": 1100.43
},
"2012-07-01": {
"cur": "USD",
"min": 1212.83
},
"2012-07-25": {
"cur": "USD",
"min": 1346.72
},
"2012-06-28": {
"cur": "USD",
"min": 1180.83
},
"2012-08-18": {
"cur": "USD",
"min": 1155.43
},
"2012-06-21": {
"cur": "USD",
"min": 1218.43
},
"2012-08-21": {
"cur": "USD",
"min": 1100.43
},
"2012-08-01": {
"cur": "USD",
"min": 1440.83
},
"2012-07-24": {
"cur": "USD",
"min": 1273.43
},
"2012-08-07": {
"cur": "USD",
"min": 1242.43
},
"2012-08-15": {
"cur": "USD",
"min": 1100.43
},
"2012-06-27": {
"cur": "USD",
"min": 1147.43
},
"2012-08-08": {
"cur": "USD",
"min": 1273.43
},
"2012-07-26": {
"cur": "USD",
"min": 1341.83
},
"2012-07-29": {
"cur": "USD",
"min": 1439.43
},
"2012-07-23": {
"cur": "USD",
"min": 1341.83
},
"2012-08-17": {
"cur": "USD",
"min": 1155.43
},
"2012-07-22": {
"cur": "USD",
"min": 1305.43
},
"2012-09-02": {
"cur": "USD",
"min": 1132.43
},
"2012-07-27": {
"cur": "USD",
"min": 1273.43
},
"2012-06-29": {
"cur": "USD",
"min": 1210.43
}
},
"Version": 1.1
}


Mapping Json to Grid

Posted: Tue Jun 19, 2012 12:38 pm
by maxkatz

What's exactly not working?


Mapping Json to Grid

Posted: Tue Jun 19, 2012 12:57 pm
by Derrick Johnson

Max,
I am returning data and would like each date to iterate to a separate row, with the price in the next column.

IE,
06/12/2012 $500


Mapping Json to Grid

Posted: Tue Jun 19, 2012 1:31 pm
by maxkatz

You can try this.
Drag and drop a grid component.
Add one row (two total now)
Span the first row


Mapping Json to Grid

Posted: Tue Jun 19, 2012 10:43 pm
by Derrick Johnson

Still having problems.

I have a json response called airprice and need to parse the first part of the response.

ORD,MDW,MKE

I just need ORD.

What javascript would I need to put in?


Mapping Json to Grid

Posted: Tue Jun 19, 2012 10:47 pm
by maxkatz

Can you post a sample JSON and show what exactly you want to display and how? Maybe create a static page with data and post the link.


Mapping Json to Grid

Posted: Tue Jun 19, 2012 11:09 pm
by Derrick Johnson

Mapping Json to Grid

Posted: Tue Jun 19, 2012 11:22 pm
by maxkatz

Please make the app public.


Mapping Json to Grid

Posted: Wed Jun 20, 2012 12:08 am
by Derrick Johnson

Mapping Json to Grid

Posted: Wed Jun 20, 2012 12:09 am
by Derrick Johnson

{
"rid": null,
"input_text": "trip to chicago",
"api_reply": {
"ean": {
"longitude": "-87.65005",
"latitude": "41.85003"
},
"Locations": [
{
"Next": 11,
"Index": 0,
"Home": "Default"
},
{
"Name": "Chicago, Illinois, United States (GID=4887398)",
"Geoid": 4887398,
"Actions": [
"Get There"
],
"Country": "US",
"Latitude": 41.85003,
"Airports": "ORD,MDW,MKE,DTW",
"Index": 11,
"All Airports Code": "CHI",
"Longitude": -87.65005,
"Type": "City"
}
],
"Say It": "flights to Chicago, Illinois"
},
"status": true,
"ver": "2999",
"message": "Successful Parse"
}