-
Help - {message: Unable to locate var: OYS-SNH.Academy_password}
Hello everyone, I have been through all the similar issues with my Headline Challenge, but I haven't been able to fix my issue. It has been 5 days now and I still get the same error. What am I doing wrong? This is a password field. I have followed the tutorial on YT but only I get this error. Who can help me so I can…
-
Record update with dynamic inputs
I'm trying to make a partial update of my user record with only what is sent by the frontend. I know the PATCH method has something to do with that but I'm not able to implement it. The workaround solution I implemented is not clean, lot of conditions etc... Please help on this. Thanks!
-
Update a list from a table using API
Have a table (source) the has a list reference from another table (program). How can I update the program list in the source using API? Have source_id and program_id as inputs. Thanks in advance, Emilio[update_table_list_reference_061421.jpg]
-
WMX Webbook for New Member
Hi Xano team, I'm unable to get the webhook to work properly for the /memberstack_member endpoint. All environment variables (Webflow, Memberstack, Xano) have been setup and the Memberstack form is validated (I can successfully create a new member from Webflow, but the new member does not trigger the webhook). I also…
-
External API passing arguments
Hi, I have looked at a couple of videos on passing arguments to external apis. One talks about pasting curl string and the other talks about a scenario where there is one argument and then using sprintf. In my case api-path/function?varname= number, number & key= How would I go about this. Thx
-
friendly api endpoint
it would be nice to develop and test our app with a nice api like api.domain.com/path/to/my/endpoint. When we migrate to launch we don't have to do through renaming endpoint or endpoint group. is this currently part of custom domain and is that in launch or scale. I have domains on AWS and so would like to point my…
-
How can I make the authToken last longer than a day before expiring?
Hello, I have this issue where after a day of inactivity, the authToken generated upon sign-in expires, making all the authenticated APIs return empty values with HTTP 401 error messages like this: {"code":"ERROR_CODE_UNAUTHORIZED","message":"The token expired."}. I've set up caching on my auth/me API to 7 days (which…
-
Numbers with commas
Hi All, A very simple problem I have. How do I return numbers with commas esp if I'm dealing with costs. Xano posts something like this 563892 while I need it returned as 563,892. I'm using Bravo Studio as the front end.
-
Extracting objects from an object array of specific indices
I have an array of numbers, say A. I have a different object array B and want to filter objects of only those indices which are the elements of A. I am trying to use for loop : for each "item" of A, Add to C (New variable which is type Array), those elements of B whose index = item I am unable to get this right. Can you…
-
Batch POST data
Hi there, I currently use another no-code automation tool called Integromat(aka Make) to do some GET requests. At the moment I write this data to a Bubble DB which allows for a maximum of 1000 records to be created in 1 POST request. Just wondering if Xano has a similar capability? and if so how do I setup an end point to…
-
API gateway
How can we set a easy gateway url to access the API much like one sets up API gateway for lambdas in AWS?
-
Bubble.io: Accessing Local Storage plugin from Reusable Header to Log Out a user
I use Xano as my backend and Bubble as my frontend. Based on Michael's videos, I also use the Local Storage Bubble plugin. I'm stuck on logging out and have a question: I've created a reusable Header in Bubble to hold all my navigation controls so that I only need to make changes to the header in one place and have it…
-
Table access authorization
My context is using authorizers to access AWS API's using an authentication token from client side. If we have authenticated on Xano using the user table to achieve the equivalence, so we just turn on authentication on all tables for which we have API's and pass Authorization in the header of the API?
-
Table search text control access via API
how can i tap into text search that is there on tables via API. I have looked at Custom Query but still not so clear on it. Thanks
-
adding auth endpoint
When adding auth endpoint, I see a request for "Column" and password. I assume the password is where you select the password column from the table. What is the column field? Furthermore if I want add sms based auth and say google auth, would I clone the auth api group with the 3 endpoints and point them to a different user…
-
stack function pipeline using results from previous step
[FireShot Capture 105 - Xano - x8ki-letl-twmt.n7.xano.io.png]I am creting a DB function stack. First function does query all and searches on two fields other than the id field and returns the results in a variable. I want to then check to see if I have one or more results from the previous step (i am using has db…
-
conditional set filters. extending idea to images
I followed the first video in this tutorial on how to set conditionals. The twist is I am trying to update images if the the image file field is non-empty. I am not getting an update. Here is the reference tutorial [FireShot Capture 050 - Xano - x8ki-letl-twmt.n7.xano.io.png][FireShot Capture 051 - Xano -…
-
returning error codes
I was looking at some references on how to return error codes. I noticed pre-conditions have fields for error_message; not sure how to use these. Further, I tried to create using utility response to create status variables to return codes but could not see how to do so. Not sure what the best scheme is of detecting errors,…
-
Empty "" text is considered null? Why?
If I use the following JSON input, Xano considers the name [text] field to be null. Why? { "id": 1, "name": "" } In other programming languages, I can set a variable to be = "", and this is different than null. I'm attempting to keep or edit the value of a text db field. If the user clears the data on the front end, the…
-
interactions with referenced fields
My primary table A has a field references a attribute table B which has list of string which reference different attributes that the field in table A can take on e.g. "eat", "walk", "sleep", i.e. +. I am not using enum types here. In an API to table A, can I create/update this field using text instead of the number. In the…
-
Does upload image still require swagger
I was going through this video on uploading media. Do I still need swagger and if not is there a newer document I should be looking at Thx
-
Join vs References
If I have two tables with a common key I can do a join. Are references designed to support a graph database approach. Is there a preferred approach here or a combined approach one could take?
-
searching a table with two keys
I am creating an api to search a table based on two inputs. In the stack what do I need to do?
-
How to use a API to upload image
I have created an API following the instructions and have tested using swagger. I can upload the image. I am trying to embedd this in Draftbit where I have a base 64 image variable. How should I assign the the image variable in the json body?
-
Run function after api is done running
I have some image manipulation that needs to happen. It's a heavy load that involves external API's. I want to run a function every time a new row is added to a table. I know I can do this with tasks, based on a repeat interval and just keep checking for new records over and over. But, is there a way to run a function…
-
Use string variable result as sub path; no code.
I have a string variable. I'd like to use that string value as the subpath of a variable in an "update variable function" Can I do this somehow in Xano? I need it to look something like this in no code, where I can use the result of foo as the sub path of module. var foo = "bar"; $var.module[foo] = "something else"; //…
-
Pagination Still on despite being turned off?
So this is really weird -- The pagination is on when the data is accessed externally: This is what Bubble sees: [image.png]This is what XANO sees: [image.png][image.png]
-
Bypass Unable to locate var on External API
Hello, im getting results from an external api and i did a loop for each to insert records in the db but the problem is some of the API data have some values and some of the items dont. is it possible to ignore if a item doesnt have the var available. maybe with a filter? thank you
-
A better way to edit/replace an on many to many post?
I am hoping to find a better way to update/replace/delete records on a many to many relationship POST in the api... There are 3 tables: • user: • id • name • email • property:• id • name • address • users_to_properties• id • user_id: table reference • property_id: table reference • property_user_role: enum •…
-
Query all records by searching on all fields in a table
Is it possible to configure a search on a query all records action across all fields in a database table without needing to specify each field to search on? It would work similar to the internal Xano search function we have when viewing database tables. I note that we can select the entire db table when configuring search…