I had this issue once. I created a new API endpoint in Xano and replicated what I needed. When I loaded that collection to Adalo that worked. I tried that method again but no to avail.
I guess is that it should return a error when you run manually like you did in the video at the end but without any params. My guess is that, when the inputs are empty this issue arise so what you can do is enable the Ignore empty values option or handle with a if-then-else.