-
External vs "Internal" Filtering
I'm curious to know the difference between using the "External Query" feature vs the way I have it currently setup (let's call it "Internal") [image.png][image.png] You can see that I have several input parameters that allow me to query the database exactly as I'd like to. Via my front-end site (Bubble) depending on…
-
REST Countries API
Hey all, I am working on a bubble app and need a list of countries and regions. I am looking at using this API https://restcountries.com/. Strangely, I can't find authentication info. I believe I need some Header Keys and Values? Also, should I be making this call directly from bubble or through Xano somehow?
-
How to "sign a string" in Xano?
I'm trying to connect to the Walmart Affiliate API and there are 4 headers I need: • Key Version (which is simply the number "1") • Consumer ID (a unique number Walmart has given me) • Timestamp (the current time, in Unix epoch time which Xano automatically does) • Generated Signature (The signature generated using the…
-
Is it safe to for a function stack to run for 30-60 seconds?
Hello guys, I have an endpoint meant to receive webhooks from form submissions in Tally. Once the webhook is triggered, there is a bunch operations needed to be done: 1. Formatting the webhook inputs into desired JSON structure 2. Updating database in Xano 3. Uploading files to Google Drive (this takes the most time) This…
-
Stripe signature snippet?
I’ve integrated stripe checkout and I am working on the webhook for events. Is there an example or snippet of verifying the signature that I can easily integrate?
-
how to calculate Content-Length (external API)
Hi everyone, I need to POST a JSON object to an external API but I am getting a 411 (length required). I tried a simple hack of pushing Content-Length: 0 into the headers array, but the external API doesn't want to let me off easy, so I think I have to calculate the actual length of the object. How do I do this? Any help…
-
Need help with Google Drive API multipart upload
Hello guys, I'm playing around with Google Drive API to upload files and got the simple upload working. However I can't seem to get the multipart upload to work. My best guess is that the culprit is the way Xano sends the request body over when making the external API call. Here's the link to the Google Drive API upload:…
-
GET is Your Friend in Xano When Posting to Custom Fields in HighLevel
Hey and thank you for your assistance during yesterday's office hours in helping come to solutions of what I wanted to accomplish. I do apologize that I was not clear, the idea in my head was not being communicated clearly by mouth, even then you guys did an excellent job of steering me in the right direction, thank…
-
Dynamic API Response
Hi, I'm relatively new to xano, so perhaps I've missed something..... I'm paging/looping an API response where some 'keys' are not present for each array/loop. Where I'm using the missing key to extract and populate a database field an error is thrown to suggest that the Key is missing. What is the best way of handling…
-
Xano - Bulk Add Record - Change ID Field to Another Variable Name
Change the 'ID' field into another variable from a GET request, name so that ID can be changed and used again when making POST request to frontend. Couple of Improvements Needed. Ray Deck 1. Could the function be refactored to be more efficient? I think so, but don't know how. 2. Not posting duplicate data to the database.…
-
external api request
when i call a xano api as an external api, is it collocated so it is not a remote call?
-
API input params - nullable option
i have an update API where one or more fields are optional. If a field is not defined I don't do anything. If it is defined, I want to be able to pass values that essentially reset fields in the db i.e. string, array, object, date. Also, I see a nullable field but I am not sure how to use it and how it figures into my…
-
Tables Relationship - Auto Link Fields
Tables: • user• posts • post• created_by How to make the created_by field automatically select the user when I add the post from the user side?
-
Debugging env vars?
What's the best way to debug what's happening when using env vars like $request_uri? I don't see it in the request history and neither the debug console nor swagger seem to hit the same uri?
-
Real Time Database
Hi there! I am currently using backendless and Adalo to build an app. I have recently discovered that I can't subscribe to the backendless data via REST, so I don't always get the latest data. How does this work with Xano? If I do a request for data via REST, will it always return all the data including the latest records?…
-
SUPER interesting Get
Hey squad, I have a question... I have a table for 'events'. The events table has a Date column (and a timestamp column. Focus on Dates here though). There can be multiple events on the same Date. I'm trying to run a Get function to bring back only dates of Events, without duplicate dates. I can currently bring back all…
-
Modify response to include change metadata
Is there an easy or standard way to respond to a POST request that performs an Add or Edit so that we can indicate the difference between what was added and edited? For example, I want to send back a simple response that says: { recordsReceived: 13, recordsAdded: 3, recordsChanged: 10 } Is any of this exposed in the OUTPUT…
-
Including User_ID along with formData
I'm looking to create a form to allow users to upload an image. I've successfully built the API endpoint and tested it using Swagger, now just trying to figure out the front-end piece. I believe the code below works for capturing the uploaded image from the form and sending it via to my endpoint, but I'm not sure how to…
-
Simple authenticated file storage and integration with Xano
Is there a simple service out there that I can integrate with Xano which allows my users to upload a file and make it so that the file can only be accessed by certain other users in Xano? I'm using WeWeb as my front end, and Xano as my database. I have looked into AWS s3, but its more confusing than anything I've ever read…
-
Tasks - Best Practice / How to run at specific time
Hi Community, I want to be able to run a function at certain times during the day. Let's say 10am and 4pm. I can only choose 6 hourly which means it will execute the function at 10pm and 4am also (which is unnecessary as it also emails users as a apart of this task) For some reason Xano only allow a very limited amount of…
-
GET: referenced table list/count with user auth
Hey folks, I've tried to follow a couple videos but struggling to make the pieces work properly. My setup is along the following: Table A - Users Table B - Dogs Table C - Food My need is to GET the list/count of records of 'Food', where the Food table references the Dogs table. The Dogs table references Users table, so…
-
Crypto usage in Lambda
I'm trying to write a function to create a JWT token using lambda function where I'm using Crypto library to generate token. One of the statement in the function is: const stringifiedHeader = crypto.enc.Utf8.parse(JSON.stringify(tokenHeader)); I'm getting following error: Cannot read properties of undefined (reading…
-
FlutterFlow and Xano authentication
I've just started on an app in FlutterFlow. I'm having trouble understanding how to set it up to use Xano autentication. Anyone done this and can point me in the right direction?
-
Adverts
Hi All, Has anyone tried integrating ads into their logic? Just curious if I can run some native ads (twitter style) that smooth into my lists after every x number of items. Thanks.
-
Is it possible to Forward email to Xano Webhook
Hi community - I have a business that has multiple different ways of receiving orders - and one of those ways is by receiving en email to a certain address. Is it possible to forward that email (to a webhook?) to trigger a post request in Xano which will add the body of the email to the Xano database? Or can anyone think…
-
3rd party external API - filter results. HELP
Hello community, I am working with a third-party , Looking to properly filter the results that I am obtaining. I properly set up the API call and created a viable to determine and drill down to the results I'm looking to work with and save in database. [Screen Shot 2022-07-03 at 11.15.15 AM.png] I'm looking to filter…
-
XANO API authentication
Hey guys ! My Xano workspace shows users table & API properly set up. When I run & debug "POST auth/login" from Xano screen, I do get successful feedback including precious authToken. Yet trying from front end Appgyver I'm failing to login : HTTP response 400 "code": "ERROR_CODE_INPUT_ERROR", "message": "Missing param:…
-
API GET with body…
Hi Champions, I would love to get help from you: I'm trying to connect with an external API – GET with Body (Not a POST). You can find the API documentation here: https://hexowatch.com/api-documentation/ I've tested this in postman and I'm able to get a response. This is the cURL: curl --location --request GET…
-
Postman Request Returns Body, Xano API Missing Response Body
Hey All, I have a working request in Postman. The response in Postman includes the "body", where the download URL is located. Takes about 8-14 seconds for that response to come back from the external service. Importing the cURL out of Postman, into Xano, how can I get Xano to capture the "body"? Curl Request: curl…
-
Auth ID in Lambda
Can you access auth.id in Lambda functions? I tried $var.auth.id and $auth.id, neither worked.