-
Creating Loop to update multiple records from an external API.
Hi Team, I'm trying to populate my database from an external API. Currently I have data coming in from an external API, and I'm able to update my database for a single database item. However I cannot get it to loop to create all the items within the response as items in the database. I've got it creating a variable which…
-
Xano - Memberstack Integration
Hello! I had copied the Webflow - Memberstack - Xano template awhile back, but have had trouble using it to move data for new members through the systems. After editing the "memberstack_member" query, I upgraded what I had from the marketplace today. I think I now have Version 6. Assuming that the update was successful, I…
-
API Not Recognizing List of Text as Input Parameter When Calling from External App
Would appreciate some help identifying how to correctly pass an array of text as an input parameter when making a call from outside Xano. I set up a test API with details below. This API that accepts a list of text values called "locations". [image.png] Then I set up a loop such that for each location in the input list,…
-
Limit on Query all Records
I see a way to sort and paginate inside the Query all Records function but I'm wondering if there is a way to limit the number of records being returned (with or without an input)? As a work-around, I added the following custom query… db: events.id ≤ 100000… but that doesn't seem like the right approach.
-
Environment Variable as Default Value?
Just to confirm an assumption I'm making: there is no way to reference an Environment Variable as the Default Value of an input, correct? I'm using the same default value in a few endpoints and I was hoping to have the option to change them all in one place. [environment_variable_default_value.png]
-
Object to Array
I have 2 query in my API. The first API will return results in object {"id":1,"id":2,"id":3} how can I turn these into an array so that I can use it on my next query to exclude? I assume I need to use subpath, but I can't loop each with something like results.*.id
-
(Untitled)
How do i connect my appgyver to Xano?
-
Not understanding cURL auth key instructions
All my past api calls have used an Authorization/Bearer format or added the key to the endpoint URL as a parameter. I've encountered a new kind of authorization format, and I'm not sure how to translate this into Xano: [image.png] I have the API key in question. I just don't know how to put it into Xano. , any chance…
-
Fail to Manipulate External API Data
I'm trying to manipulate some data from an external API. Here's an excerpt of the JSON input: { "query": { "email": "xxx", "queryType": "EmailIPRisk", "count": 1, "created": "2021-08-11T17:39:59Z", "lang": "en-US", "responseCount": 1, "billaddress": "xxx", "billcity": "xxxx", "billcountry": "xx", "billpostal": "xxx",…
-
How do we catch exception?
We are using the Stripe API, when duplicate products are inserted, an exception will be thrown by the Stripe API. We need to catch it and continue the script, instead of breaking it. On a sidenote, how do we export database or backup? Thanks Joe
-
External API - URL Dynamic
https://api.domain.com/v1/io/6109dbc4946c8b7f5c10dc20/chats 6109dbc4946c8b7f5c10dc20 - is a variable parameter of an external api call https://api.domain.com/v1/io//chats How do I set a dynamic value in the url of an external api call instead of a fixed one, as shown in the examples below:…
-
External APIs with Oath 2.0
Is it possible to make a request to an external API that needs Oauth 2.0? I have this example request in curl: curl -F "client_secret=$CLIENT_SECRET" -F "client_id=$CLIENT_ID" -F "grant_type=client_credentials" -F "scope=your.store" https://login.domain.com/oauth/v2/token But I didn't find a way to send this parameters…
-
302 response with location
Hi Team Is it possible to return a 302 (redirect status) with a custom url to a browser that is connecting to the Xano api?
-
API & Caching
I have xano db api endpoint that shows the results sort by random, I was wondering can I cache this random results with user id? so that every time when the same person query, the sort results (sort randomly) is the same
-
Logic to check whether API output contains a field?
Hello! I've set up a an external API endpoint to get data from Airtable. If a field is blank in Airtable, the json response will not include that field at all, rather than sending it as null. Is there a way to set up a condition in Xano to check whether the Airtable result contains a certain field to handle these separate…
-
Setting up an API call with child objects
Hi Everyone! I am pretty new to Xano, and I am trying to integrate a couple of different restaurant ordering systems to have all the data in one place and create some internal tools. One thing that I still don´t know how to approach are the modifications to the automated API endpoints. I would like to create an endpoint…
-
Showing available rooms using time slot filtering
Hey everyone! I'm trying to display all available meeting rooms with a condition of only showing meeting rooms that are not booked for a user given time period Some context : Booking table contains startTime, endTime and meetingRoom Id Meeting room table contains information relevant to the room like name, pictures etc…
-
Errors adding data to table from External API
Hi! I'm setting up an external API to pull data from Airtable by following the steps in this video: https://www.youtube.com/watch?v=rdnuW2Vg8aA I'm able to get the first two steps to work (fetching data and creating a new variable with the results). However, when I try to add the records, nothing is added to the database.…
-
Query API with Geo
Hi, I would like to under how can I pull the data based on distance 1. I have input call username, which user will supply username 2. I do a function stack to query user location based this username and I return the location data only 3. ? 4. I should add the return location data as part of my next query with distance…
-
How to update an object array?
Hi ! Starting a new thread here for questions about object arrays. Original thread was here: https://community.xano.com/c/apis/update-a-list-from-a-table-using-api I was able to follow your instructions on how to update an object array: https://www.loom.com/share/2c37acf093b8476e8ca8497301c4a56d Next, I'm trying to…
-
Result / Debugger Panel Empty After Run
Hi! I set up an external API with a While Loop to run the GET endpoint multiple times with an offset in order to get all 400+ records (since Airtable limits you to 100 records per call). The API itself works correctly, and everything looks right in my Xano table. However, at the end of the run, I get a blank Result /…
-
Using Custom Functions in POST Endpoints
Hello! I've reviewed your Custom Function tutorial, yet I'm running into errors when trying to add Custom Functions in a POST endpoint. The Custom Function runs successfully, and the POST endpoint without the Custom Function incorporated runs successfully. However when I add the Custom Function to the POST stack, it claims…
-
Updating Array with API
Hi Guys, hope you can help. I try to update and array in the user table field called portfolio_id with an id that gets generated from a newly created record in the portfolio table by doing a merge,so keeping existing values and adding a new value. What is strange is that it does not want to work when I make use of the var…
-
Hi, is it possible to create a new table using the API?
-
Data not displaying in Webflow
I went through How to display data from external API in Webflow - Part 1, and for hours I've been trying to get the data to show to no avail. I've compared the code of my implementation and the example, and the only differences are the paths. I took a look at the console and found these errors. After reviewing the code…
-
Date submission error
I'm attempting to post a date to Xano, but it is consistently returning 0. I have successfully done it before in the past using the date formats as suggested in the following post: https://docs.xano.com/data-manipulation/timestamp I have tried submitting Unix timestamps as strings and numbers, and all combinations of the…
-
How can I test my changes before the publish to the production?
Hi all, I am about to publish my app. I am just wondering, how can I make a change to the API without affecting the production? I mean, I am gonna have a change request or support for a bug, and I try to resolve the issue, but by the way, my expected solution can affect existing system flows. I should make sure my solution…
-
Copy API Endpoint
Maybe I missed something obvious but how do you copy an API endpoint from one API Group to another?
-
How do I append a record to a listed object?
I finally figured out how to edit the event_id record in the member table with the event_id found in the event_reservation table. But, each time a user RSVPed for an event, the current event_id record in member gets replaced with the even_id of the new reservation. Users will make multiple reservations over the time of…
-
Session?
Hi I would like to set some cookies with a session id in the frontend, is there any best practice to store the session key and value in xano database? can I set a TTL in the session table and the database will auto prune it periodically? If not, does xano has a scheduler to trigger jobs that can delete them ? Regards Joe