Need help with xero and mysql

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.
Try this.
image
you find these functions here
image

Let me know if it doesn’t work.

If you are not familiar with MySQLWorkbench or equiv

https://www.nocodb.com/
^^ good nocode database GUI that can help you alter the database structure.