When mapping fields from Active Directory, is it possible to concatenate strings?  e.g. I want to make "Work Phone" in PureClound be "+61 7 1234 5" + User.TelephoneNumber

Yes, you can concatenate fields but only when the mapping direction is "ex2in" or "ex2in_on_create".  Here is an example:

{      "direction": "ex2in",     

"external": "${User.GivenName} ${User.Sn}",     

"internal": "general.name"    }

Use the "$" and curly braces "{}" around the desired external fields and leave a space between the fields if you want them separated.

Hi Elizabeth, that works perfectly for combining 2 fields into 1, but what if I want to add a static string to a field?  I've tried these but they don't seem to work -

"+61731444${User.IpPhone}"

"'+61731444'${User.IpPhone}"

"${'+61731444'}${User.IpPhone}"

Hi Matt, 

I was able to concatenate two phone fields in AD into a single field in PureCloud but the formatting is not saved.  Here is the mapping:

   {

      "direction": "ex2in",

      "internal": "contactInfo.phone_work",

      "external": "${User.IpPhone}  ${User.TelephoneNumber}"

    },

I put "+61 7 3144 8" in the IP Phone field in AD

I put "919-302-8888" in the Telephone number field in AD

This is the result in PureCloud after enforced formatting borks the result by removing the spaces:

In any case, static strings in the configuration cannot be used to populate PureCloud since the connector requires the external AD field name. 

From my previous post: "In any case, static strings in the configuration cannot be used to populate PureCloud since the connector requires the external AD field name."

However, I will contact the Dev to make absolutely sure there is no alternative other than to populate the field in AD.

Matt,

After much discussion and testing, our superstar Dev (Greg C.) discovered a way for you to map your string values as a constant in the config.  He tested with the following and said it works.  

{

"direction": "ex2in",

"internal": "contactInfo.phone_work",

"external": "User.TelephoneNumber",

"replace": [

      { "replaceDirection": "ex2in",

       "pattern": "^.*$",

       "replace": "+61 7 1433 $0" }

      ]

},

Obviously, you will need to provide the required values for the "replace" string but hopefully this will work and you won't have to populate every user's AD fields.

Let us know if this is successful!  :-)

Hi Elizabeth, that works perfectly. Thank you!

Excellent!  :-D