Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to parse AWS payload?

dswider
Tera Contributor

Hi all, I’m trying to parse a payload coming from AWS in ServiceNow, and I need some guidance on how to go about extracting a specific field. The payload looks like this: {
"statusCode": 200,
"headers": {"Content-Type": "application/json"},
"body": "{\"Operation\": \"SAVE\", \"Message\": \"SUCCESS\", \"Item\": {\"rpt\": \"INQ0000001234\", \"userId\": \"Firstname.LastName\", \"sessionID\": \"glide.scheduler.worker.4\", \"cusip\": \"000000001\", \"u_cusip_changed\": \"true\", ..."
}

I’m currently working with this script in my Scripted REST API to extract the field u_cusip_changed and update another table based on its value: 

var cusipChanged = requestBody.u_cusip_changed;
gs.info("Update Case REST cusipChanged: " + cusipChanged);

if (cusipChanged == "true") {
var caseGR = new GlideRecord('x_g_afss_inquiry_inquiries');
caseGR.addQuery('number', rptBody);
caseGR.query();

if (caseGR.next()) {
caseGR.u_cusip_changed = true;
caseGR.update();
}
}



0 REPLIES 0