-
Auto-complete / references
Hi all, I am using a ledger DB list to link two DB lists. I wish that ledger DB list to offer an auto complete label that sources the name value of one of these two DB lists. But it seems I can only use the ID as label - am I missing something?
-
DB: How to create a PRIMARY(!) Foreign Key Relationship?
Dear Community, I am new to XANO but consider myself quite a good database engineer. There is one database design scenario that might not work with XANO - and I just want to make sure if I am right or if I just didn't figure it out: Imagine the following design where the [Id] of the [Staff] table exists as a (blue) PRIMARY…
-
What is an efficient way to store a bunch of booleans?
Hi everyone! I have a form on the front end that push some data and a bunch of booleans in it. The data structure looks like this: base data (user, role, date, etc.) and around 70 booleans from checkboxes. What is the best way to store data like this? I need to be able to query data and make aggregate functions by these…
-
How do I get the content of a .txt file stored in my database?
For example, I have a .txt file saved in my database and would like to get its content. How do I get it? I only see the following: {path, name, type, size, mime, meta, url}, no body for the .txt file.
-
How to return a list that's within a geographic region (with a twist)
I'm trying to return a list of items that's within a certain geographic region and am using the polygon feature to mark out the area. I can accomplish that however, I also want to return the items if no location on that item was given(i.e. it was bought online) - which I can't seem to get. So essentially its: return all…
-
Integrating TensorFlow Data Validation (TFDV) with Xano File Upload Endpoint?
Hello everyone- I am indeed a noob, but excited that I discovered Xano! I'm aiming to create a smart file upload endpoint with TFX that leverages TensorFlow Data Validation (TFDV) for data anomaly detection and correction. Here's what I think the process might look like: Install TFDV (pip install…
-
Google Auth "Precondition failed"
Hello everyone, I'm encountering an error, I'm trying to use Google auth for the connection type to my application but I get an error when I try to configure the "Continue" Hello everyone, I'm encountering an error, I'm trying to use Google auth for the connection type to my application but I get an error when I try to…
-
Response addon
Hi everyone ! I have got a little problem with the construction of an api answer. I have got a product with a list of supplements. I created a list-type addon to return my supplement information. Everything works perfectly but in my response array I get the id's. This is annoying in my frontend and prevents me from…
-
is it possible to return HTTP response code 409?
Hi there, My API should return the 409 code if there is a duplicate in the table. But the only option that I found to change the response code is a precondition that doesn't have a 409 code.
-
What can be wrong?
i am getting this error when i try to use my sign up endpoint: Whoops! An error occurred.Exception: Unable to locate input: email
-
In the database it is a list of JSON but in the function stack it says it requieres a JSON (no list)
Hi, I created a field in my database called "variant_errors" which is a list of json objects. However, when I try to push a json object to it, I see the "input requieres JSON. Currently set to any[]" message. See below: What am I doing wrong here? Thanks!
-
Returning data from an integer table reference column
Hello, I am trying to return data from a referenced table column and not just the integer. I am using a WeWeb plug in for Xano backend. In my table #1, I have references to a record in table #2 in Column X. I am calling data in table #1 in weweb, and for column X, I am trying to get data of that row in table #2, but it…
-
Problem with receiving all records
Hello, I am having trouble building a messaging system right now. I have a user input that, when entered, returns a record that includes both the user and the message recipient. I want to create a solution when I am signed in, I want to see the username of the other person, but if they log in, I want them to see my…
-
Update password enpoint : no validation happens.
I recreated Update password endpoint from scratch, and I remember I used to have validation for password string. Now I don't have it, but in table for password field there are some requirements. This is my new password update endopint. I have success when saving empty password. And this is DB:
-
Add records to object property
I am trying out the structure of having an invoice with invoice lines in a object property (list type). What I can't figure out is how to add records to the object (list) property. Does it need to be a JSON Array string? Or can I add record and map properties using the function stack?
-
How can I update an attachment field inside an object array?
I am currently using Weweb as my frontend. I have a data table called "Dispatch Ticket". It has an object field called "task" and within this task, there are multiple fields and one of it is the attachment field. FYI, I have added a "task_id" field as a unique index of this object. What is the best API call that includes…
-
Find a key/value in a json object
I am wondering if there is a universal way to find an element within an object without knowing the path. E.g. get the "id" value, without knowing the top level of the object (one/two/three). { "one": { "from": { "id": 123 } }} { "two": { "from": { "id": 123 } }} { "three": { "from": { "id": 123 } }} What is known and…
-
How to change fields in an object with for each loop and conditional if?
Hi, I want to loop through the fields in an object and set fields with a null value to contain the string "empty" instead. I'm trying to do it like this: But when I hit the stop and debug, all the null fields in the object are still null. What am I doing wrong here? Thanks in advance.
-
Debug section doesn't show all Function Stack
Hi, Somehow I cannot see the rest of my Function Stack in the debugging section. E.g. I wanna see what's going on on step 11, and it doesn't show up. Any pointers on why this is happening? Thanks!
-
Sending a Slack Message via Xano - How to escape \n markdown in Xano?
I am trying to send a slack chat notification via Xano. I can successfully send a slack message using the external API request function in Xano using a POST. As part of the POST you need to send through a JSON body with a value of... { "text": "This is my text to send\nmy second line" }No matter what I do the newline…
-
Distinct records
Hey everyone one, hope you’re doing well. I have an issue. I have a variation table linked to a product table via a product_id field. I wanted to query all variations, paginate and sort them by the product name so I joined the product table to be able to do so. I then noticed that I had some variations repeating within two…
-
Posting into an array via API
Hi, I'm currently working with an post API call, which I would like to post into an array with each row being separate. I have my db set up with an field called Risk_1 (type: object/Structure: single). Within this I then have two fields "What could go wrong" and "Who is at risk" (type: text/ Structure: list). I've tried…
-
Append suffix to integer value inside object array
Hi community, I'm currently working on this workout logger app, where frontend sends repetitions and weight values in the form of integer to Xano. The issue I'm having is, that I would like to add a measurement unit suffix to the weight value received from the frontend. Ex.: Frontend send to Xano: 99. Xano returns to…
-
Using the Unique filter on an array of arrays.
Hi. I'm looking through data that needs me to go through an array that looks like the below [[a,b,c],[c,b,a],[a,b],[c,d],[d,a],[d,a],[c,a]] and from this data lift unique groupings and count them so that we have [a,b,c] = 2 [d,a] = 2 [a,b] = 1 [c,a] = 1 [c,d] = 1 I've used the unique filter on the main array hoping to get…
-
Creating product comparison pages in Webflow
Hey all, I run a user generated review site that's hosted on Webflow. I have just under 800 projects listed on the site. One of the key functionalities I don't have is the ability for users to compare product A and Product B. Think simsilar to the linked page below. https://www.g2.com/compare/asana-vs-wrike Is there a way…
-
How to fetch data within object array?
Hello, I am currently having a problem trying to fetch all users’ posts. I have a nested database where everything is within one table. The table looks like this: { Username Email Password Posts [{ Text Image Tags Comments [{ User_id Text }] }] } The user can have multiple posts. I will provide my function stack and the…
-
How to count the number of characters in a text?
Hi, Is there a filter or something to count the number of characters in a text? Example: "Hello" count characters = 5 Thanks!
-
Is it possible to create invoice pdf with pdfmonkey
Before I start exploring my self how to do it, I was wondering: Is it possible to generate a invoice pdf using pdfmonkey API I am thinking of the following. Data: In Xano I have an invoice that belongs to a client and has multiple related invoice lines. Xano API: Post invoice Id or invoice number to Xano. Xano fetches the…
-
Does Xano support Basic Authentication?
Basic authentication simply means the application sends a username and password with every request, and those credentials are also often stored or saved on the device. Does Xano support this? From the documentation of the api that I'm working on, to get the access token, header should be created like this: Authorization:…
-
Handling JSON array inputs
I have a list of id's being passed from my front end, and when I copy the inputs this is the format they are arriving in: {"idList":"[4,5,6]","lessonID":"6","idListRef":"[1,2,3]"} The result is empty, which is not right. If I copy and past how it is received into the run and debug and remove the "" around the [], like…