PaaS connector to Salesforce error with last name
Hi all,
We received an error when a C&P Data record came into Salesforce with a last name specified in the XML as “![CDATA[Pinto & Sommen]]" (or more fully, <![CDATA[Pinto & Sommen]]>). As you may know, we at WaterGrass currently turn off the PaaS handling of the data and process the C&P Data recordsourselves, and this caused our system to fail. First, is the reason for the odd formatting in the last name field the use of the ampersand? And if so, does the PaaS code properly handle this last name format. Obviously this came about because it was a business gift, and without a business name field to use, the donor used first and last name for the business name.
As you may also know, we may be shifting to using the Click and Pay system soon and no longer using our own code to process transactions, so my next question is does C&Pay app properly handle this kind of last name? I know there are plans to add functionality for organization donors for C&Pay, but in the meantime, will these records get properly processed or will they also fail for the C&Pay app?
Thanks!
Carl
-
Official comment
Good day Carl Paulsen
Yes, the ampersand (&) in the first name and last name triggers CDATA formatting in the XML to ensure proper parsing.
Click & Pay fully supports this and handles such entries without any issues. We’ve seen many clients use ampersand (&) and the records process successfully.
-
OK, thank you! Note in this case I was wrong about it being a business gift. It was a couple who wanted both of their names associated with the gift.
0
Please sign in to leave a comment.
Comments
2 comments