1 ACCEPTED SOLUTION
@Dazler Tried and tested solution. Parse it using the code
var result = [];
var object = {
"MemberOf":"CN=Bright Executives,OU=SNOW,OU=Groups,OU=Connected,DC=Dev,DC=Green,DC=com"
}
/*var object = {
"MemberOf":
[
"CN=Group_22c6,OU=MGroups,OU=Groups,OU=Resources,OU=Context,DC=Green,DC=com",
"CN=Bright Executives,OU=SNOW,OU=Groups,OU=Connected,DC=Dev,DC=Green,DC=com"
]
}*/
if(typeof(object.MemberOf) == "string"){
var element = object.MemberOf;
element = element.split(",");
for(var j=0; j<element.length; j++){
if(element[j].startsWith("CN=")){
result.push(element[j]);
}
}
}else if(typeof(object.MemberOf) == "object"){
var innerArray = object.MemberOf;
for(var i=0; i<innerArray.length; i++){
var element = innerArray[i];
element = element.split(",");
for(var j=0; j<element.length; j++){
if(element[j].startsWith("CN=")){
result.push(element[j]);
}
}
}
}
gs.info(result.toString())
Result 1 (when users only in one group):
Result 2 (when user is part of multiple group):
Please mark as correct answer if this solves your issue.
Hi @Shane J
Action Input
I had to make a couple additions to the script.
(function execute(inputs, outputs) {
var result = [];
var object = inputs.jsonString;
if(typeof(object.MemberOf) == "string"){
var element = object.MemberOf;
element = element.split(",");
for(var j=0; j<element.length; j++){
if(element[j].startsWith("CN=")){
if((element[j].toLowerCase().indexOf('_access_') > 0) || (element[j].toLowerCase().indexOf('ven_') > 0)){
result.push(element[j]);
}
}
}
}else if(typeof(object.MemberOf) == "object"){
var innerArray = object.MemberOf;
for(var i=0; i<innerArray.length; i++){
var element = innerArray[i];
element = element.split(",");
for(var j=0; j<element.length; j++){
if(element[j].startsWith("CN=")){
if((element[j].toLowerCase().indexOf('_access_') > 0) || (element[j].toLowerCase().indexOf('ven_') > 0)){
result.push(element[j]);
}
}
}
}
}
outputs.memberof = result;
})(inputs, outputs);
Then I set my output as an array string and was able to use it within the For Each.
Hi Shane,
I finally figured out how to do this. It's worth noting that SN agreed this is an issue and will be fixing it in Yokohama. PRB1633191
What I did was copy the Look up User action so that I could modify the code. I kept it in the correct scope so that it would be found under Microsoft Active Directory spoke. From there I modified the code as follows.
Post Processing & Error Handling
(function execute(inputs, outputs) {
function handleError(error_message) {
var errMessage = error_message;
var resource_name;
var actionErrors = {
CANT_FIND_OBJECT: "Cannot find an object with identity"
};
var commErrors = {
AUTH_FAILURE: "Authentication failure with the user",
SERVER_UNAVAILABLE: "The RPC server is unavailable",
UNREACHABLE_STATUS: "Failed to access target system. Please check credentials and firewall settings on the target system to ensure accessibility: Access is denied."
};
var errorMessages = {
INVALID_OBJECT_IDENTITY: "Invalid resource name",
CREDENTIALS_FAILED: "Invalid credentials for host",
ACCOUNT_LOCKED_OUT: "The referenced account is currently locked out and may not be logged on to",
INVALID_HOST: "Invalid hostname in connection or host not reachable from MID Server",
AUTH_FAILED_WITH_MID: "Host credentials incorrect. Authentication error in MID Server"
};
if (error_message.indexOf(commErrors.AUTH_FAILURE) != -1)
error_message = errorMessages.CREDENTIALS_FAILED;
else if (error_message.indexOf(actionErrors.CANT_FIND_OBJECT) != -1) {
resource_name = (errMessage.split("' under:"))[0];
resource_name = (resource_name.split("identity: '")[1]).trim();
if (resource_name == inputs.user_name)
error_message = "Invalid User Name : " + resource_name;
else
error_message = errorMessages.INVALID_OBJECT_IDENTITY + " : " + resource_name;
} else if (error_message.indexOf(commErrors.SERVER_UNAVAILABLE) != -1)
error_message = errorMessages.INVALID_HOST;
else if (error_message.indexOf(commErrors.UNREACHABLE_STATUS) != -1)
error_message = errorMessages.AUTH_FAILED_WITH_MID;
throw new Error(error_message);
}
if (inputs.errorMessage)
handleError(inputs.errorMessage);
else {
var responseBody = JSON.parse(inputs.responseBody);
if (responseBody.status == "Success") {
var result = [];
var object = responseBody.body.MemberOf;
if(typeof(object) == "string"){
var element = object;
element = element.split(",");
for(var j=0; j<element.length; j++){
if(element[j].startsWith("CN=")){
if(element[j].startsWith("CN=")){
result.push(element[j].substr(3));
}
}
}
}else if(typeof(object) == "object"){
var innerArray = object;
gs.info("XX: object loop");
for(var i=0; i<innerArray.length; i++){
var element = innerArray[i];
element = element.split(",");
for(var j=0; j<element.length; j++){
if(element[j].startsWith("CN=")){
result.push(element[j].substr(3));
}
}
}
}
outputs.memberof = result;
} else if (responseBody.status == "Error")
if (responseBody.body)
handleError(responseBody.body);
else
handleError("Unknown error. Please check error log for more information");
else
handleError("Unknown error. Please check error log for more information");
}
})(inputs, outputs);
You will notice that I removed all the other elements and I am only outputting an array of strings. I deleted the output and updated it accordingly.
Outputs
I deleted the outputs and created just one called membership which is nothing more than the array from Post Processing & Error Handling.
You will need to update the parsing code to handle what you need to strip out. For me I just needed the CN piece so I updated the code to strip that element out only and it also strips off CN= so that I just get the group names. Attached the xml as well
