You seem to have a lot of mixed things going on here.
You have defined the function jsonEncode, but you're not using it anywhere.
You're trying to set properties for some undefined Object called json on these lines: json.state = current.state; Your script will be breaking here.
But you don't need to define any JSON here if you're using setStringParameter(). The JSON should be in the Content of your post record.
This is what I think you want to do:
function createticket() {
var obj = {
"state":String(current.state),
"short_description":String(current.short_description),
"description":String(current.description),
"u_caller":String(current.u_raised_by)
};
var json = JSON.stringify(obj);
try {
var r = new sn_ws.RESTMessageV2('Fruition API', 'post');
r.setRequestBody(json);
var response = r.execute();
var responseBody = response.getBody();
var httpStatus = response.getStatusCode();
gs.log('Response Body :' + responseBody);
gs.log('Request: ' + r.getRequestBody()); // see what was sent
}
catch(ex) {
var message = ex.getMessage();
}
}
But there is another way you can do it.
You can define your request body in the Content field on the post HTTP Method record. In the content you define placeholders for your parameters using ${parameter}.
So your Content field would have this in it:
{"state":"${state}","short_description":"${short_description}","description":"${description}","u_caller":"${u_caller}"};
Then your script would be:
function createticket() {
try {
var r = new sn_ws.RESTMessageV2('Fruition API', 'post');
r.setStringParameter("short_description",current.short_description);
r.setStringParameter("state",current.state);
r.setStringParameter("description",current.description);
r.setStringParameter("u_caller",current.u_raised_by);
var response = r.execute();
var responseBody = response.getBody();
var httpStatus = response.getStatusCode();
gs.log('Response Body :' + responseBody);
gs.log('request: ' + r.getRequestBody()); // what was sent
}
catch(ex) {
var message = ex.getMessage();
}
}
Notice the main difference is setRequestBody(json) is used when you want to specify the entire body.
And setStringParameter(str) is used when you have the JSON "template" defined on your post record.
If you're sending the requests to an Import Set table on the other instance, then you definitely need to have a Transform Map set up. Otherwise you will end up with blank values. You will also need to update your JSON request body to reflect the field names on the staging table (not the names on the Incident table). So it might be {"u_state":"${state}"} etc.
If you are post directly into the Incident table, then you do not need a Transform Map.
