i have a flow that watches for xero invoices and puts into a mysql table but i keep getting bundlevalidationerror how to i make it still insert the data and leave empty fields empty
You might have to make the fields “nullable” from the database side.
if thats not the answer.
can you screenshot your logic here.
(remember to redact sensitive details)
will need to see how the SQL module is setup,
basic database schema,
example inflow data
do the database fields explicitly allow a null value.
that columns rejects null values (MYSQL workbench)
if your db tables do allow null values.
you find these functions here
Let me know if it doesn’t work.
If you are not familiar with MySQLWorkbench or equiv
^^ good nocode database GUI that can help you alter the database structure.