Custom JSON Parser ESB Service Type

<!l version="1.0>

<proMonitorData>

<targetTableName>AreaDim</< />targetTableName>

<DBRecord>

<customerkey>7</< />customerkey>

<dbkey>hist92</< />dbkey>

<area>CONTROL</< />area>

<datekey>01/01/07</< />datekey>

<timereported>03:15:01.0</< />timereported>

<totalsize>19.64</< />totalsize>

<percentfull>.1527494908</< />percentfull>

<projectedgrowth>0.00</< />projectedgrowth>

<dateloaded>\n</< />dateloaded>

<timeloaded>\n</< />timeloaded>

</< />DBRecord>

<DBRecord>

<customerkey>7</< />customerkey>

<dbkey>hist92</< />dbkey>

<area>CONTROL</< />area>

<datekey>01/02/07</< />datekey>

<timereported>03:05:01.0</< />timereported>

<totalsize>19.64</< />totalsize>

<percentfull>.1527494908</< />percentfull>

<projectedgrowth>0.00</< />projectedgrowth>

<dateloaded>\n</< />dateloaded>

<timeloaded>\n</< />timeloaded>

</< />DBRecord>

<targetRecCount>2</< />targetRecCount>

</< />proMonitorData>

***************** JSON Format *****************

{"proMonitorData":

{"targetTableName":"AreaDim",

"DBRecord":[ //Create an array of DBRecords

{ "customerkey":"7",

"dbkey":"hist92",

"area":"CONTROL",

"datekey":"01/02/07",

"timereported":"03:15:01.0",

"totalsize":"19.64",

"percentfull":".1527494908",

"projectedgrowth":"0.00",

"dateloaded":null,

"timeloaded":null,

},

{ "customerkey":"7",

"dbkey":"hist92",

"area":"CONTROL",

"datekey":"01/02/07",

"timereported":"03:05:01.0",

"totalsize":"19.64",

"percentfull":".1527494908",

"projectedgrowth":"0.00",

"dateloaded":null,

"timeloaded":null,

}

]]>

"targetTableName":"AreaDim"

}

}

]]>Message was edited by: Arthur Daltas

AreaDimJSON.txt

JSONPaser.zip

SONIC JSON Parser V2.doc