I keep on encountering several issues whenever I try to use the Salesforce-Updater, and some of the fields that are not configured are Text in Salesforce are trying to be updated to a blank value. I’d expect when this happens that it’ll just empty whatever is in that field, but instead it errors out, I’ve had this happen with the URL field type and also the Number type. Below is a screenshot of the error, and also one of the values that I’m trying to set to that field via the updater.
Hey @Marcel_Luthi! If you’re reporting an issue with a flow or an error in a run, please include the run link and make sure it’s shareable so we can take a look.
Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={{your_run_id}}&workbook_id={{workbook_id}}
Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
Provide details about the issue—more context helps us troubleshoot faster.
Thank you for flagging @Marcel_Luthi – The node would add empty values for normal fields but the issue with the run you shared is a data type mismatch in a field called ‘Crawl Company Founded’. The node is expecting a numeric value (specifically a double, which is a number that can have decimal places) so it can add empty values there.
I’d recommend adding placeholder values here using AI or perhaps you can use a Filter node to filter out empty values altogether before writing to Salesforce.
Changing all fields to text fixed the issue, but clearly that is far from ideal as we loose a lot of functionality that comes with the original types. If I’d need to do this for every single field that is not text, check if it’s empty and then filter to update only those, as I’m updating several fields this would just have made the whole flow a nightmare as I’d need to have 1 update + 1 filter card for each and then figure out to ensure that the right Ids also get filtered. Is there any tile that would allow you to bundle multiple lists together, so the input are the individual list coming from separate tiles and the output is just the same number of things as the inputs but makes them a single “path” so it can be feed to filters to ensure all gets properly filtered?
That makes a lot of senes. We’ll explore how to make the functionality more robust here. As for your question the easiest option for this would be to create a custom node instead of having multiple filter nodes and lists.
