-
Lambda errors: Unable to use fetch API to post a file
Hello, I'm trying to use the fetch Javascript library on GitHub which is supported by Xano's lambda fetch function. I want to send a file through an API from Xano to an external destination. I've tried using the no-code approach for the REST API call but the issue is that I can only send images and PDF files with that…
-
Enum Contains?
Is it possible to use Query All condition to see if a Enum[] field contains a certain value? I try using plain text, but I get the error: Input requires enum[]. Currently set to text. Particularly, this is for roles[], and I want to check if the field contains a certain role.
-
Filtering records with mixed text case - issue
In my form a User can search by a text string called location. This is used in the Function Stack - Custom Query. User input = 'bristol' does not match the value in the DB 'Bristol', so I applied a Text filter - to_upper on both the input and the table column. This works in 'Run & Debug', but zero results are returned. Any…
-
in query all records, problem with join
I have a working custom function. I tried to add a join to pull in referenced table record. I am getting some kinds of reference error which i cant figure out. [FireShot Capture 093 - Xano - api2.zwsociety.com.png][FireShot Capture 094 - Xano - api2.zwsociety.com.png]
-
Uploading a video ends with a .binary file in the database!
If I am running the API in xano (Run & Debug) the video is uploaded to the database in the correct format, but if I am running the API from the front end, it works but store the video in .binary format which is not readable. Any support would be appreciated. Cheers! First screenshot: Running the API manually in xano.…
-
how to nest JSON inside "data:"{} object for POST fetch request?
I've created my own form in HTML+JS and sending a fetch request to my Xano Jobs DB. (I have prevented the default form handling and doing my own fetch request. It is working as it is sending the "created_at" date) From my JS code, my JSON object looks like the below snippet. How can I make it nested one level deeper inside…
-
Some clarifying questions about Response Caching
I've been looking into a lot of the documentation of Xano's Response Caching and it seems like it would be a very beneficial feature for my particular use (price comparison website) To quickly summarize my Xano use: I have a database of products which (through the use of external API's) are being updated every 2-12 hours…
-
HTTP Status code 0 in response
While calling external API, the following response is fetched: { "headers":[], "result":false, "status":0 } What does http status code 0 means?
-
Using queried data from DB for external API request
Hey, I'm looking to get open interest data from the Binance API for multiple ticker symbols from my existing database. My idea was to query those symbols and use sprintf to fill them in the API request. Example request https://fapi.binance.com/fapi/v1/openInterest?symbol=btcusdt…
-
Query that searches for value in array
With this table: user_to_account: • id: integer • user_id: integer • account_id: integer • roles: array[ ] Is it possible to to run a query database table that searches the roles[ ] field for something like "Super Admin"? I know how to do this with the array functions, but is it possible to do it with just one query.
-
Comparing two arrays and getting third array with mismatched elements from both of them [solved]
There are some topics here about arrays issues, but none of them was helpful enough to make me figure it out. So I have array A[1,2,3] and array B[1,4,3]. I want to compare them and receive array C[2,4] Additional question: Does variables in repeating task hold values from previous run before being overwritten by the new…
-
(Untitled)
To fill the database, I have a function that calls an external API. Sometimes, some data are not available and the response from the api is empty: [screenshot-2022.06.16-09_46_49.png]Unfortunately, in this case, an "Unable to locate var:" error is generated and the function stops without processing the whole import. So…
-
POST text with a line break
How to make Xano accept text with a line break? I'm sending a request from a text input field. And if I make a line break in the text, Xano will not accept this request. The text must be entire. But users can make line breaks for make text more readability. I use Adalo and have limited options. For example, the text that I…
-
Dealing with expired API token (retry flow)
I'm working with an API that is about to implement refresh tokens. The new tokens will not include an expiry date so the client is expected to simply refresh the token when an API call fails due to the token being expired, and then re-run the API call. Is there an easy way to deal with this in Xano? If not, does anyone…
-
Auth0 Xano-Bravo integration
Hi, I want to have social media login on my app (FB, google). So far I gave both login methods working on auth0.com, I have installed auth0 feature from marketplace and enable auth0 login in bravo. But I'm not sure how to integrate those two. Bravo have it's own login method using auth0, but I cannot figure out how to…
-
"An unknown error has occured"
So I've got this fairly complex function stack that deals with a somewhat messy XML response I get from an external API.[image.png]The overall goal of the stack is explained by: 1. Requesting an authentication token 2. Using that token to request a payload of data. 3. Cleaning up that payload to get right to the section…
-
API Call Not Authenticating?
I've got an external API that I'm trying to connect do that uses HTTP Basic Auth. I've tried connecting using the cURLs they have provided along with my ID & tokens and continue to get a 401 error. Here is the cURL I used:[image.png]Here is how Xano formatted it (along with me customizing the…
-
Add or edit DB record with data from external API
Hey, I have a database with price and symbol data from the Binance API. My function stack for that is attached. How do I update (add or edit) these records with data from the same API?[001304.png]
-
Using Modules with Lambdas
I am looking to use Lambdas with the supported Crypto library, but I am not sure how to do that. I tried to use "const crypto = require('crypto')" at the beginning of the script, but the response when I run and debug is: "Cannot find module 'crypto'"
-
Success with AWS Signatures?
I'm trying to pull in date from the Amazon Product API and Amazon requires me to request a signature and then use that signature in my next API call. I tried for months to accomplish this on Bubble and couldn't figure it out. Xano seems to have more of the building blocks in place to accomplish this but Amazon's…
-
Using External API to generate a token key?
I'm using an API that requires an "access token". This token is designed to expire every 60 minutes which means I'll need to build something into my workflow that generates a new key regularly. The service provider for this API provides documentation on how to generate this "access token". However, I'm first required to…
-
Token that never expires?
I'm trying to export some tables to google sheets using syncwith.com Works like a charm on an open API. Also works if I give it a token to use as authentication. Of course I want it as secure as possible and not have any open APIs. But since I want syncewith to be able to pull data every hour till the cows come home I need…
-
Treat API Input as a keyword vs exact phrase
I've got an API that queries all of the products in my database. I'd like to add the option for the user to search the names of the products but my current setup seems to force an exact match.[image.png]If I were to type in "LG" it would successfully show all of the products with the word "LG" in it. But if I typed in…
-
Hubspot to Xano
Hey is it possible to connect Xano to hubspot? Should we use the api key of hubspot or is there any integration partner to use? Please let me know I’m new to Xano.
-
Find first element issue
I use function that find Adalo user id by its email. This function was working fine until two days ago. Now I started getting wrong result of the function "Find first element of the array". At the input I have an email[Снимок экрана 2022-06-08 в 20.28.42.png] Then I make an API call to get all my Adalo users accounts and…
-
Xano not recognizing Microsoft Office Files through API
I am trying to allow uploads of various types through my front end. I have been able to successfully use the upload attachment endpoint for PDFs, but Xano doesn't seem able to interpret the type for office files, and therefore ends up without any metadata. Is there a way around this? Very possible I'm doing something…
-
Lambdas Help
Hello all, I am definitely out of my depth here and am wondering if what I am trying to achieve is possible before I put too much time and effort into it. I am using Paubox to send HIPAA-compliant email through my web app. I would like to send these emails using Lambdas and Nodemailer with Xano, but don't know if it is…
-
Can't figure out Sendgrid Dynamic Template setup
I am trying to create a code and email it to a user using sendgrid. I have read through all the docs but it's not fully spelled out step by step. I have created a dynamic template with `{{ resetCode }}` and tried putting it both in a text block and a code block:[image.png]I then created a json object with the…
-
Posting to Trello API
I’d like to take data I’m collecting in a table and post some of it to Trello to create a new card each time a new row is created from my Xano API. I’ve got the Trello API ready to go and the Xano table and API for data from my app’s form but I wondered what the best way of transforming my Xano API data and automatically…
-
Always getting 403 Error back
Hey guys, i just share the link to my previous Post. Because jo one answers in the other thread so i try it here to get help✨ I always grt 403 back when i try to make an authentication api call :/ Link to my original question