-
Download as CSV using the xano snippet endpoint
I have an array with several objects that I would like to download as a CSV. On review I noticed some objects don't have all the fields. They seem to be missing the same field. I've been using xano for a month or so now and I continue to be impressed by the functionality. It looks to me like there must be a way to Add a…
-
Programmatically set API Request params from input
Hi, I'm new to Xano and trying to build a function that takes a params object as an input and maps it to the params of an API Request. My input is as follows: "Type: object"; "Structure: single" I tested the input using an object such as: { "page":1, "pageSize":1 } I then add the params variable to the API Request in the…
-
Troubleshooting YouTube URL trim/delarg
Hey crew, I'm having some unexpected trouble trimming a url. Here is a 2-min video. Thanks for any help! Here's the quick video:
-
Need Help Creating My First CRON JOB for Automatic Product Price Updates from an External API
Hello community, I'm in the process of creating my first CRON JOB and I could use some help. My goal is to automatically update the prices of the products in my database using an external API. In my database, each product has a unique identifier known as a SKUID. This SKUID is a required parameter for the API request.…
-
minUpperAlpha filter not in my CONFIGURE INPUT menu
@Michael I am trying to add a filter onto password input, like you did into Password Reset video https://youtu.be/L1tmWuR6u6Y but it is not in my option list when I am configuring my filter. and on my screen only this
-
Blank records added from POST
Trying to add records from a POST but i keep getting blank records added rather than the data. if i put the data in manually with debug it works. json post is { "name": "John Doe", "age": 30, "city": "New York", "occupation": "Software Engineer"} any help is appreciated, it's driving me mad
-
How can i find all elements in array and remove them?
Hi Community, I'm stuck (again 🙂). I have an array of objects (royalties_per_book). I use the Find All Elements function to find all objects matching my expression and store them in another array (publisher_aggregated). After that, I want to delete the found objects from the first array but I can't figure that out. I tried…
-
Custom domain with godaddy
Hey yall. I'm setting up custom domain and Xano said to "Make sure to set the TTL to 5 minutes (300 seconds)." But I'm on Godaddy and minimum TTL allowed is 600 seconds. Any issue with the TTL being 600 seconds? Thanks!
-
problem with precondition when using password
@Michael Udinski Hi, I have a problem in my /update_password api when using 'password' and 'confirm_password'. If the inputs are 'text' type everything runs, if select a 'password' type then the Precondition returns an error message "Password don't match!". In am sure the input:password==input:confirm_password and my two…
-
Convert an audio file (.ogg) to binary file
Hi, I want to build an endpoint where I receive an audio file (.ogg) and must return the same file but converted to binary file as a response. Is it possible to do this with Xano? How? Thanks!
-
JSON object update
Hi there! I have a pretty complex structure in the db for one of my cell. It's a json object with this configuration: sites: [ {"_id": "1", "name": "My site 1" }, {"_id": "2", "name": "My site 2" } ] I have a request with "site_id" and "form_name" inputs. What i am trying to do is to find the site based on input "site_id",…
-
Why am I getting "API name already in use"
As far as I can tell, there should be no issue between the 2 GET endpoints `/project` and `/project/actives`, I don't understand why this leads to an error.
-
Client dashboard - data on UK server only?
Hi all I've got a request to build a gated client dashboard and a pricing calculator into a Webflow website. The data on the client dashboard must be held on UK servers and only served from UK servers as it will contain sensitive client information. It must never at any point be passed through servers outside of the UK.…
-
? How to make Stripe billing and auto tax work on Xano api stripe checkout session. Not working!
I'm trying to following the stripe docs for adding billing_address_collection & automatic_tax but for some reason it always returns these as false and null and not sure what I'm doing wrong! I've copied this: into Xano like this: But doesn't return this in the response:
-
Staging feature
Hey everyone, hope you’re doing good. I have a question about working at the staging state of my app. I have a new feature being implemented but not ready for production yet. The feature requires one or two fields to be updated on a database table. But the point is can I update a database table without repercussions on the…
-
after filtering, export pdf from xano to my pc
Good morning, I store in a table a "storage" type field for pdfs. I'm trying to export all of these pdfs from xano to my computer after filtering them, but I can't. I saw that you could download the file by clicking on the small document next to the field, but for a hundred records, it may take a long time. I tried after…
-
Having issues with a simple Query all records function
I'm duplicating an already existing endpoint that gets a list of surveys that are sent to a coach by their athletes. This new get request gets the surveys, but now I need it to only return surveys that are sent from athletes in a certain group. Athletes have a table reference for group, and there is a team_groups_id input…
-
Displaying an image in a front end
I just posted this comment elsewhere (sorry!), but just now saw the "Noob" section, where it probably properly goes. I'm a beginner, and trying to display images in Weweb, using the Xano template backend (the one for photo sharing/liking). All of the "data display" elements in Weweb have trouble displaying the data that I…
-
Is it possible to convert an object into an array?
Hello, I need help with converting objects into arrays. I am using the Get All Input(webhooks), which worked for some of my objects but not all. I have provided pictures of the results I have received.
-
Using unique filter on an array with multiple objects
Hi. I am creating a function stack that takes an array with objects that have around 20 elements each from an API call. The objective is to grab 2-3 elements and use that to create aggregates. The data source is for transactions meaning many to many, one to many and many to one relationships exist. One of the outputs I'm…
-
Google Sign In using Xano and FlutterFlow
Hi ! I am building a mobile app in FlutterFlow and I am using Xano as my backend. I want to use Xano Google Oauth apis for authentication in my mobile app. Can anyone help me with that?
-
Lambda function error
Hello everyone, I am currently experiencing difficulties accessing the lambda functions and would greatly appreciate your assistance. Here is a breakdown of the steps involved: Step 1: I provide the 'file resource' input. Step 2: I utilize the Get File Resource Data operation, targeting the file resource input, to convert…
-
Math filter in "query all records"
I am trying to find a way to do the following: 1. There is a db with columns A and B 2. I want to get only the records where A/B>0.2 3. B values are sometimes 0, so I am using AND condition where B>0 and A/B>0.2 (with "div" math filter). But the result of this query is very far from the truth. What's the catch? Thanks.
-
Airtable Import
Hello I just did an airtable import and everything it is perfect. I would like to know if this will update when I add new data in airtable or I have to do something extra. Thanks
-
Two related tables: Users and Properties - API setup question
Properties table contains a field that allows multiple user IDs. When I attempt to get all records under the Properties table where the User ID is present in this field, it only returns a single record (even though there are three). This is probably something to do with my response/output, but I need a little guidance.
-
Support for asynchronous function stack statements
Hello, Would it possible to provide an example of how to run statements in parallel through Lambda Promises? For my usecase, I'm trying to respond an immediate 200 OK response to the Slack API (must be within 3 seconds) before continuing the rest of my function (that takes about 10 seconds). Without the immediate 200 OK…
-
Need help with objects/lists?
Hi all, Working on adding some group functionality to my app. It's a youth sports app where coaches and athletes get assigned to a team. Now I need to add groups within those teams. I added a [team groups] table where I am linking Team ID and then adding the respective name of the groups. The issue now is really how I…
-
Table id reference - when is it a good idea? - Got users but should i have a teams table?
Hi, I have a users table for auth, inside I have a table ref to a "managers table" My plan was to then have a user_id ref to the user table in the managers table as a list to create teams. In my head i feel it makes it more streamlined to get data for employee tables in the front end however, i also feel that it then makes…
-
Auth ID is not visible in request details
Hi there. I'm stuck with this, any request is successfully made with user authentication but the auth id is not showing in the request details. I've tested authtokens in the api "auth/me" and the user data is appearing normally, including the Auth ID linked to the user. The APIs in use are all enabled with authentication…
-
What format should I use to POST a date ?
Hello, I'm using Xano with Bravo Studio to build a sports app. For this occasion, I need to POST the date of the event, which is a field that comes from Bravo Studio. To do this, I've created my POST request which expects a "Date" value as input, however, I don't know what test data to use for the request to work in Xano.…