Okta ServiceNow ActivityPack Bulk Update User with OktaID

okta_bulk_user_id_update.js

//query Okta for all users (sys_users) that do not have Okta IDs
// this may take a while to run for large user counts
getOktaUserIDs();

function getOktaUserIDs() {
    var users = new GlideRecord("sys_user");
    if (!users.isValidField("x_okta2_actpack_okta_id")) {
        gs.error("Okta ID (x_okta2_actpack_okta_id) does not exist on sys_user table");
        return;
    }

    users.addNotNullQuery("email");
    users.addNullQuery("x_okta2_actpack_okta_id");
    users.query();
    gs.info("Querying users: " + users.getEncodedQuery() + " = " + users.getRowCount());
    var act = new x_okta2_actpack.OktaRESTActivity();
    while (users.next()) {
        // Get Okta user id if we find a matching email
				var email = users.getValue("email");
        try {
            var id = act.getOktaUserIDFromFilter('profile.email eq "' + email + '"', false);
            if (gs.nil(id))
                continue;

            users.setValue("x_okta2_actpack_okta_id", id);
            users.update();
            gs.info("Updated user " + email + " with Okta ID " + id);
        } catch (err) {
            gs.error("Error getting ID from Okta for user " + email, err);
        }

    }
}