EntraId to SuccessFactors Writeback | Add leading zeros

Question

EntraId to SuccessFactors Writeback | Add leading zeros

Wieland, Sebastian 20

Hi all,

we are using the Entra ID Provisioning Service Writeback to send Email and Phone Number to SuccessFactors.

However, we are struggeling with matching IDs on both sides.
We are using the a userID in extensionAttribute14 in AD, consisting of 3-5 numbers. On SF side this ID is also used, however there it is filled with leading zeros to have an 8 digit ID (necessary for downstream systems).

AD: 12345

SF: 00012345

It always have to be exactly 8 characters. The Ids can also contain 0, so removing all 0 is not an option (like 12305).

Is there a way to use Expressions to still be able to match those userIds?
Any ideas would be highly appreciated!

I tried using REGEX by using the Replace expression, but can't get it to work. For example:

Replace(Append("0000000",[extensionAttribute14]), ,"\d{0,8}$", ,"", ,)

Akshay-MSFT 17,961 Reputation points Microsoft Employee Moderator

2024-05-10T09:51:05.4033333+00:00
@Wieland, Sebastian

Thank you for posting your query on Microsoft Q&A, from above description I could understand that you are looking to map UserID attribute in Entra ID to SuccessFactors Writeback and match the exact number of digits in the ID.

However, I am looking for following info:

If the user properties are not getting updated due to mismatch in the digits or if you are getting any error?

Kindly share a snip of mapping attribute settings for user ID.

This would help me in investigating this thoroughly.

Thanks,

Akshay Kaushik
Akshay-MSFT 17,961 Reputation points Microsoft Employee Moderator

2024-05-17T05:34:58.8+00:00

@Wieland, Sebastian

I am following up requesting inputs on above queries. This would help me in understanding the issue better.

Thanks,

Akshay Kaushik
Wieland, Sebastian 20 Reputation points

2024-05-17T07:09:45.6533333+00:00

Hello @Akshay-MSFT
Thanks for your reply and sorry for the delay.

I unfortunately can't share a snip of the mapping, as I don't have access to the customers environment. But the mapping would be employeeId to userId using an expression to remove the leading zeros.

There is no error message, but as you stated, the Writeback doesn't match the user entries and therefore drops the flow.

Sorry, not much insights from my side.

Best Regards,
Sebastian

Your answer

Akshay-MSFT 17,961 Reputation points Microsoft Employee Moderator

2024-05-10T09:51:05.4033333+00:00

@Wieland, Sebastian

Thank you for posting your query on Microsoft Q&A, from above description I could understand that you are looking to map UserID attribute in Entra ID to SuccessFactors Writeback and match the exact number of digits in the ID.

However, I am looking for following info:

If the user properties are not getting updated due to mismatch in the digits or if you are getting any error?

Kindly share a snip of mapping attribute settings for user ID.

This would help me in investigating this thoroughly.

Thanks,

Akshay Kaushik
Akshay-MSFT 17,961 Reputation points Microsoft Employee Moderator

2024-05-17T05:34:58.8+00:00

@Wieland, Sebastian

I am following up requesting inputs on above queries. This would help me in understanding the issue better.

Thanks,

Akshay Kaushik
Wieland, Sebastian 20 Reputation points

2024-05-17T07:09:45.6533333+00:00

Hello @Akshay-MSFT
Thanks for your reply and sorry for the delay.

I unfortunately can't share a snip of the mapping, as I don't have access to the customers environment. But the mapping would be employeeId to userId using an expression to remove the leading zeros.

There is no error message, but as you stated, the Writeback doesn't match the user entries and therefore drops the flow.

Sorry, not much insights from my side.

Best Regards,
Sebastian

Share via

EntraId to SuccessFactors Writeback | Add leading zeros

Your answer