JSON Parser Multiple Arrays

[shellypoeckes]

Hello everyone,

I will give a thumbs up to anybody who can help me here.

I'm trying to parse information (highlighted fields in yellow attachment payload) from an Okta json suspend event payload that has a multiple arrays and then calling a sub flow to suspend the user in ServiceNow.

Please see payload attachment.

Here's scripted REST API.  It works if I put [0] where yellow highlighted but when I use [loop] it does not.  This payload can contain multiple suspends and that's why I cannot use [0].

[-O- · Accepted solution]

There is an error in your code: the for loop variable needs to be checked against parsed.data.events.length not parsed.data.length.

As for the original problem: there needs to be an additional loop, one that goes through targets:

(function process (request, response) {
	var initialRequest = request.body.dataString; //Payload sent by Okta event webhook.
	var parsed = JSON.parse(initialRequest);

	try {
		for (var eventIndex = 0; eventIndex < parsed.data.events.length; eventIndex++) {
			var event = parsed.data.events[eventIndex];
			var inputs = {};

			inputs.event_type = event.eventType; // String (Type of event triggered)

			for (var targetIndex = 0; targetIndex < event.target.length; targetIndex++) {
				var target = event.target[targetIndex];

				inputs.email_address = target.alternateId; // String (Email address of suspended user)
				inputs.target_id = target.id; // String (Okta unique ID of suspended user)

				gs.debug(JSON.stringify(inputs, null, '\t'));

				if (inputs.email_address == '') {
					response.setError(new sn_ws_err.BadRequestError('Target alternateId is empty')); // Throw an error if email_address isn't present in payload
				}
				else {
					// Start Asynchronously:
					sn_fd.FlowAPI.getRunner().subflow('x_abcd_acc_repo.user_suspended__subflow').inBackground().withInputs(inputs).run(); //Trigger Suspend User subflow
				}
			}
		}
	}
	catch (ex) {
		var message = ex.getMessage();
		gs.error(message);
	}
})(request, response);

Also, as you can see, there is no need to write out parsed.data.events[loop] every time, one can declare a variable (I dis so defining event), assign the array element to that variable and the script becomes a bit less cluttered:

			var event = parsed.data.events[eventIndex];

[shellypoeckes]

Nice way to debug.  Thanks for your help.  Very much appreciated!