-
Update field text within object using a request
Hello Xano community, I'm trying to update a property called "gallery_path" (text) within a object called "seo" (obj) using a request. In order to do so, I created a endpoint /villas/{villas_id}/gallery_path and turned to visible the seo field which contains other various field among "gallery_path". My goal is to update…
-
Append suffix to integer value inside object array
Hi community, I'm currently working on this workout logger app, where frontend sends repetitions and weight values in the form of integer to Xano. The issue I'm having is, that I would like to add a measurement unit suffix to the weight value received from the frontend. Ex.: Frontend send to Xano: 99. Xano returns to…
-
How to update all Records in a database without Query All
I have a large database(1.5 Million Records), and am wanting to go through and update a field for each of them. What would be the best way to do this given that Query All seems to be returning a memory issue. Thanks for any help! Edit: At the moment my plan is to update them in chunks, just curious if there is a better way?
-
How to update a record in a POST call that has multiple inputs and I want to be able to pass only th
Currently I have a POST endpoint that has several inputs and I would like to be able to pass to the API only the input I want to update. Example: API inputs: email, name, phone Body request: {"name": "User name here"} If I execute the call in the example above, the name field will update. However, the other two input…
-
Issue with update request : Table reference field
Hello to all ! I'm a little bit stuck with endpoints that I use to update records, I use the function first_notempty on my fields (not to overwrite the values of my table if the fields are null or empty during the update) it works well on my fields of type text but I have a problem on my fields of type table reference : it…
-
How can I edit multiple values in an object with a single update action ?
Hi, I have an object with 5 keys referencing 5 numbers. I want with one update action to modify all 5 values by adding previous results into these values. I can't find a way to do it without having 5 update actions. Am I missing something ? Thank you