Manager NAme reformat Trasform

Hey everyone,

Do anyone have a easy transform that will take the name of a manager that is coming in as first name,last name and flip them with the comma in the middle so that SailPoint can add it to the profiles manager field. Right now, it is coming is first name, last name which sailpoint does not like and wont add

Hey there @VBsupport. What have you tried so far?

I did the reference rule transform with the manger correlation being the employee number which is correct. I could not get that to give me the dispay name in the right method for some reason so i decied to see if i could just do a come transform to rip what is comming into the format i need.

{
    "id": "",
    "name": "Nerm Manager Create Transfrom",
    "type": "rule",
    "attributes": {
        "name": "Cloud Services Deployment Utility",
        "operation": "getReferenceIdentityAttribute",
        "uid": "manager",
        "attributeName": "accountName"
    },
    "internal": false
}

To make sure I’m understanding:

  • you want to add an additional Identity Attribute with a transform to populate it with Last, First
  • your xxxx_service_account_owner_employee_ account attribute is coming in from the source as Last, First already

Is that right, @VBsupport ?

its actually coming in first, last for some reason I just need to do a name flip and make sure the comma is in the middle so SP will pick it up as the manager of the account

I would not recommend using the manager’s name for correlation, if it can be avoided. Names are not unique, and you’re very likely to have incorrect matches. If at all possible, you should have a unique identifier sent back from the system, but without knowing what platform you’re using for your authoritative source, it’s hard for me to be more specific than that.

Hi @VBsupport ,

Is this what you are after, just flipping the names over?

{
  "name": "Manager Name Flip",
  "type": "static",
  "attributes": {
    "value": "#set($input = $managerName)#set($parts = $input.split(','))#set($output = \"${parts[1]},${parts[0]}\")$output#end",
    "managerName": {
      "type": "rule",
      "attributes": {
        "name": "Cloud Services Deployment Utility",
        "operation": "getReferenceIdentityAttribute",
        "uid": "manager",
        "attributeName": "accountName"
      }
    }
  }
}

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.