-
Managing Hierarchical Data in Xano
I would like to create a category tree with nested subs and try to figure it out. any tips and tricks on how to achieve it in XANO?
-
Renaming data api fields
Hi, I've a table that has several columns. A remote service calls my data APIs and queries the id and the name. However, the service requires that the json fields are "key" and "option". Is there a way in the "Query all records" to rename "id" and "name" to "key" and "option"? I could not find a field in the "outputs"…
-
One time password to email
Maybe you can help me. How can i develop the feature - One Time Password. generate, send it on email and user need to enter 4 digits to access A think a can do it. with Magic Link via SendGrid, but it generates a long token, and i need just 4 numbers
-
API returning 'unsupported input' error
I have an API set up to fetch and decrypt records, using an Auth ID to only return records that are attached to a specific user. It has been working for about a month and suddenly I've somehow broken it so that it now returns a 'unsupported input' error: [Screenshot 2021-12-20 at 14.43.08.png] I have tried to get more…
-
How to utilize addon data in an api Workflow?
Hello all. I'm trying to take the Lat and Lng from this response, and use it in this same workflow to find a list of things that are within +or- .5 of that lat and lng. Anybody have any ideas on how to do that? I want to query all a table off addresses, and find the ones that are within a certain range of these…
-
no CRUD
The help videos on YouTube suggest that building a table AUTOMATICALLY generate a full spectrum of CRUD APIs. I find there are no APIs and I will have to build them by hand. 1) I've built 8 tables and populated them with ten or so records each and I'm wondering is there a way to "reboot" or is that necessary? to recreate…
-
uploading images with a Webflow front end?
Webflow has limited ability to upload files in their forms. One workaround is to use uploadcare.com which returns a UUID URL to request a particular image file. Xano offers the ability to upload a file directly into a table. But that doesn't offer the ability to test a data entry / CRUD form(s). Is there a means to achieve…
-
protect endpoints when using fetch()
Is there a way to restrict an endpoint to requests to particular domains? I see the precondition function can call the $http_headers object, but there is no "contains" operator option, for example. Or is there another way to protect an endpoint so that someone who looked at my code couldn't just call the endpoint Thanks!
-
url_encode alternative library
Hello Guys, your URL_Encode returns + for " " as opposed to %20. It causes issues for my signatures when calling external auth. So far i hard coded replacement + -> %20 but thats super ugly solutions. Is there any other way for url_encoding when i get %20 for spaces or maybe you could add alternative url_encode filter?…
-
flatten array
any ideas how to flatten such an array in xano? [ 4740460,[4740927,4740928],4739797 ]
-
ably push notification
hi, is there a tutorial on how to use ably for push notification with xano?
-
How to hold temporary data between API calls/endpoints?
There is an API which for its authentication to get an auth token requires creating a unique random and temporary id which you add to the first request. It then redirects to the redirect_uri you predefined with 2 query parameters, one of which is the id provided before, and that call needs to verify that it is the same id.…
-
Unable to locate func entry: coalesce
I have a filter for active records, which can be null. In that case, it must return all records (active = true or false). If filter_active is set, then it shows me the results accordingly to filter_active. To achieve that result, I use coalesce function like that: [image.png](if filter_active is null, then record.active…
-
CSV decode
Hi Xano team I need you assistance please. I am calling an external api to retrieve a file that is in csv format and I have used the csv decode filter for this which works fine. I know need to persist this data into a table that has the same columns and the header in the csv file. The problem that I am facing is that I…
-
How to select select properties of a API JSON response
Hello, I have an API returning over 50 properties and 1000s of entries (records), I want to narrow down the reponse to 3 properties for all entries. I saw a video that allows you to select one property as a path filter in the response part of XANO. Is it possible to select 3 properties together? Lets say i only want…
-
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
-
Is there a guide for creating a proxy?
Sean gave a brief overview during office hours but i'm unclear on some of the details. To use the bubble workflow API you need a POST request, but in draftbit there is no way to use POST on page load, only GET, or only after user interaction. So I want to send a get request to Xano, have Xano send a POST request to Bubble,…
-
Authentication issue
I have two table table A and table B I am enable authentication on both table and I am build one custom api where we want to access both table based on authentication how can I do
-
Change sign out timeframe in Android app
I have launched an app to the playstore beta channel and have it installed on my phone. It has Auth setup through Xano. All working well, however it logs me out every couple of hours. My app is Draftbit front end and Xano backend - is the log-out time something I can address in Xano? Is it connected to some sort of timeout…
-
Problem updating nested values / addon..
Here's the context - I have the following data: { name: Bob, persona: Candidate, last_modified: 1637575424287, tags_id: [ { 0: { id: 4, created_at: 1637507343753, name: Test}, tags_id: 4}, { 0: { id: 2, created_at: 1633023749312, name: Manager}, tags_id: 2}], } Question 1: Why are the tags under the 0:? Question 2: How can…
-
Addons: Weird results - Extra Null in structure?
So I'm getting some really weird results for Addons in between Xano and Retool: This is Xano:[image.png] which results in this:[image.png]That 'null' is the problem. As ReTool sees this as: [image.png]
-
Passing data to Google Storage API
I am trying to replicate this particular cURL request in Xano: curl -X POST --data-binary @OBJECT_LOCATION \ -H "Authorization: Bearer OAUTH2_TOKEN" \ -H "Content-Type: OBJECT_CONTENT_TYPE" \ "https://storage.googleapis.com/upload/storage/v1/b/BUCKET_NAME/o?uploadType=media&name=OBJECT_NAME"as described in the Google Cloud…
-
Get the records only belonging to a specific user
Greetings! Quick question: I have 2 tables: one for users and one for projects. How can I get the records only belonging to a specific user? Thank you. Thank you.
-
Where should i store facebook token?
Hi all! I want to recieve data from Facebook Graph API I set up Facebook OAuth for signin/signup and add new scopes for business manager access Now i want request users pages and users ad companyes, but i dont know where i can find and store fb token It also doesnt work with this call https://graph.facebook.com/me[Снимок…
-
The Easiest Way to Edit/Create a Record
What's the easiest way to create an API if I need to edit a record if it exists or add a new one if it doesn't. I thought of querying all records for a match of the searched columns (other than the id) and if found I return the id in a variable. If the id is not null I edit the record and else I add a new record. I tried…
-
Webflow + Wized.io + Xano
A seemingly fantastic tool, called Wized, makes the middle layer incredibly powerful. Where I'm stuck is understanding the use of Xano APIs. 1. When creating a user, should I be hitting the Auth APIs or the User table APIs? 2. When a user logs in, I assume it's the AUTH APIs, would that be correct? Primarily where I'm…
-
Trimming a space in a Post
One field in my table needs to ensure there are no spaces. It will be used as a public facing URL appended to a page such as: website.com/[field_input] ...where [field_input] is the displayed data from the specific field of the table. When a POST call is made, I need to ensure there are no spaces at all - I've figured out…
-
how to create a function router?
Hey y'all. My payment processor is sending IPNs for any kind of transaction. Sale, subscription setup, repeat bill, etc. Each one has its own set of functions that need to be completed. And each IPN includes an "event" value. Is there another way to route traffic outside of doing a string of conditionals? The integromat…
-
Facebook Oauth with bubble
hi all! try to connect facebook oauth to bubble, but i get this issue(photo #1) [Снимок экрана 2021-11-16 в 21.20.10.png]and when i try make a call in xano it's not working too(photo #2) Where i can make a mistake? I copy code from my url after facebook oauth [Снимок экрана 2021-11-16 в 21.22.58.png]
-
[resolved] Decrypt multiple inputs by user on GET request
I'm building an app where users can submit journal entries. Each entry can have up to 3 inputs. I have it set so that entries are encrypted in the back end so that I (or anyone else) can't read them. The encrypted POST is working well (screenshot below) and passes the encrypted data into Xano perfectly. [Screenshot…