Forum Academy Marketplace Showcase Pricing Features

Api connector blank value

When the user leaves an input blank I would like the value in the DB to not be changed.

I am using xano for my backend and when I hit the button to run the api post and the cell is blank it changes the value in the DB to the key value of the body parameter I initialized the call with. I have tried to check the box allow blank but I get an error.

The problem is that there’s a difference between null value and blank value. Bubble will let you set this field blank… but will replace the empty value by null. This should work if you remove " quotes around parameters.

Thank you it is working now. The sad thing is, I had already tried that, but my database was having a problem with another issue and I overlooked it.

Not sure what I’m doing wrong now tried this on anther call and now im getting an error again

I think I know what the difference is. full_name is a text value?? Do I need to do something different for text and bool values? Works fine for numbers

A boolean value normally doesn’t requiere doubles quotes. Same for number. But this depend on the API spécifications

Found the problem this decimal needed to be 0.10 not just .10
Crazy something so simple

1 Like

Another question, I have a checkbox which is a Boolean value and I need to change it using an API call, but I can’t figure out a way to make a change in the database. I have tried checkbox is checked also trade check box isn’t checked, but when I run the workflow, it does not seem to change the database. I’m sure it’s something simple. Any ideas?

Can you share what you have set?

Admin is the value im trying to change

Screenshot 2023-05-24 at 3.40.20 PM

I fixed it sorry to bother you. I have something wrong in xano.

Needed to add set admin path. I had been working on setting the conditional values and forgot to add set admin
Uploading: Screenshot 2023-05-24 at 3.51.57 PM.png…

1 Like

So I can change the value of the Boolean but I can’t figure out if the user leaves the field blank if I wasn’t using a checkbox then I get an error message. I tried changing the path and took out the quotes, but it doesn’t seem to work. I’ll try again tomorrow. Hopefully I can figure something out. Also, I have not tested leaving a text field blank yet, but I did get the number fields to work properly. Not sure if I need to change something on the xano end or in bubble