NERM - Sponsor ID/UID

[edmarks]

The “Sponsor” on an Assignment is stored like the following on the assignment profile:
“sponsor”: “John Smith ([email protected])”

We’re bringing this into ISC via a Web Service connector but need to somehow correlate this to a manager identity in ISC.

The “Sponsor” appears to be a concatenation of name and email from the Users API endpoint but there doesn’t appear to be a way to get the ID/UID directly.

Does anyone know of a “good” way to get the “sponsor” to a single value (i.e. ID/UID hopefully)?

Theoretically it might be possible to use some VERY COMPLEX Liquid syntax to build a User API call splitting the “sponsor” value into it’s components for name and email to hopefully get a single record back.

[melandod1 (Dan Melando)]

Manager Correlation rule on the NERM source - just use beanshell to strip away everything but the email address and correlate based on email.

Thats the best solution I’ve been able to come up with so far

[sauvee (Edwin Sauve)]

I’ve solved this in a different way, which was to do a lookup in the NERM workflow itself for creating / managing the records.

Have a second attribute, like ‘sponsor_id’ or something, and then in the workflow do a ‘Set Attribute values’ action. You can then set the value from another profile, similar to this:

This works any time you want to store other values from that or an other selected profile

[edmarks]

I couldn’t quite follow/get that working simply because I’m looking for a “User” which is not a profile type. But in the process I did find I could do the following:

Attribute: Whatever “text” attribute you want to use
Operation: Set Value
Set As: Another Users Account Value
From What User Attribute: Assignment Sponsor
Attribute: Login