I wrote another post here after noticing a bug with the Salesforce tool but I have noticed more so wanted to document them all in one place. I am using Version 5.0.10 (April 26, 2023) of the tool from Marketplace and the latest version of Designer, 2023.1.1.281 Patch: 3.
Boolean fields returned as strings
IsDeleted, IsActive type boolean fields are returned as strings instead of boolean like they used to be. This causes most of our workflow which use this data to fail.
Field metadata is not returned
Not much else to say here, there is no metadata in the pulled data. Again, this means many of our workflows fail.
Freezes when using file inputs
The SF Input tool freezes Alteryx when file inputs are involved in the workflow. This can happen when you have the input tool in the workflow and then drag in a yxdb, or in an existing workflow and trying to union the Input tool with file inputs.
WHERE clauses not saved properly
WHERE clauses are not saved correctly. In the query builder, remove the IsDeleted=False and replace it with something, click away from the tool and click back into it and what you entered has disappeared and it says IsDeleted=False again. The clause you enter appears to be saved in the query though because when you click on Custom Query it is present there but without doing this there is no way to know if the query is correct or not.
Fields with Type: Address break the query
Fields which are Address type (where values are python dictionaries) often cause the tool to fail, it complains about e2 conversion. In some instances they do work but are parsed out into duplicate fields - so Billing Address City is returned as well as BillingAddress.City.
All of these are critical bugs for us. Could these please be addressed? The tool is next to useless as it is at the moment.
