Creating a flow that watches closed opportunities in salesforce and then either creates or updates the items in a notion database.
Watches records in salesforce
searches against opportunity ID in the notion database
routing so if it exists it goes to update otherwise to create
adds or updates fields
It seems to work for create but breaks with the error “Invalid number in parameter ‘QL%3El’.” when updating. Any ideas as I can’t find much on this error online.
No idea how I fixed it. I just disconnected some of the modules and redid them and it works now. Sorry to future questioners not able provide much in terms of how I fixed beyond that.
For anyone who might need a solution to this in the future, I changed the “Value Render Option” under Avanced settings in the Sheets module to “Unformatted”. This immediately fixed the issue. Can’t tell you why though…