-
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…
-
How to modify api input params to dynamically add columns and values ??
I am using metadata API, I need help with how to add columns in table dynamically along with the data. I figured out the column adding, but stuck on how to add the value in the table for that newly added column. Ex. { "data": "test", "int" : 123 } this is first object which has int as a new variable and need to add that in…
-
Offline usage / data sync Xano
Hi all, We are prepping to implement offline usage to our Draftbit app - our BE runs on Xano. To enable offline usage we are considering WatermelonDB. Question now is - who has experience using Xano in combination with a FE that allows offline usage (thus requiring pulling and pushing data to sync FE and BE); Which sync…
-
How do I get the content of a .txt file stored in my database?
For example, I have a .txt file saved in my database and would like to get its content. How do I get it? I only see the following: {path, name, type, size, mime, meta, url}, no body for the .txt file.
-
What is an efficient way to store a bunch of booleans?
Hi everyone! I have a form on the front end that push some data and a bunch of booleans in it. The data structure looks like this: base data (user, role, date, etc.) and around 70 booleans from checkboxes. What is the best way to store data like this? I need to be able to query data and make aggregate functions by these…
-
server capacity
Hello, I'm new to using xano so far I've only used the free plan, however I have a big project that will possibly be a union of flutterflow with xano, but I don't know the capabilities of the server, I'd like to better understand if there's a limit on requests, like Does the server limitation issue work, is it because of…
-
Text filter requires a scalar value.
I am trying to delete a record and feed the id from a variable like this: If I run it I get an error: Text filter requires a scalar value. I then tried to enter the id directly as a number and it worked fine. I also tried to do it with a get filter but that doesn't work either. Here is how the variable looks like when it…
-
how to edit an existing record targeting it by two or more parameters (fields) evaluating to true?
I want to update a field for a record based on if two column values are true for that record. E.g - Update/Edit "Complete_Status" to a "1" IF "Customer_ID" == "12345" AND && "Subscriber_Status" == "Subscribed" How would I got about doing this? I see that the Edit a record endpoint has the limit stating "If you choose a…
-
Transforming a list into a list of objects
Hi Xano community, Im trying to trasnform 2 lists into a list of objects where each item in the list becomes a new object I added the above and get the results as So instead of teh above I want to get { Placement: 1 Budget: 10000 Placement: 2 Budget: 10000 Placement: 3 Budget: 10000 } Any guidace is much appreacite it !
-
Unable to create a record with a relational object field (many to many)
Hey folks! Trying to do what I think is a super simple thing in Xano, but having some difficulty. Thanks for your help in advance. I have a table POSTS related to another table TECHNOLOGIES via the Object field. I chose object because I don't expect a post to have more than two or three technologies related to it. All I…