Greetings! I am new to Alteryx. My first project is cleaning up some donor data in Salesforce. I am creating null values which seem to fail on output to Salesforce.
For example, a donor record shows [preferred_phone] as "Home" with no home phone number. In this case, because all of the other phone number fields are also blank, [preferred_phone] should be null. All is well on the Alteryx side in terms of creating the null values. The problem is the null values don't overwrite existing values in Salesforce upon output. I know overwriting with null values is a special setting in Data Loader, and my workaround for now is to output to CSV and use Data Loader to update records (blah!). Does anyone know if this is a limitation of Alteryx outputs to Salesforce or if there's something I should be doing differently?
Thanks for your help!
Solved! Go to Solution.
A potential workaround is to change that phone number (assuming integer) to a string and then loading as a space ' '.
Thanks, Ryan. That would be a good idea for any of the phone fields. This issue is with the preferred phone field--home, mobile or work--rather than the actual phone number fields themselves. The preferred phone field is a dropdown in Salesforce, so the value has to be null or one of the three options mentioned. Grrrr!
Logically though - if you have at least one phone number, than that phone number would be the preferred. If you have two or more good phone numbers, you can then select a rule that defaults to each one (if a preferred was not selected). If you are in the situation where you have no phone numbers, you can load ' ' to the other phone numbers (mobile, home, work, etc.) and thus now have that option to place ' ' within preferred. As you mentioned, your limitation is either null or the other numbers; if the other numbers are ' ' then problem solved.
The Salesforce tool is using an API to populate the datasets. If there is not a special setting in the API (look at the API documentation) then this may not work. You can create a custom Alteryx API output macro to Salesforce if there is and that should take care of the problem. Or do what you have done and just do periodic corrections on the nulls manually using CSV files from Alteryx. I would think as well that having no number listed in the CRM sounds like a higher-level issue that should not be happening in the first place?
When you want to push a null value use #N/A instead (simple formula replace). I just learned the trick to solve this exact issue. I am using it for a text field but hopefully it will work for other types as well.
So helpful! Thank you!
Thanks CP! Still helping me out 🙂