Mapping Json to Grid

[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
}

[maxkatz]

What's exactly not working?

[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

[maxkatz]

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

[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?

[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.

[Derrick Johnson]

http://tiggzi.com/view/22d74197-9f20-...

[maxkatz]

Please make the app public.

[Derrick Johnson]

http://tiggzi.com/view/22d74197-9f20-...

It is public.

[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"
}