Mike C2
Kilo Contributor

A few more hours of trying and I've yet to find any combination that will yield the test_display_value and test_sys_id from the following. I've got no issues when going against my responses that I'm using to extract the info on my Incident table, so I'm at a total loss.

 

{"import_set":"ISET4030016","staging_table":"u_test_request","result":[{"transform_map":"Test Transform","table":"sc_req_item","status":"error","error_message":"Target record not found","status_message":"Order Placed;Row transform ignored by onBefore script","test_sys_id":"43be4c1848a07e276ea021136144b05c","test_display_value":"TEST0235533"}]}

 

Current code.

var response = request.execute();

gs.log(response.getBody());  //confirms in the system log I'm getting a good response
var responseBody = response.getBody();

var parser = new JSONParser();
var parameterArr = parser.parse(responseBody);

gs.log(parameterArr.result[0].sys_id);

 

Anyone got anything?