-
How to sort with umlauts and upper/lowercase words?
Hi, I want to use order by but I am getting not the results I am expecting. Following wrong output is given: Biologie BWL Zoologie eHealth Ägyptologie What I would expect is something like this: Ägyptologie Biologie BWL eHealth Zoologie
-
Can't loop through an input array of objects
I have an input constituentContacts, which is an array of objects I have a foreach loop on constituentContacts as contact, but contact seems to be empty. when I try to extract a value like contact.first_name, it throws an error what did i do wrong ? see capture
-
Adding multiple records in one transaction
Currently, when I need to add multiple records to a table, I am doing it one record at a time. We are only talking maybe a max of 20 records. Is that acceptable from a performance perspective? Is there a way to add multiple records in one transaction? Thanks.
-
10 second limit on "Post Process" function ?
Hi, We've recently implemented an api with the "Post Process" function in the function stack. Our intention was to put a long running operation (loop of web callouts) in the "Post Process" and then store the result of all the callouts in the Xano Database. The issue we've run into, is that in both prod and dev, the Post…
-
Get the records only belonging to a specific user
Hi everyone, I'm quite new on using Xano and I'm struggling on set up an API to get all records belonging to a specific user. I've a 3 tables on my DB (user, workspace and content) Every user, after signing up, have to create a workspace to start creating a content. Every workspace can have multiple users (ideally with…
-
Uploading files to S3
I'm trying to upload the files stored on Xano to S3. When I test the AWS api through Postman I attach the binary file and it works. In Xano I tried putting the path and the url of the file as the parameter. It does create a file in my bucket as well, however it’s missing the content (the file object) itself and it’s just a…
-
How to account for an empty value?
So I've got an enternal API that I'm pulling data from and because there are multiple pages of data in these calls I will need to do some pagination. This particular API I'm working with has a field that they print in the API called "nextCursorMark" with a value next to it. It's basically the bookmark ID to tell the next…
-
how to remove quotes ""
I have a function stack that is returning the value that I need for another function but for some reason it is surrounded in quotes "" , How do I remove these quotes so I can proceed this is the function that is causing the error I believe @Michael Udinski
-
How to update a record in a POST call that has multiple inputs and I want to be able to pass only th
Currently I have a POST endpoint that has several inputs and I would like to be able to pass to the API only the input I want to update. Example: API inputs: email, name, phone Body request: {"name": "User name here"} If I execute the call in the example above, the name field will update. However, the other two input…
-
Invalidate auth token?
Is there a way to invalidate a user's auth token when they log out of your application? What about revoking all active tokens for a user? And for how long is the token received on login valid?
-
Quickbooks says Xano endpoint URL not valid
I am trying to set up Quickbooks Online OAuth flow, and when I try to add my webhook to Quickbooks to receive the token they send back, they are saying the Xano endpoint URL is invalid (b/c of the colon). Any quick way around this issue?
-
Debug mode from external call ?
I've observed that when I run an Endpoint in Debug mode, the "$request_uri" environment variable contains a url like this: /api:mvp-admin/query/XXXX/debug This leads me to believe that it would be possible to execute calls in debug mode and take advantage of draft execution by using an external tool such as 'Postman' to…
-
How to submit multiple email addresses to Sendgrid
Hi everyone I am trying to figure out how to update the 'sendgrid_dynamic_send' custom function to allow me to input multiple email addresses in either the To or CC field. According to Sengrid's documentation, both fields support multiple email addresses. Each one must be submitted as an object, along with an optional name…
-
Query parameters vs json body?
I'm not quite clear on how I set query parameters in the url, vs creating a JSON body in a POST request. Which would this create, and how do I create the other one for this example? [image.png]
-
Can't Use/Debug Google OAuth from Xano
Hi! Would love your help solving this pickle. I'm building an app on Wized, and I'm trying to debug the Google OAuth flow directly in Xano so I can see full responses and tokens. No matter what I do, I can't seem to get a valid response from google (invalid_grand, malformed auth code), see my steps below. What am I…
-
Forgot password
I keep getting this error I'm using the Magic Link Authentication using Sendgrid for email
-
Noob Question: One API Endpoint or Multiple?
Let's say I have a table called /products with 4,000 items. On the front of my site, all of the main searching & filtering will go directly through the /products API endpoint. But let's say I have other uses of that table, such as: Finding the average price of products that meet certain criteria. Finding the top 5 products…
-
Pagination - page 0 and 1 are returning the same records
Hi, @Michael Udinski @Chris Coleman So I was working with Flutterflow trying to integrate queries from xano with infinite scroll and I noticed that page 0 and page 1 are both returning the first batch of records. Is that a bug or a normal behaviour for some reason? Here is Loom:
-
Response times slow with Response Caching enabled
Hi everyone, I have an endpoint with a processing response time that was quite high, taking around 1-2 seconds on average. The variety of calls that it receives, however, is small, with only a dozen or so variations. So I turned on 'Response Caching'. I expected processing response times to reduce but, here's what they…
-
Magic Link Passwordless - magic link could not be created
I implemented Magic Link passwordless, following the video by Prakash and set-up all the variables in the Settings page. I get an error when I used the magic link page to login. The message in Xano: Even though the magic-link is not created, part of the login process works, e.g. a value is created in the magic_link record…
-
Filtering using a custom query, unexpected handling of AND condition
Perhaps my logic is failing me here, but I'm struggling with what I would deem, a very basic function - that is to filter on two boolean fields, whilst allowing NULL. In essence, I have two fields: isActive, isTrial. For my GET API, these fields are both parameters that allow null. My goal is quite simple - allowing a NULL…
-
How external API requests work in a functional stack
If I add an external API request in the middle of a stack at Step X, will my functional stack wait for a response from this API request before going further or it will just hit and move forward? I have an API (used to send a Whatsapp message) that sometimes takes time. Its response is irrelevant to the rest of the stack. I…
-
How do i GET data with parameters
Hi all, new to this whole API thing as i have been working with bubble.io for practically my entire no-code journey. Here's the problem: Im currently working on xano-draftbit and have no problem GETting all records or a single record. But how do i work with getting a list of records with a parameters? I can't seem to find…
-
Clearing redis cache on a query on new data or data change
Hey guys, I just enabled caching for the first time on a query (GET endpoint) level via the interface, see screenshot. Now I am wondering, can I also force a cache clearing for this query (GET endpoint), if e.g. a user hits a POST endpoint and adds a new data row? Right now, I have the problem that my query uses an Addon…
-
Magic Link Sign-up questions
I want to implement Magic Link with Sendgrid. I have two questions. Within my Instances I have three Workspaces. I have one client project taking-up two workspaces and my other project occupies a third. If I install the magic link extension, is it installed only in the single Workspace or across the whole Instance? 2. My…
-
Xano - AD (Active Directory) Integration
Good morning, I am in a special integration of authentication of a central portal, it must be integrated with AD for users to log in. Is there any way to connect or integrate an Active Directory in Azure with Xano and have the users authenticate? PS: the front end being used for this POC is WeWeb. Thanks.
-
Creating a complex Sign Up API endpoint
Hi, I am new to xano (coming from bubble where i had the app working). I am trying to adapt the provided sign up API endpoint to enable me to add information to multiple tables at the same time but ultimately referencing the user and organisation. The sign up is to sign up a new organisation which includes multiple…
-
How to ignore error " Unable to locate var: XYZ"
I have some external function in function stack, and it can return object with "result.data" or "result.error". How can I add condition to ignore if func. returns "result.error" object? I tried to work around "result.data" is empty or undefined etc.. and looks like each time system is trying to read missing var.
-
Invalid a access token
A auth token was stolen from a user by an unknown party, so i wanna destroy it and generate a new one, does anyone know how i can invalided a auth token?
-
How to set availability with date and time using Draftbit?
I want to set certain available date and time slots in the app, so that users can book that time and once someone books one slot it will not be shown again, using Draftbit as frontend. For example: One doctor is available on 10/06/2023 from 9am to 11am, considering each bookings to be 15 minutes there should be 8 time…