Databases
StackOverflow2013
Postsdbo
POHow to fetch data from this json
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to fetch data from this json
    text
    copied!<p>I want this data to be displayed in the tableview . can anyone tell me how to take data in the dictionary or array and display in the table? the data is shown as under </p> <p>I want to display <code>city</code> and <code>custno</code></p> <pre><code>{ "Status": 200, "data": [ { "dispatch": "11111", "locname": "Sample Company Location 1", "add1": "226 Engleman Street", "city": "Bardstown", "state": "KY", "zip": "40004", "contacts": [ { "id": "1", "custno": "0000235", "locno": "00001", "salutation": "Mr.", "jobtitle": "IT Manager", "locktime": "", "lockby": "" }, { "id": "11", "custno": "0000235", "locno": "00001", "contact": "Greg C", "extension": "205", "salutation": "Mr. ", "jobtitle": "President", "locktime": null, "lockby": null }, { "id": "12", "custno": "0000235", "locno": "00001", "extension": "206", "salutation": "Mr.", "jobtitle": "Parts Manager", "locktime": null, "lockby": null }, { "id": "13", "custno": "0000235", "locno": "00001", "extension": "202", "salutation": "Mr.", "jobtitle": "Service Manager", "locktime": "", "lockby": "" } ], "locationnotes": "5/20/2010 9:32:06 PM - Updated Information1111111", "custno": "0000235", "locno": "00001", "calledinby": "Teresa", "serviceagrno": "", "dispatchnotes": "This is a test dispatch", "pastcustomernotes": "", "pasttechnotes": [], "status": "Pending", "locationimage": "/images/content/2t_1318687848_100x100.gif", "pmstatus": "Yes" }, { "dispatch": "4", "locname": "Sample Company Location 1", "add1": "226 Engleman Street", "city": "Bardstown", "state": "KY", "zip": "40004", "contacts": [ { "id": "1", "custno": "0000235", "locno": "00001", "extension": "200", "salutation": "Mr.", "jobtitle": "IT Manager", "locktime": "", "lockby": "" }, { "id": "11", "custno": "0000235", "locno": "00001", "phonefax": "555-555-1002", "extension": "205", "salutation": "Mr. ", "jobtitle": "President", "locktime": null, "lockby": null }, { "id": "12", "custno": "0000235", "locno": "00001", "extension": "206", "salutation": "Mr.", "jobtitle": "Parts Manager", "locktime": null, "lockby": null }, { "id": "13", "custno": "0000235", "locno": "00001", "extension": "202", "salutation": "Mr.", "jobtitle": "Service Manager", "locktime": "", "lockby": "" } ], "locationnotes": "5/20/2010 9:32:06 PM - Updated Information1111111", "custno": "0000235", "locno": "00001", "calledinby": "Teresa", "serviceagrno": null, "dispatchnotes": "11/3/2011 7:59 - This is a sample ATM call.", "pastcustomernotes": "", "pasttechnotes": [], "status": "Pending", "locationimage": "/images/content/2t_1318687848_100x100.gif", "pmstatus": "No" }, { "dispatch": "5", "locname": "Sample Company Location 1", "add1": "226 Engleman Street", "city": "Bardstown", "state": "KY", "zip": "40004", "contacts": [ { "id": "1", "custno": "0000235", "locno": "00001", "contact": "Michael B", "email": "michael@bonzahouse.com", "phoneoffice": "502-555-1000", "phonemobile": "502-555-0769", "phonefax": "555-555-1002", "extension": "200", "salutation": "Mr.", "jobtitle": "IT Manager", "locktime": "", "lockby": "" }, { "id": "11", "custno": "0000235", "locno": "00001", "extension": "205", "salutation": "Mr. ", "jobtitle": "President", "locktime": null, "lockby": null }, { "id": "12", "custno": "0000235", "locno": "00001", "extension": "206", "salutation": "Mr.", "jobtitle": "Parts Manager", "locktime": null, "lockby": null }, { "id": "13", "custno": "0000235", "locno": "00001", "extension": "202", "salutation": "Mr.", "jobtitle": "Service Manager", "locktime": "", "lockby": "" } ], "locationnotes": "5/20/2010 9:32:06 PM - Updated Information1111111", "custno": "0000235", "locno": "00001", "calledinby": "", "serviceagrno": null, "dispatchnotes": "", "pastcustomernotes": "", "pasttechnotes": [], "status": "Pending", "locationimage": "/images/content/2t_1318687848_100x100.gif", "pmstatus": "Yes" } ] </code></pre> <p>}</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload