-
No results when using Paging
Hi When I query the results without paging activated it worked fine. No issues. However. When I activate it and use this as parameters: [image.png]I get error: [image.png]Here is the setup: [image.png]What am I missing? In debugger I get 0 results: [image.png]But should have been many ( at least 5) records.
-
(Untitled)
I am working on a marketplace app and I am using Xano as my backend. I created a table called "Users" that holds the users information. In this table there are email and password fields named "User_email" and "User_password" respectively. I created a Authentication API which includes the 'sign up' API and the 'login' API.…
-
How to get data based on a geographical query ?
I have geographical places in my database named pizza store. I want send a query API to return all the pizza outlets within 10 km of a given place. For example I want to get the list of Pizza outlets within 10 km of New Delhi Airport. Is it possible in Zano ?
-
Xano with CMS for client
Hello, Say I want to build a blog for a non-technical client, and use Xano as the backend to store the blog articles. Is there any sort of CMS xano includes out-of-the-box that would allow the client to be able to easily add/edit/remove blog posts? (Perhaps you would consider Xano’s GUI the CMS?) Or would it be on me to…
-
Database structure
I am figuring out how Xano works and am I trying to make a basic book app to figure it out. I have a question regarding how to set up the database. I have a list of books. Furthermore I want to add the book to my collection. Other users of course also can add a book to their collection. What's the best way to store it in a…
-
Having issues with access to variables
Modifying the WMX workflow. I keep running into a problem with the error "Unable to locate var" in my Function Stack. I know that the variable webflow_response.response.result._id exists from an earlier function item (an API call to create a new item in Webflow). I've even tested sending it to an external API I can…
-
API Security
Hi guys, just a "small" beginner question: To secure my APIs I can't use the user auth functionality. This is because I am using Adalo as Frontend and I am not part of the external user testing and can't send the users password to Xano. Is there another way to secure my API? Is it - from a security perspective - also valid…
-
Filtering records
Hello! Im creating online store. I have table of products in Xano and each products has number of different tags. Im using Draftbit as front end and use POST api to fetch records. I want to have filters based on tags (automatically) and by clicking on tag I want to get products only with this tag. As I understand this…
-
Table column reference to different tables
Hello! I want users to like & comment records from diffrent tables (like products, posts & offfers etc) What is the best DB design? I think about this: 🔹c omments table has also columns: product_id (if comment left for product) offer_id (if left for offer post BUT then product_id is empty) post_id and for each comment…
-
How to fix my loop (error invalid cast)
Hi there! I'm trying to loop over another table using the inputs I get from the user to extract specific data. See error: [image.png] My logic 1) For each loop - using coins array (user input) 2) Query records from another table (see screenshot) and return info that matches items in the loop + another id field.…
-
Adalo & Query Parameters
I'm trying to filter a list in Adalo using query parameters. I have a list of Program Folders, and in it a list of Programs. I only want to show the programs that are in the current folder. My query parameter seems to work in Xano, but not in Adalo. Video attached.[2021-12-15 14-06-27.mp4]
-
Duplicate record detected
Getting an error: "Duplicate record detected. Please check your input and try again." This happens on an Add Record - User with only these fields: [image.png] How can an add record result in a duplicate record error? isn't the only unique ID is the "id" which is not set manually anyway?
-
Can i create database tables from an API response or from pasted JSON?
Working with a new external API and various calls return complex JSON responses with 50+ objects, which I need to save. Creating a database table for one of these let alone many would be tedious. Is there a way to take the response and turn it into a table structure? Like pasting the JSON somewhere at least?
-
Access request history data
Is there any option to fetch request history records that you saved at Xano's end (considering you publish request logs)? I currently add one more step to my function stack where I try to add this visit to a table. This visit information is important to track app conversions.
-
Using "capitalize" filter in Function stack
Sorry in advance if this question is a bit redundant. I try to build a search bar and in my endpoint, I have created a condition WHERE input: text "search" = db "projects.item" and so far so good - the results are returned if I type the exact wording, but I would like to let my end-users to search no matter if they type…
-
Trigger table column adjustment when a row is created/updated
Hello there! This is my first weekend with Xano and generally DB structures so bear with me 👍. I'm stuck and I hope you can guide me or share with me docs I should read over. Context: Creating a crypto signal app where I have a table cryptoAlgos with each row including -> {strategy, coin and signals}. The user has the…
-
Make an API to allow a user to update their name
I have a database of Users that I use for authentication. I have a field in the user table called 'name'. This feels super basic but I can't figure out how to format an API that allows a logged in authenticated user to update their name in the table. End result: Allows user to update their name field on POST Doesn't update…
-
A random output
I would like to know how to make an api that allows us to enter 2 or more texts and that chooses 1 randomly to give us an answer, among those recorded And also if it is possible to define a rate of chance that a value record appears more than another
-
[RESOLVED]How do we reference different fields in a Ref Object?
I'd like to reference the user_id email value of the user rather than the integer the user_id type. How does one do this? I tried querying the meeting table to get records with EMAIL INPUT i wanted but I get an error [image.png]
-
do excess columns slow down a database?
I get that there's a point where records can do that, but is it the same for columns? Currently, my members database has about 40 columns. They're not all essential fields, and could be broken off into other databases, but for birds-eye views, I liked having it in one place... except if it can slow things down... Also, how…
-
[RESOLVED] CONDITIONAL Data Manipulation Function or Value Data Filter?
Hi, Dummy here — 🤓👌 — looking forward to that clicking moment when I can graduate to more complex tasks. GOAL — Filter a LIST to only show records with an input ID in it. SOLUTION —…
-
about remote_ip
I am a beginner, I am making an api to add users from flutterflow , but i get the remote_ip ,not my ip, i stay thailand ,get USA ip[截屏2021-11-18 下午8.26.09.png]