json to query

Communities ColdBox HMVC
1

Anyone have a simple example of using wirebox to validate/convert some JSON to a query?

I’m trying to use this and I can’t figure out what I need to inject.

http://www.coldbox.org/documents/api/WireBoxDocs-1.4.0/wirebox/system/core/conversion/JSON.html

2

is that exposed as a plugin?

it looks like its an interface to serializeJSON(), isJSON(), etc.

3

I ended up just deserializing using CF’s DeserializeJSON function. I’d like to know if anyone thoughts around the right or wrong of doing this verus what Coldbox has?

My source JSON is coming via an API and it seems to have some characters that appear as carriage returns in it that are causing it to be invalid. I’ve tried JSStringFormat and even doing a replace on carriage returns using asc(13) and my JSON still seems to be invalid.

Anyone have a standard way of ‘fixing’ JSON that may contain such items?

4

what does isJSON() tell you?

5

isJSON() is reporting false. If I copy and paste the JSON into http://jsonlint.com/ it shows me where the issue is. The problem is in the description where is has an unneeded carriage return. The problem is no matter what I do this JSON I can’t remove it and I don’t control the system that the JSON is coming from to fix the problem at the source.

I’ve tried stuff like

replace(LOCAL.result.filecontent,’#asc(13)#’,’’,‘ALL’)

and

replace(LOCAL.result.filecontent’\n’,’’,‘ALL’);

with no success. I can’t be the first person so see bad JSON and have to deal with it.

Here is a clip of my JSON.

{
“bugs”: [
{
“id”: 694301000000069000,
“key”: “16”,
“project”: {
“id”: 694301000000014300
},
“flag”: “Internal”,
“title”: “Enrollment issue with programs that refugee enrollment programs”,
“description”: "need a design change to handle enrollment by refugee
",
“reporter_id”: “35597854”,
“reported_person”: “Jonathan Perret”,
“created_time”: “06-01-2014”,
“created_time_format”: “06-01-2014 12:59 AM”,
“created_time_long”: 1401631183000,
“assignee_name”: “Not Assigned”,
“classification”: {
“id”: 694301000000016000,
“type”: “OtherBug”
},
“severity”: {
“id”: 694301000000007000,
“type”: “Major”
},
“status”: {
“id”: 694301000000007000,
“type”: “Closed”
},
“closed”: true,
“reproducible”: {
“id”: 694301000000016000,
“type”: “Always”
},
“module”: {
“id”: 694301000000016100,
“name”: “RMS”
},
“link”: {
“self”: {
“url”: “https://projectsapi.zoho.com/restapi/portal/37158570/projects/694301000000014351/bugs/694301000000069001/”
},
“timesheet”: {
“url”: “https://projectsapi.zoho.com/restapi/portal/37158570/projects/694301000000014351/bugs/694301000000069001/logs/”
}
}
}
]
}

6

try chr(13)

7

also http://help.adobe.com/livedocs/coldfusion/8/htmldocs/help.html?content=functions_s_14.html

8

Already tried stripcr with no luck. I clearly should have been using chr.

Interesting thing is if I do a

writeoutput(find(chr(13),LOCAL.result.filecontent));
LOCAL.test1=replace(LOCAL.result.filecontent,chr(13),’’,‘ALL’);
writeoutput(find(LOCAL.test1,chr(13)));
writeoutput(LOCAL.test1);

The first find does indeed find a CR and the replace does replace any it finds because the second find returns 0. But when I dump out the JSON I can clearly see it in the same place that JSONLint is complaining about.

9

try chr(13)&chr(10)

10

replaced chr(10) and still have issue.

11

or try rereplace(“str”,"\n",“all”,“all”) or rereplace(“str”,"\r",“all”,“all”)

12

oops - you know what I mean

13

I’ve tried it all.

LOCAL.test1=replace(LOCAL.result.filecontent,chr(13),’’,‘ALL’);
LOCAL.test2=replace(LOCAL.test1,’\n’,’’,‘ALL’);
LOCAL.test3=replace(LOCAL.test2,chr(10),’’,‘ALL’);
LOCAL.test4=replace(LOCAL.test3,’\r’,’’,‘ALL’);
writeoutput(isJSON(LOCAL.test4)); // result is no
writeoutput(LOCAL.test4); //I can still see the same result in the JSON

14

REreplace

15

no difference

LOCAL.test1=replace(LOCAL.result.filecontent,chr(13),’’,‘ALL’);
LOCAL.test2=rereplace(LOCAL.test1,’\n’,’’,‘ALL’);
LOCAL.test3=replace(LOCAL.test2,chr(10),’’,‘ALL’);
LOCAL.test4=rereplace(LOCAL.test3,’\r’,’’,‘ALL’);
writeoutput(isJSON(LOCAL.test4));
writeoutput(LOCAL.test4);

if I do a JSStringFormat on the JSON, I see the \n where the problem is. When I do a replace \n before I run it through JSStringFormat I don’t see the \n but either way problem still exists., So it’s something else blowing up the JSON.

16

upload the json file somewhere or point to the url where you’re getting it from.

17

Jonathan posted the json earlier in the thread, but it got a little garbled. Here is the pastbin: http://pastebin.com/8ZFgSvsM
You can see the line break on line# 11-12

18

Have you tried

LOCAL.test3=replace(LOCAL.test2,char(13) & chr(10),’’,‘ALL’);

19

Jonathan,

Again, this works for me, so I’m not sure what the issue is:

LOCAL.httpService = new http();
LOCAL.httpService.setMethod(“get”);
LOCAL.httpService.setUrl(“https://projectsapi.zoho.com/restapi/portal/37158570/projects/694301000000014351/bugs/?AUTHTOKEN=4cbb65b3bf10264f4e283cc19c55e8b8”);
LOCAL.result = LOCAL.httpService.send().getPrefix();
WriteDump(DeSerializeJSON(LOCAL.result.filecontent));
abort;

20

Must be some in my version of CF because I get, JSON parsing failure at character 7721:‘J’ . I copied your code to make 100% sure.