-
how do I do a 1:many table reference?
Hi there I would like to do a table reference with a 1:many relationship and it seems that the table reference is currently a 1:1. I have a number of tools in a table and a separate table with categories. For example: screwdriver could be in multiple categories such as screwdriver, hand tool, #2 philips. thanks Gavin
-
Limits on looping?
I have a query where I call an API and then use a custom function to call the same API, but with incrementing parameters (pagination). It's 340 records. If I do this 10 at a time, I get a recursion error! If I do 50+ at a time, it works. Not a huge issue, but I am wondering what the limitations are for Xano (timeouts,…
-
How to reference current field while editing a record?
Is it possible to reference the current field? Maybe something like this:[image.png]Or do I have to get the record first then reference it? My use case is: I'm trying to add an object to an array. (Sorry if this question was asked already, couldn't find it.)
-
Custom slugs
Hi There, for SEO purposes I'd like to create custom slugs for records that are used as posts in the frontend of our application. The slug value is usually the name of the record with an incremental value added only if a previous record with the same name exists in the database. Is this achievable in Xano? I can't find any…
-
Group results by day + hour + minute
I am querying a db with timestamps and want to get a count of records split by day, hour and minute. I figured how to group by hour or day, but can't understand how to do multiple groupings. This results in an error: [image.png][image.png]
-
[Geodata] Transformations
Hello everyone, I have a technical question about Geodata transformations. I would like to do multiple transformations from Bubble data, such as a buffer for a geographical point. Is it possible to create a buffer or do other treatments from an external library / API like Turf.js, or directly in Xano by a Postgis add-on?…
-
Calculate Distance not returning meters
Hi there folks I am using the Calculate Distance Utility Function, and I am not getting the distance being returned. Has anyone else seen this? [Screen Shot 2022-08-09 at 12.26.10 PM.png] Here is the debug output of the variable distance [Screen Shot 2022-08-09 at 12.26.32 PM.png]
-
How to filter table records where 'Reference no longer exists'
Hi everyone, as the title says, is there a way to filter records where a record in another table linked by id in 'this' table has been deleted? Filtering on the string 'Reference no longer exists' '=' to or 'contains' doesn't work. [x1.jpg]
-
JSON text sent from Bubble to Xano (SOLVED)
Hi all, Re-editing this post since it was just a Loom video before. Essentially issue was I was sending a JSON structure using the format:as text function in Bubble to a Xano input (JSON). [image.png] When it triggered the API call in Xano, while it looked fine from the 'Run & Debug' view, behind the scenes it was…
-
Query all records by custom filter
Hey guys, I have a question about the best configuration for the custom filters if I want to support 2 different query parameters (mutually exclusive) on an API to filter the collection result from an All Records query. For example if I wanted an API to support something like: /accounts?email=xano@example.com OR…
-
Get Random record by selecting required subject.
Hello I'm working on a words generator, where the user selects a subject (from a subjects table I have) and get a random result from another table which have records related to each subject. Example: User select Subject - "Animals" (from a dropdown menu or another page in the front end) (select subject is required) In the…
-
Matching logged in user with team messages
Hey guys! Trying to match logged in athletes (it's an authenticated table) with team messages from their linked teams. tables are athletes(user), team messages, and each have a teams_id relationship. So I have a GET request (auth required), where it queries all records from team messages & I applied a custom query with dot…
-
CURL API with Webflow error
The Webflow API documentation to create a collection item requires a header in the CURL example. I am getting this error using the API. err: ValidationError: ‘fields.name’ is required The relevant CURL request text below from the Webflow API documentation: curl --request POST –url…
-
Stripe API Endpoint to Add/Edit User Table
Hey All, I'm looking to add or edit a user in the user table, with a stripe customer ID and stripe email matching an existing user email, or, add a new user to the User table and capture that user.id back to the Stripe subscription's table. Table1 Stripe Subscriptions • Stripe Customer ID • Stripe checkout email Table2…
-
API Response manipulation
Just wondering if there is anyway to modify the HTTP headers and Content-Type of Xano API response. It seems that everything is returned as JSON by default and wondering what options there are to control the response headers etc.
-
Combining database records into one GET API call
Hi all, Noob question here... I have multiple text-based database records. I am trying to query all those database records for one user and combine them into one GET API call. User 1 has a database record of "test 123" and "test 1234" and I want the GET API call to bring back "test 123, test 1234" I have experimented with…
-
empty data when saving through api
When i add records through api it saves a row but the data is empty.
-
missing variable although variable is created
-
Error messages on Auth Tokens?
Hey there, Loving Xano so far. Great work! Having issues with Authentication though. Getting the following error message when running the Debug and have no idea what to fix 😟[CleanShot 2022-04-10 at 20.00.34@2x.jpg]
-
Using Variables in External API request URL
Hi all! We are trying to use a variable ("var_3" in the function stack) in a request URL. Is there a specific format for this? Is this possible within Xano? We haven’t been able to find any documentation on this so any help would be greatly appreciated :) Please refer to screenshot for more clarity on what we’re trying to…
-
Can I create polygon from geom_point?
Suppose the user can select a place (geom point) in the frontend. Then, I want Xano to automatically create a polygon where the Distance is also modifiable by the user in the frontend. Something similar to what we do in Xano when adding a polygon to a record Take a geom_point as an input and return a polygon as an output.…
-
Keeping track of auth token expiry
Hi there! We are currently integrating with a third party API provider and in order to do that it’s crucial that we renew their auth tokens before they expire (15 minutes from creation) Is there a way we can keep track of when a user is using the app so that we can use that as the precondition to create a new token?…
-
Session management
Can someone point me in the right direction if there is an existing backend session tracking capability in Xano? In order to protect from replay attacks it would be great to have a server side session table that could be mapped to the client side browser sessions. Otherwise is the alternative to just create your own…
-
/auth/signup creates a User, could the Function Stack be extended to create a record in another Tabl
I saw yesterday that auth/signup creates the User record, using the Function Stack. This is vey nice functionality. Could the function stack be extended to create a record in another table? I split some data away from the User table to table called Profiles. I did this to prevent the user_id being exposed in the HTML, in…
-
Redirect loop after login
Hi! Having some intermittent issues with accessing my instance after login (and also accessing from my front-end). Seems to get into a redirect loop - see below for loom clip (have to full screen it to see the URL redirection)Happening now and a couple of times in the last week. Any idea if it's something to do with they…
-
Logic for Approval Chain
I'm trying to create an approval system where multiple people have to approve a request. My database design is pretty straight forward: Table: Approvals Table: Approver Steps - Reference to Approvals (Each Approver is given a row, with a number indicating where they are in the approval chain 1, 2, 3, etc) I want to show…
-
Updating prop of object in endpoint updates other properties of this obj
im my schema I have a record where I have object subsection with 2 properties { id created... subsection{ description:"ydhdhyd"; images: [img,img2...] } } when in endpoint I edit/update only images property and HIDE FROM ENDPOINT another property of this object it still updates both. and same if I edit description and HIDE…
-
Can I re-create the basic CRUD endpoints?
Hi there, I already played around with all the endpoints which are created by default. But now I want to have a clean setup for this workspace to connect with Retool so I don't mess up other endpoints which are used by the apps frontend. is there a way to simple copy or recreate the default endpoints?
-
Importing Data
Xana wont import Address as a location
-
Xano and Auth0
I have been watching the Auth0 video and I am a bit confused. There are some points that I would like to discuss. 1. At 4:41, we go to the demo link and have to enter the Base API Endpoint. Why do we do this? What is going on under the hood so that we can apply it to our own app? 2. At 4:52, what does the 'continue with…