-
GET unique url from a database cell - How to?
Hi, I am using Xano as a backend to Draftbit. I have a unique url in a cell on a database. How can I GET that user's unique url clickable in their profile section on Draftbit? … I was told from support at Draftbit, "Yes, based on your structure in Xano, you should be able to retrieve warranty url together with user data.…
-
Creating Unique Slugs Based on User Names from Relations
Hi there, I can't help my novice skill and knowledge. I need help, please. I want to create a slug based on users' full names. I attempted to add the slug field to the 'user' table but discovered that I couldn't have more than one unique index. So, I added the slug field under my 'profile' table, which already has a…
-
Column depending on another
I have a column that depends on another. Depending on the value that is entered, the other column needs to be automatically filled with a predefined value. I've been trying to do an endpoint, but isn't working.
-
How to make a data source conditional in my api endpoint
Hi, I'm planning on creating a conditional whether the data being used is “live" or “test”. If the data being used is “live”, I'll use the live api keys for my external api and if “test”, I'll use the test api keys for my external api. Do I make this by using $datasource == ‘live’ // $datasource == ‘test’? for my…
-
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…
-
Make all changes in API Endpoint save automatically.
It'll really useful if I make change and it's saves automatically, because sometimes I forget to click on "save" button then test request in run&debug and get that I didn't expect. One more point why you should make this feature is that you already have change log and it will be a good combination autosave and change log…
-
'Get All Input' function causes 'Unable to decode input error'
Hi all, I'm having trouble getting the “Get All Input” function to work properly. My setup is as follows: I have a submission form on a Webflow page with POST action set to endpoint in Xano. The first function in this endoint's funtion Stack is “Get All Input” with json encoding. When I send some test data from the form in…
-
Secure endpoint
I'm creating a website using xano, I found out that users can inspect the website and find the endpoint in my JavaScript files. Is there a way I can make the endpoint only run if it's being ran on a specific domain?
-
How do I add a path variable in my external api request?
Hi! I'd like to know how to set a path variable for my url in my external api request. For example I have this URL: https://www.pdfotter.com/api/v1/pdf_templates/:templateId/fill? and for the templateId it has a value of tem_1234567 for example. I can't set it as a param since it will turn the response url into:…
-
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…
-
Transforming ISO String to Timestamp
Hi, I have a problem and i don't know how to solve it .After an airtable import I have a computed string field containing a string in ISO format ( because it was a computed field in Airtable ): 2023-01-02T16:03:44.818Z (by the way there is a bug in Airtable import when you have a DATE field with the option "include time"…
-
Hello, I have a very specific introductory question (Thunkable IAPs)
Hello Xano community, I am interested in using the Xano platform if it is capable of handling our needs. We have developed an app that is accepted in Closed and Beta testing for GooglePlay and iOS respectively. We have designed our app within Thunkable. My question is whether or not Xano would be able to integrate and help…
-
Trying to link notes/comments to a user.
I'm trying to link a note/comment to a user and an admin and then display it. I'm not having a problem getting all the notes, but I am having issues filtering them to the specific user and admin. Here is the table for the Notes. I think my biggest issues arise in the endpoint API. I don't think I understand all the…
-
500 Error: Invalid Name: mvpw1:4
Getting a 500 error when calling a GET endpoint that should be returning a single record in a table called Courses. The endpoint ends in /course/{id}. The error message is: Invalid name: mvpw1:4