-
Sending JSON from Bubble to XANO
Is it possible to send a JSON file from Bubble i.e. [{"Object 1"},{"Object 2"},{"Object 3"}] to Xano and then have Xano convert the JSON into a CSV that the Bubble user can then download from their browser? I'm aware of the snippets that are built for this process. What I can not figure out is how to do it on Bubbles end.…
-
Bearer with auth process
Hi, Am I assuming correctly that to use the Bearer token for authenticated API calls, I need to have first the auth of user working? I tested the Bearer without the user auth and it seems not to be working? Thank you.
-
REST API request witn NTLM auth
Hello. How to get into Xano JSON-data from server via REST API (http get) request with NTLM user auth ?
-
Adding variable in response of call
Hi guys! When running a query of all records, I'd like to add a variable that counts the number of sub-lists of things I get via doing an inner join. Example: List of Makers, inner join with Cars. We end up with the list of cars by makers. Now in the API call, I want to sort the list of makers based on the numbers of cars…
-
Webflow form submissions
Many know that Webflow allows a single webhook for form submissions. It's not like separate webhooks for every form. One webhook for ALL your forms. I've got more than a few forms where users create and update information. I capture the form name from the various forms when there is a submitted form in the JSON. I will be…
-
Filter array
Hello, I'm making a query of an array of locations. I then want to get back all the records that have one of these locations. Right now I have a setup using contains but this does not work. It always checks if the whole array is contained in the record. Each record always has only one location and not multiples. How can I…
-
Images not Saving
Hi, When uploading files to XANO via "file resource", the images are not appearing in the Database, I see them in the JSON response, and the image is in the vault, but when I do a GET to check the images, they are not there, it seems they are uploaded but somehow loose the connection to the DB. Anyone experiencing same?…
-
My "clone" displaying date from 3rd party
I'm working with the [How to display data from external API in Webflow - Part 1] model but with a different source for the data. I cloned the Github js and made modifications that reflect my API endpoint. Debugging I get no errors or warnings with the exception of this Memberstack (I think?) notification "Audit usage of…
-
How to check if response in certain format?
I have an external api that return object as { "error":"abc"} if the request occurs and the actual json if there is a result. How do I check is "error" is returned? I see that there no filter called isDefined or something like that? Can you help?
-
Pagination not working
I have some problems getting pagination to work. 1st Problem: When I activate pagination with metadata it returns no results (But there are 300+ records in the database): [Bildschirmfoto 2022-01-29 um 11.00.31.png]Result:[Bildschirmfoto 2022-01-29 um 11.02.11.png]Remark: "Account_connection" is an add-on I am using in…
-
From XANO to S3
Hi, is it possible to send files from XANO to S3? AWS or WASABI? Thank you very much.
-
Filter by tags in a list
I have setup a database with multiple tags in a list (guidedmicrofilter_id): [Screenshot 2022-01-24 at 23.20.29.png]I want to fetch guided_exercises if they include a tag. I have tried with a filter like this: [Screenshot 2022-01-24 at 23.20.18.png]But this then gives me this error: [Screenshot 2022-01-24 at…
-
Complex integrations - Auth libraries
Hello Guys, Happy new year to all! I went through a couple of complex integrations with Xano and it would be amazing if you could add the entire libraries for auth like the ones listed here from postman as filters or functions (I am using Oauth 1.0 -> Garmin and AWS Signature (for amazon Selling Partner APIs) regularly. In…
-
many functions vs. one big one?
curious if there are "best practice" approaches to this... both from a development standpoint and a Xano standpoint: I've been working with single big functions based on categories (session funtions, member functions, etc.) Particular sub-functions are found via if/then and request= inputs. But they tend to get quite long.…
-
Large Json Files
Hey guys, I created an API that adds records to a table from a json record list. Everything goes very well when I send up to 1000 records in json. When I send larger files, with 5,000 records for example, the API response time gets huge, it returns a runtime error message and, when I go to see the database, it saves 3…
-
Get a single record from a database filtered by category_id and then randomised id
I have a list of prompts that are all categorised. I want to set up an API to GET a single record, randomly, from a specific category. I can easily filter by category ID and fetch a list of all prompts, but I can't see how to only select one from within that category and randomise which is picked. Any help much…
-
Customize fields returned from a query dynamically
Would it be possible to customize which fields to return from a query through code? On our front end, there's an ability to customize the fields shown. Currently, we use dynamic SQL (SQL Server) to construct the query and dictate the fields to return. I can do the same thing with Xano by looping through each record, then…
-
Auth0 - management API tokens
I wanted to get management API tokens for Auth0, so that i can update user profile pictures, first name, last name etc. How should i be getting these Management API tokens into auth0? the issue is that these tokens last for several hours, so can be used multiple times.
-
Connecting object with its self
Hello I am new here. I wanted to connected a user table with its self. Basically, a user with an another user from the same table. When I do so in the database, the input for the connection only takes one key, ie., the ID. Hence it takes just that for any API for CRUD operations. [image.png] It shows the drop down when I…
-
Bubble + Xano user auth
Hey guys! I managed to do the entire user authentication flow in Bubble. But and now? How should I proceed to send the authentication token to the browser Cookies and how can I get it back to validate the token? I want to keep the entire user authentication process in Xano.
-
Authorize.net
Hi, Does anyone has experiences to share about integrating Authorize.net for payment processing, session, and checkout management?
-
External filtering
I'm trying to send a request with external filtering, but in the end I always get all the records from the table. Can anyone help? This is the json I'm sending: { "query": { "external": { "expression": [ { "statement": { "left": { "tag": "col", "operand": "system_module.deleted" }, "op": "=", "right": { "operand": false }…
-
Is_in_polygon
apologies if something is not precise as I have no experience with polygons I found a function that allows you to calculate distance between two latlong, I was wondering if you would be able to also a function to check if the latlong below to pologon defined as an n element array of latlong. I think it is possible now to…
-
Filter an API call based on object created time
I have an API that calls a large amount of user inputted data that I want to paginate by time. For this I need to edit my current API that calls all data by user and make a version that calls only entries made in on the current day, and a version that calls only entries made in the current week. I have got as far as…
-
External API Request via function with input queried from database
I am building a function that would be fired from an incoming post that would take some of the input data in addition to retrieve some data from database tables in Xano to ultimately compile a post request with these compiled values. Below is example of the data needing to be compiled (and not the entire API request). How…
-
API Memberstack_member [POST]
The tag line to this API says "Syncs Memberstack member to Webflow and Xano. Optionally create items based on membership." That sounds promising for what I'd like to do - synchronize specific data in a Webflow CMS when a record in the Webflow CMS is updated with data in the Xano tables. I've search around a bit and do not…
-
Using Xano as full backend with database for high volume API Synchronization (100K records per day)
Hi there, we have been working with on an API sync to import and synchronize a high volume of listings (100K listings synced everyday and 20K listings imported everyday) using Xano to run the scripts and then sending/updating data in Bubble. We faced issued with the debugger for data matching, as we have numerous data…
-
add list of table reference
Hi, Can you help me about this ? I have a column, table reference list in integer When i try to add one or some link in stack , there is an error : requires a scalar value, I try append, push, but i can't find how do this ? In my external API, i receive a Booking, connect to a rental, I add my booking in the table, but i…
-
User Authentication API
Hello! I'm trying to set up user authentication in my xano backend. I found the tutorial in the documentation, but I don't have the "auth"-API endpoints. From what I understand I should have added them at the beginning of the project setup. Is this correct? Is there a way to add it also later in the project? What can I do?…
-
One auth for 2 api groups
Hello! I have my main api group with user AUTH in my application. When I add new template form marketplace it creates new user DB and the new API group which also has its own auth. I want user to authorize only once in the app? what should I do with these api groups? I would merge all 3 groups into one with same auth…