Unwanted URL encoding

PSA Admin

• July 16, 2020 21:25

I am importing URL as hyperlinks into SalesForce, but some of the characters are getting encoded, and the links are breaking. Here is my expression from the map for import to SF (I'm truncating at 250 to avoid overflow errors in SalesForce.):

{{substring custrecord_fj_track_link2_jk "0" "250"}}

The custom field referenced is a fully composed URL, for instance:

https://www.ups.com/track?loc=en_US&tracknum=1Z0902150373888453&requester=WT/trackdetails

What's happening is that, presumably Celigo IO, is substituting the hex code x3D for the "=" character and then the links do not work. I believe Celigo IO is doing this even though it's not in the JSON block being fed to the map. The reason is that another integration I'm using with the same fields does not result in URL encoded characters.

I cannot find any setting that might govern this change nor any documentation.

 

Any ideas?

Thanks much,

Jim

 

 

0

• 

  Courtney Jordan Experience Strategy & Design Director Community moderator

  • July 16, 2020 21:53
  • Edited

  

  

  

  Hi PSA Admin!

  Great to hear from you again, Jim! We actually had planned to put a post out on this tomorrow, so you're right on time! Can you try using {{{ }}} to remove the URL encoding? Here's a post with more info. Let us know if that doesn't work!

  0

Please sign in to leave a comment.