Hi Whit.
If you go with the STRUCT approach (earlier in the thread), you should be able to parse your JSON string and send it directly into the structure to fill-in the rows of your table.
<abs contexttype="opengear" id="_top">
<meta>
<params>
<param access="1" maxlength="0" name="Data URL" oid="Data_URL" stateless="true" type="STRING" value="" widget="text"/>
<param access="1" name="Structured Data" oid="struct-data" stateless="true" type="STRUCT_ARRAY" widget="table">
<value>
<subparam access="1" maxlength="0" name="name" suboid="team" type="STRING" value="" widget="default"/>
</value>
</param>
</params>
</meta>
<param expand="true" height="61" left="18" oid="Data_URL" right="17" top="20">
<task tasktype="ogscript">function callback(resultStr)
{
if (resultStr != null)
{
var json = JSON.parse(resultStr);
var a = null;
if (Array.isArray(json))
{
a = json;
}
else
{
a = [];
a.push(json);
}
params.setAllValues('struct-data', a);
}
}
params.resetAllValues('struct-data');
ogscript.asyncPost(params.getValue('Data_URL', 0), null, callback);</task>
</param>
<param bottom="10" expand="true" left="19" oid="struct-data" right="9" showlabel="false" top="94"/>
</abs>
Where my JSON data looks like this:
[{"id":1,"first_name":"Janis","last_name":"Asey","email":"jasey0@fda.gov","gender":"Female","ip_address":"6.21.161.8"},
{"id":2,"first_name":"Kerr","last_name":"Biasini","email":"kbiasini1@vinaora.com","gender":"Male","ip_address":"147.62.107.241"},
{"id":3,"first_name":"Stormy","last_name":"Jillions","email":"sjillions2@intel.com","gender":"Female","ip_address":"78.135.109.53"},
{"id":4,"first_name":"Adelice","last_name":"Sparwell","email":"asparwell3@moonfruit.com","gender":"Female","ip_address":"44.154.98.64"},
{"id":5,"first_name":"Tally","last_name":"Illes","email":"tilles4@springer.com","gender":"Female","ip_address":"119.16.105.242"},
{"id":6,"first_name":"Petronilla","last_name":"Armitage","email":"parmitage5@topsy.com","gender":"Female","ip_address":"83.194.66.133"},
{"id":7,"first_name":"Major","last_name":"Van","email":"mvan6@google.ru","gender":"Male","ip_address":"33.11.63.60"},
{"id":8,"first_name":"Blancha","last_name":"Sclanders","email":"bsclanders7@cbslocal.com","gender":"Female","ip_address":"235.126.116.159"},
{"id":9,"first_name":"Tani","last_name":"Diwell","email":"tdiwell8@taobao.com","gender":"Female","ip_address":"89.211.158.1"},
{"id":10,"first_name":"Marlin","last_name":"Juden","email":"mjuden9@whitehouse.gov","gender":"Male","ip_address":"121.234.50.69"},
{"id":11,"first_name":"Wade","last_name":"Matusson","email":"wmatussona@psu.edu","gender":"Male","ip_address":"184.165.26.1"},
{"id":12,"first_name":"Tad","last_name":"Skey","email":"tskeyb@icq.com","gender":"Male","ip_address":"102.60.253.92"},
{"id":13,"first_name":"Odelinda","last_name":"Ubsdale","email":"oubsdalec@51.la","gender":"Female","ip_address":"65.140.208.184"},
{"id":14,"first_name":"Anderea","last_name":"Cowlishaw","email":"acowlishawd@omniture.com","gender":"Female","ip_address":"203.46.217.203"},
{"id":15,"first_name":"Tadeo","last_name":"Wrist","email":"twriste@linkedin.com","gender":"Male","ip_address":"67.207.1.119"},
{"id":16,"first_name":"Hodge","last_name":"Rishbrook","email":"hrishbrookf@hp.com","gender":"Male","ip_address":"246.46.0.75"},
{"id":17,"first_name":"Daniela","last_name":"Wiggett","email":"dwiggettg@youku.com","gender":"Female","ip_address":"181.44.139.91"},
{"id":18,"first_name":"Joel","last_name":"Wolffers","email":"jwolffersh@umich.edu","gender":"Male","ip_address":"176.178.4.32"},
{"id":19,"first_name":"Ashien","last_name":"Landall","email":"alandalli@themeforest.net","gender":"Female","ip_address":"166.29.153.239"},
{"id":20,"first_name":"Kimbra","last_name":"Corington","email":"kcoringtonj@uol.com.br","gender":"Female","ip_address":"230.52.152.181"},
{"id":21,"first_name":"Roddie","last_name":"Trousdale","email":"rtrousdalek@spiegel.de","gender":"Male","ip_address":"110.21.216.185"},
{"id":22,"first_name":"Nelly","last_name":"Lies","email":"nliesl@harvard.edu","gender":"Female","ip_address":"88.164.178.247"},
{"id":23,"first_name":"Yolande","last_name":"Henriques","email":"yhenriquesm@fema.gov","gender":"Female","ip_address":"82.129.162.110"},
{"id":24,"first_name":"Elysee","last_name":"Ingarfield","email":"eingarfieldn@zdnet.com","gender":"Female","ip_address":"20.174.222.162"},
{"id":25,"first_name":"Brendon","last_name":"Hendrikse","email":"bhendrikseo@wisc.edu","gender":"Male","ip_address":"10.202.62.4"},
{"id":26,"first_name":"Claudianus","last_name":"Bonafant","email":"cbonafantp@sphinn.com","gender":"Male","ip_address":"212.67.17.22"},
{"id":27,"first_name":"Bing","last_name":"Coatsworth","email":"bcoatsworthq@ustream.tv","gender":"Male","ip_address":"247.117.126.117"},
{"id":28,"first_name":"Catharine","last_name":"Paradise","email":"cparadiser@cdc.gov","gender":"Female","ip_address":"233.74.20.72"},
{"id":29,"first_name":"Westbrooke","last_name":"Langlois","email":"wlangloiss@state.gov","gender":"Male","ip_address":"14.80.172.32"},
{"id":30,"first_name":"Lindsay","last_name":"Scotchmer","email":"lscotchmert@e-recht24.de","gender":"Female","ip_address":"215.205.207.128"},
{"id":31,"first_name":"Thedrick","last_name":"Smewings","email":"tsmewingsu@yandex.ru","gender":"Male","ip_address":"42.229.207.66"},
{"id":32,"first_name":"Glenn","last_name":"Holde","email":"gholdev@t-online.de","gender":"Male","ip_address":"109.45.167.2"},
{"id":33,"first_name":"Barny","last_name":"Ghent","email":"bghentw@huffingtonpost.com","gender":"Male","ip_address":"173.109.232.44"},
{"id":34,"first_name":"Maurita","last_name":"Revill","email":"mrevillx@ucoz.com","gender":"Female","ip_address":"102.104.242.151"},
{"id":35,"first_name":"Floria","last_name":"Cockshot","email":"fcockshoty@histats.com","gender":"Female","ip_address":"109.219.59.226"},
{"id":36,"first_name":"Hadleigh","last_name":"Lobbe","email":"hlobbez@theguardian.com","gender":"Male","ip_address":"164.80.228.25"},
{"id":37,"first_name":"Niel","last_name":"McClenaghan","email":"nmcclenaghan10@biblegateway.com","gender":"Male","ip_address":"171.180.144.31"},
{"id":38,"first_name":"Jenn","last_name":"Brixey","email":"jbrixey11@sohu.com","gender":"Female","ip_address":"165.131.195.0"},
{"id":39,"first_name":"Caresa","last_name":"Hammersley","email":"chammersley12@unicef.org","gender":"Female","ip_address":"108.45.18.105"},
{"id":40,"first_name":"Myles","last_name":"Cobson","email":"mcobson13@diigo.com","gender":"Male","ip_address":"208.87.4.183"},
{"id":41,"first_name":"Sydel","last_name":"Vallerine","email":"svallerine14@ning.com","gender":"Female","ip_address":"211.229.45.111"},
{"id":42,"first_name":"Keelia","last_name":"Woehler","email":"kwoehler15@ehow.com","gender":"Female","ip_address":"4.68.248.210"},
{"id":43,"first_name":"Berkie","last_name":"Wooding","email":"bwooding16@cocolog-nifty.com","gender":"Male","ip_address":"76.29.61.62"},
{"id":44,"first_name":"Maurie","last_name":"Ratcliff","email":"mratcliff17@earthlink.net","gender":"Male","ip_address":"58.166.137.154"},
{"id":45,"first_name":"Anders","last_name":"Ege","email":"aege18@usda.gov","gender":"Male","ip_address":"173.56.201.209"},
{"id":46,"first_name":"Vasili","last_name":"Goodliffe","email":"vgoodliffe19@nyu.edu","gender":"Male","ip_address":"103.176.120.95"},
{"id":47,"first_name":"Kalinda","last_name":"Semmence","email":"ksemmence1a@craigslist.org","gender":"Female","ip_address":"88.177.189.228"},
{"id":48,"first_name":"Nollie","last_name":"Dumbellow","email":"ndumbellow1b@behance.net","gender":"Female","ip_address":"20.254.122.58"},
{"id":49,"first_name":"Sasha","last_name":"Ravenscraft","email":"sravenscraft1c@odnoklassniki.ru","gender":"Male","ip_address":"159.192.216.97"}]
Or this:
[{
"name":"John",
"age":30,
"cars": {
"car1":"Ford",
"car2":"BMW",
"car3":"Fiat"
}
},
{
"name":"John",
"age":30,
"cars": {
"car1":"Ford",
"car2":"BMW",
"car3":"Fiat"
}
},
{
"name":"John",
"age":30,
"cars": {
"car1":"Ford",
"car2":"BMW",
"car3":"Fiat"
}
},
{
"name":"John",
"age":30,
"cars": {
"car1":"Ford",
"car2":"BMW",
"car3":"Fiat"
}
}]#DashBoard