standard JSON data format support in DHTMLx products

Suite and Optimus Suite 5
#1

Hi all,
I have come to know that standard (json.org/) JSON format is NOT supported.

Can someone tell me if this is 100% true? I totally understand that dhtmlxConnector is available. But, the reality is that UI developers are pulling data via http GET and Web Services. We (UI team) do not have option to use the dhtmlxConnector product to query the data directly. Http Get and Web Services are returning standard JSON formatted data as described in json.org.

see attached sample JSON data file.

Any help/direction will be greatly appreciated.

Thank you
Kamlesh

below is the data format: This forum did not allow me to upload any files.
{
“res”: {
“record”: [
{
“status”: “Current”,
“lastModifiedDate”: “11/02/2011 03:46”,
“emailAddress”: "demo@noplace.com",
“fullName”: “Demo user for startup”,
“entryID”: 1,
“groups”: “Administrator”,
“licenseType”: “Fixed”,
“notificationMethod”: “Alert”,
“loginName”: “Demo”
},
{
“status”: “Current”,
“lastModifiedDate”: “11/02/2011 03:46”,
“emailAddress”: "system@noplace.com",
“fullName”: “system account”,
“entryID”: 2,
“groups”: “Administrator”,
“licenseType”: “Fixed”,
“notificationMethod”: “Alert”,
“loginName”: “system”
},
{
“status”: “Current”,
“lastModifiedDate”: “01/17/2012 01:25”,
“emailAddress”: "kpatel@noplace.com",
“fullName”: “Test Use123r”,
“entryID”: 3,
“groups”: “Customize;Administrator”,
“licenseType”: “Fixed”,
“notificationMethod”: “Alert”,
“loginName”: “kpatel”
},
{
“status”: “Current”,
“lastModifiedDate”: “11/02/2011 04:58”,
“emailAddress”: "test123@noplace.com",
“fullName”: “test123”,
“entryID”: 4,
“groups”: {},
“licenseType”: “Read”,
“notificationMethod”: “Alert”,
“loginName”: “test123”
},
{
“status”: “Current”,
“lastModifiedDate”: “01/12/2012 09:39”,
“emailAddress”: "kv@noplace.com",
“fullName”: “Kevin James”,
“entryID”: 5,
“groups”: {},
“licenseType”: “Read”,
“notificationMethod”: “Alert”,
“loginName”: “kevin”
},
{
“status”: “Current”,
“lastModifiedDate”: “01/18/2012 09:24”,
“emailAddress”: "xmltest123@noplace.com",
“fullName”: “XML Test Use12345454”,
“entryID”: 6,
“groups”: {},
“licenseType”: “Read”,
“notificationMethod”: “Email”,
“loginName”: “xmltest123”
},
{
“status”: “Disabled”,
“lastModifiedDate”: “01/18/2012 09:24”,
“emailAddress”: "kklkd2424234234@noplace.com",
“fullName”: “XML Test Use123r”,
“entryID”: 7,
“groups”: {},
“licenseType”: “Read”,
“notificationMethod”: “Email”,
“loginName”: “kklkd2424234234”
},
{
“status”: “Current”,
“lastModifiedDate”: “01/18/2012 09:24”,
“emailAddress”: "user201201181@noplace.com",
“fullName”: “user201201181”,
“entryID”: 8,
“groups”: {},
“licenseType”: “Read”,
“notificationMethod”: “Email”,
“loginName”: “user201201181”
},
{
“status”: “Current”,
“lastModifiedDate”: “01/18/2012 09:24”,
“emailAddress”: "xmlgwtestqeqweqqw@noplace.com",
“fullName”: “XML Gatewayqweqwee Test User”,
“entryID”: 9,
“groups”: {},
“licenseType”: “Read”,
“notificationMethod”: “Email”,
“loginName”: “xmlgwtestqeqweqqw”
},
{
“status”: “Current”,
“lastModifiedDate”: “01/18/2012 09:24”,
“emailAddress”: "user000101@noplace.com",
“fullName”: “user000101”,
“entryID”: 8,
“groups”: {},
“licenseType”: “Read”,
“notificationMethod”: “Email”,
“loginName”: “user000101”
},
{
“status”: “Current”,
“lastModifiedDate”: “01/18/2012 09:24”,
“emailAddress”: "user000102@noplace.com",
“fullName”: “user000102”,
“entryID”: 9,
“groups”: {},
“licenseType”: “Read”,
“notificationMethod”: “Email”,
“loginName”: “user000102”
},
{
“status”: “Current”,
“lastModifiedDate”: “01/18/2012 09:24”,
“emailAddress”: "user000103@noplace.com",
“fullName”: “user000103”,
“entryID”: 10,
“groups”: {},
“licenseType”: “Read”,
“notificationMethod”: “Email”,
“loginName”: “user000103”
}
]
}
}

#2

What I’ve seen is that JSON support is mostly not as documented as the XML support.
In addition there is a lack of JSON processor parseHead that I’m working on right now.

#3

Hi,

I’m currently facing asimilar problem.

I’ve created a grid and also set ColumnIds. I expected that I could match these IDs with my Json data.

Example:

...
grid.setColumnIds(a,b,c);
...

and the JSON looks like:

{
	rows : [{
			id : 1,
			data : [
				a:"123",
				b:"xykdf"
                                c:"blidbla"]
		}
	]
}

but this doesn’t work. I have to change the JSON to:

{
	rows : [{
			id : 1,
			data : [
				"123",
				"xykdf"
                                "blidbla"]
		}
	]
}

Which means I have to write an own json serializer :open_mouth:

P.S.: I was just browsing through the dhmltx touch documentation and discovered that the json syntax there is different from the dhtmlx one.
I was hoping to create one interface for data retrieval for dhtmlx and dhtmlx touch. But that doesn’t seam to work. Am I right?!