-
How do I store Data from different external APIs and Airtables into one Master file?
Hi Everyone, How do I set up the database with the following use case: A user wants to get an analysis of a company. He/She, therefore, enters the company name. Let's call it "Google". The analysis of the company "google" can take several hours/ days; therefore, the Frontend does not need to give the answer to the "company…
-
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:
-
input for variable
Hi, im trying to create an input for the bounding box from this external api curl --get '' \ --data "tags=amenity%3Drestaurant" \ --data "api_key=XXXXXXXXXXX" \ --data "bbox=-87.6489,41.8503,-87.6008,41.9053" so i added %s instead of -87.6489,41.8503,-87.6008,41.9053 btw i can't find the correct input to get these 4…
-
Query authenticated table
In a function I authenticate the user through the table restaurant_owners, and inside the body I query another authenticated table that is restaurants, does it leads to potential problems? On test it works, but I believe there is something wrong as I didn't authenticate on the second table
-
Conditionally Update a field based on on an input value
Hi there Is there way a way to update a field on a record, but only if an input is set to a certain value? Details in loom. Thanks!
-
API Date Input Format
I have an API that takes ae Date as an input. I can't figure out how to format the date input value. Tried the attached but getting error. Thanks.
-
Pagination in combination with (external) filtering
Hi there, I have looked at the docs of external pagination and (external) filtering. I would like to know if pagination in Xano do take filtering into account. For example: I have 120 records paged by 20 records per page so I canfetch data for a total of 6 pages. But then I use a filter and only 56 records remain. Does…
-
External API Limit
I am considering using Xano for a project and would like to know if there are any limits on External API calls. I know the API for XANO is not rate limited, does this apply to external calls made from Xano as well? Thanks so much for your help.
-
Can Xano grab data from a web callback URL?
Hi Xano, I am currently trying to integrate Square's point of sale API with Xano - Originally I had planned to use a webhook where it would grab and utilise the data sent from Square. However, after some testing I have noticed Square adds the data onto your specified callback URL. I have provided an example below. EG.…
-
How to call RBAC APIs from the front end?
So I've made an Authentication required (RBAC) API for a call function(Image attached) and I'm not able to figure out how to call the API using a frontend like Weweb or bubble or even through swagger documentation.
-
Filter Addon / Conditional Addon
Hi there How do I filter which records are added-on in an addon? Details in somewhat wordy Loom, hope it makes sense. Thanks.
-
How to pass XML content when calling an External API
The attached file "bpack 24h … No options.txt" contains sample XML content that I would like to pass in the external API request below. Unfortunately I don't have a clue how to do it. Moreover, I have not found anything useful in the discussions.
-
Experience with OpenAI's Chat API?
With ChatGPT now being available via an API, I'm looking into adding it to my site and want to run everything through Xano both for the easy record keeping as well as the advanced API functionality. Everything is pretty straightforward but the one unique thing about the Chat API is that in order for their system to have…
-
How do I configure basic authentication credentials when calling an external API?
I am trying to create a shipping order in bpack (bpost) API. Basic authentication is required. The below configuration does not work. The response that I get is that "This request requires HTTP authentication". I have successfully tested the credentials in Hoppscotch testing tool. I am sure about the url, content-type,…
-
How to edit the last record created by a user ?
I would like to be able to edit the last record created by a user without using the id of the last record. Does anyone have any idea how to do this?
-
Error: ERROR_CODE_ACCESS_DENIED on public upload endpoint
Hello, I've submitted a support ticket but hoping someone may be around on the weekend to assist. We cannot upload to our website right now. We are uploading a file in an endpoint. There is a "Create attachment from file" action. The action keeps throwing a "ERROR_CODE_ACCESS_DENIED" and no idea why. We have not made any…
-
[Solved] Sending Boolean = True, getting "invalid" wont accept "1"
Hi guys, I am sending an API request Parameter as follows: isGlobal: true, isRollupReportingLocation: false, And Im getting the following returned: 400 Error location.IsGlobal: [The value '1' is not valid for IsGlobal.], location.IsRollupReportingLocation: [The value '0' is not valid for IsRollupReportingLocation.] Anyone…
-
Addon vs Join
I often have the option of referencing other tables via either Add-on (thur evals) or Joins. Which one should we prefer? Any criteria that can help us decide what fits more?
-
How do I use a Precondition with an Array?
I'm trying to write some permissions into my application, simply put getting a list of users who are allowed to edit a record. I have a basic list of users stored in array who have access, and I want to enforce a precondition that says if the users_id trying to edit the record is in the array, then they can edit. The…
-
How to filter out certain records based on a join / add-on
Hi there I'm a noob so please forgive what is likely a basic question. Refer to the attached images. I am trying to create an API that will return all Users that do not have a subsidy for an input business_id. As you can see, each subsidy record has both a user_id and a business_id. My API is getting all Users fine, and I…
-
Yousign API document pdf and create file in XANO (external request)
Hello, I had the same issue as the following post so I was 1. external API to Yousign as api_1 2. Create File ressource from api_1.response.result as file 3. Create Attachment from file However I end up with { message: Failed to execute } Any Idea ? Thanks,
-
Fuzzy search not finding this text
I have a table of football clubs. In a form, the user can type 2 or more characters to find matching records. The API uses fuzzy search in combination with a search index on the column - screenshots below. The column is 'ClubName'. The fuzzy search works fine, except when the text is 'no'. This works:…
-
keep tracking of EDIT method
Hello, before publishing my application, I am looking for a method to track data changes (CRUD EDIT). For example, a user changed their name or phone number in a table but I want to keep track of what they changed. Which method is correct and economical?
-
How to use the queried record's key as param for addon?
I am using the addon and want to use the value as param in the addon for where condition. Suppose I want to fetch the posts of users where post_type = unseen. The post type variable will be in user object. But I am not able to use the value from User object in addon. How can I acheive this?
-
Any standard way to ensure that non-existence of path does not result in an API error
Hi! In an array of objects, some elements might have a missing path (or diff structure) which leads to failing of the entire API. Can it be mitigated somehow? Eg: [{"id":1,"name":"alpha","score":90},{"id":2,"name":"beta"}] If I am running through a loop and accessing score path, I want my API to accept it as null/empty…
-
Neverbounce Integration with Xano, Wized and Webflow
Hey everyone, Here's my goal: I'd like to verify an email address when someone wants to sign up to my website, using Neverbounce API. - If the email is invalid, I want to display an error message - If the email is valide, I want to add the subcriber to Xano I'm using Webflow and Wized. I'm a newbie, and any tips on how to…
-
Help with configuring my xano endpoint u00220
Hello. I've been working with bubble and would like to shift some of my work over to Xano. I'm testing a use case that needs a very specific payload returned from an endpoint as below. {"0":{"type":0,"content":"0","bold":1,"align":1,"format":1}} I've used a variable to create this and the response from within xano is…
-
Help with API integration
Hi all, I am used to API but this one is being tough on us. We believe it won't work in Xano because content-lengh won't be same as in Postman event if we use the exact same parameters. If anyone already experienced that, we would appreciate the help ! Thank y'all
-
Help with 'Date Input' field
Hello, I have a question regarding date input fields. I have a database that will store transactions. I need the date_input field because the admin of my app needs to be able to input specific dates. In my api function stack, I need to be able to pull in all transactions for "next month" My client wants to be able to…
-
How to set dynamic path parameters on an external API?
Hi, I have this path url https://eclipse-java-sandbox.ukheshe.rocks/eclipse-conductor/rest/v1/tenants/tenantId/wallets/walletId \ I need to set this path /walletId \ to be a dynamic input from my user database. I have tried everything from using sprintf filters to replace, but I am unable to replace the walletId with the…