-
Simple get using a variable... scalar value error?
I'm using a GET to obtain the id value of a table reference - the id, That value happens to be 14 as int. I'm validating that it exists in a conditional before using the value (14) in a subsequent GET request. The second GET request matching the table record id to the value obtained in the first GET - 14. I'm getting this…
-
Function Issues timestamp_day_of_week
Hi all, I am trying to make use the timestamp_day_of_week function on a timestamp parameter in order to check the current day is a certain day. For example now (timestamp) timestamp_day_of_week = 3. This is how my original argument is structured: [Screen Shot 2022-06-29 at 1.46.21 pm.png]In a basic setting (Using Now) it…
-
Post vs Put
I am just curious, why is XANO by default generating a POST endpoint to update/edit an object instead of making use of the PUT method.
-
Calculation question
[image.png]I am not sure why, but the result of this calculation when api response = 1 results in this in the db:[image.png]But when api response is = 2, everything looks ok:[image.png]What am I doing wrong? Thanks
-
Can someone please explain the various conditional operators in Query all records?
Hi, please forgive me if this has already been asked. I'm a little confused by the conditional operators in the Query all records function like include, contains, in etc. Sometimes I get errors (like: 1st operand must be JSON or an array) and I have to make it work by trial and error. I couldn't find much in the…
-
When table A references another table B, how do you select the field in table B that is displayed in
This might seem complicated but here goes. Table references do not seem to working here.[table upset.jpg]in the background are the table references page. In the foreground (bottom right) is the table nonprofit_premium_art (table A). Table A references artworks (table B) . That's the RED arrow. One might expect that each…
-
Refresh GET API results in frontend after submitting changes
Hello, I'm building a web / mobile app and whenever a user edits, adds, or deletes an item, I want them to see the results reflected on the page they are viewing. For example, if the user makes changes to their profile, I want the GET APIs to refresh so that once the user hits submit, that change is now flowing through the…
-
Multi-Tenancy Off Single Table
I'm developing an application where I want to have multiple customers and each of those customers has multiple users. I'd like to make it so that when a user logs in, they only see data for their company from any tables, and no other company. Is this something I can achieve with Xano Authentication? Is there something…
-
Alternative to multiple nested conditional if-then?
I often find myself in a situation when I need to use multiple nested if-then conditions based on some value in the incoming data. Is there any other way to "branch" out the flow of the functions? E.g. I have some "segment id" for all the entries coming into the system and I need the endpoint to apply different functions…
-
How to catch repeating task errors?
I have a task that is executing a single function. Sometimes there are errors within that function stack, which will stop the task process. I would like to set notifications for myself (telegram) when this happens but couldn't find a way so far. Can't use the function's output with a conditional since it may not even get…
-
Filtering & sorting query dynamically
Hi Guys, I would like to let my user filtering my query by firstname, lastname and choose which sorting (descending or ascending) I need to chain condition but i don't know how to do it If filter = firstname & sort = descending Then query with firstname descending Else query with firstname ascending OR if filter = lastname…
-
Appending Record to Array
I'm having some trouble appending a new record to an existing array. So far the only thing I've been able to achieve is overwriting whatever array is already in place. The basic logic I am trying to achieve here is that I have a table TEAM and I'm trying to add USERS to that table, pretty straight forward, but I haven't…
-
Image URL problem
Hi, I try to add to my Xano database an Image. My API has an Input JSON like that: "photo": { "path":"https://public.files.arengu.com/forms/165555697126336337/files/d75a9a6c5b7049c798fe9a11cf054709/perfil jorge fernandez.jpg", "name": "perfil jorge fernandez.jpg", "type": "image", "size": "54167", "mime": "image/jpeg",…
-
How to get enum value ?
Hi, i would like to get all my enum value to put it in dropdown. Some advices to do that ? It's better to hard code it ? Or separate it in new table ? Thanks
-
Edit user - enum
Hi, When i want to edit a user, i display a dropdown with enum values. I put the selected value in a state (in bubble) and when the but edit is click i launch a workflow and put select value in my field. But i have an error : Temporary error connecting to Xano - EDIT user (raw message: {"message":"Error parsing JSON:…
-
Copy data from another column
Hey, i imported my old database from airtable but column name are wrong. I saw if i rename it i loss all my data... I create a new column with the good name, now i want to copy data from one column to another column. I think i need to use for each loop, but i don't succeed to do this. Thanks, Thomas
-
Security: internal tools vs public app
Hi Xano community 👋 Noob question here: how should I think about security when building API endpoints for an internal tool? Context and my thought process— • I plan to use WeWeb to build a front-end for my external users, and I plan to use Xano's authentication features for a password-less login. This makes sense to me. •…
-
If You Need Help Connecting to HighLevel API Using OAuth2 Let Me know
Hello Xano'ers, Ever since I started using Xano, I wanted to know how to automate using the refresh token to renew access token for gohighlevel API OAuth2. If you're interested I'd love to share with you what I've done and see if it might help you and if you can improve it that's awesome but it works for me now which is…
-
Defining variables in Lambda function - error messages
Hello, I'm looking to make an API call to pass a file to an external database from Xano. The no-code approach worked only for images and PDFs but not for other file types (e.g. Word, Excel, etc.) so after recreating the API call in Postman, I copied the Javascript code generated, put them into the lambda function in Xano,…
-
Memberstack webhooks to Xano not working
Hi, I did exactly the same steps like in the video tutorial to integrate Xano with Webflow and Memertsack, When I add the Xano API in the Memberstack webhook nothing happen when there is new member created in Memberstack
-
Calculate the mean age of users
Hello everybody, I would like to calculate the mean age of my users. I downloaded the snippet made by bravo but it dosn't work for an array of timestamps. How am I supposed to do it ? Thanks for the help !
-
Convert "Dot Notation" string on inputs
I've got some input fields in a form and was hoping to use dot notation to access objects in my database (haven't decided if this is more trouble than it's worth). Is there a simple way within Xano to recognize this: [image.png]as it really needs to be:[image.png]
-
Covert Array into Object
Hi, i receive an array of choices from an API, like the example below: Tags: ["Marketplace","Cryptos","Real State"] I would like to insert the response of the API i have called in a Object field. How i can do that?
-
(GitHub) OAuth flow question
Hi. I watched 's video on GitHub OAuth and read the Installation Instructions. They are very helpful but I'm still trying to wrap my head around the `/oauth/github/init` endpoint. When should I redirect users to it? Also, and this might be more of a question for the GitHub community but do you happen to know if the…
-
Micro Services & Message Queues
Has anyone used Xano as Micro Services? In conjunction with any messaging queue systems?
-
"This instance has encountered an error."
Hi everybody I just updated my plan from basics to launch, I typed "I UNDERSTAND" to migrate everything but for some reasons it says "This instance has encountered an error". I have a button next to it to contact the support but it doesn't work... What should I do ? Thank you
-
Same Table-Table relationship
Hello, I am looking at a user-user relationship. So basically UserTable-UserTable I have a column (which is an object array) of partners in the table where I add partners to each user. Say i am adding user 16 to user 1. I would like to automatically see user 1 in user 16s partner list too. [image.png][image.png] How do…
-
Any Good Resources using the Crypto library?
In my endeavor to pull virtually every retail API that exists, I've learned A LOT about how API's function. Thanks to Xano, I've finally had the building blocks to learn more about how security works with APIs, such as generating tokens for calls, how Base64 encoding works, etc. What I'm up against now with some of the…
-
How to edit value of existing table record without fetching the record first?
Hi, I am trying to update a column value of a record on my table. I know Xano does full Object replacement but I wanted to know how I access the original value of the column before editing it. My current solution is to fetch the record and then use the dot notation to access its value. Is there a better approach that…
-
External storage
Is there a way to store user media such as photos, videos & audio in an external cloud storage? I'm planning on building an app like YouTube, so I have to use a cloud storage that offers unlimited storage plans.