Easy JSON Output problem

[Braeu]

Hi,

who can I create an easy JSON Output statement? I need a message like

{"name":"mueller";"userId":"0815"}

When I use the JSON Output Step, I recieve

{"element":[{"name":"mueller"},{"user_id":"0815"}]}

I put in the step:
General/Json bloc name -> element
General/Nr rows in a bloc -> 2
General/Output Element -> element
Fields/name -> mueller
Fields/userId -> 0815

Is there a easy way to use the step or shut I build the statement via string-functions?

Thank you!

Braeu

[m0rganic]

I've got exactly the same problem and would appreciate any help if there's any out there.

I'm using the latest pdi-4.1.0.stable release.

[Braeu]

OK, here are a 90% solution for the "Modified Java Script Value" Step, the procedure I found in the Internet for serialise JS Objects:

var JSON = JSON || {};
// implement JSON.stringify serialization  
JSON.stringify = JSON.stringify || function (obj) {  
    var t = typeof (obj);  
    if (t != "object" || obj === null) {  
        // simple data type  
        if (t == "string") obj = '"'+obj+'"';  
        return String(obj);  
    }  
    else {  
        // recurse array or object  
        var n, v, json = [], arr = (obj && obj.constructor == Array);  
        for (n in obj) {  
            v = obj[n]; t = typeof(v);  
            if (t == "string") v = '"'+v+'"';  
            else if (t == "object" && v !== null) v = JSON.stringify(v);  
            json.push((arr ? "" : '"' + n + '":') + String(v));  
        }  
        return (arr ? "[" : "{") + String(json) + (arr ? "]" : "}");  
    }  
};  


var oElement = new Object();
oElement.name="Mueller";
oElement.userid="0815";

var element = JSON.stringify(oElement);

work's perfect and produced

{"name":"mueller";"userId":"0815"}

When I exchange the constants "Mueller" and "0815" with my Inputfield from the previous step, it does not work!

var JSON = JSON || {};
// implement JSON.stringify serialization  
JSON.stringify = JSON.stringify || function (obj) {  
    var t = typeof (obj);  
    if (t != "object" || obj === null) {  
        // simple data type  
        if (t == "string") obj = '"'+obj+'"';  
        return String(obj);  
    }  
    else {  
        // recurse array or object  
        var n, v, json = [], arr = (obj && obj.constructor == Array);  
        for (n in obj) {  
            v = obj[n]; t = typeof(v);  
            if (t == "string") v = '"'+v+'"';  
            else if (t == "object" && v !== null) v = JSON.stringify(v);  
            json.push((arr ? "" : '"' + n + '":') + String(v));  
        }  
        return (arr ? "[" : "{") + String(json) + (arr ? "]" : "}");  
    }  
};  


var oElement = new Object();
oElement.name=Kontoname;
oElement.userid=userId;
alert ("Name "+oElement.name+" UserID "+oElement.userid);

var element = JSON.stringify(oElement);

The Alertbox show me the values, but I recieve

{"name":"";"userId":""}

Now my question: Why?

Braeu

[Braeu]

...
var oElement = new Object();
oElement.name=Kontoname.toString();
oElement.userid=userId.toString();
...

solve the problem.

THX Braeu