-
Need help
Hi there, I have one scenario in which i am stuck in which i need help/suggestions. The scenario is i used an xano api end point as a webhook url at docdown outgoing webhook, so docdown can post the document to xano end point that i am getting already as a multipart form data as well pdf url. Now i need to submit that…
-
Query return only last record (transaction) of each customer and product?
I have the following scenario: DATABASE TRANSACTION: 1- CLIENT A - PRODUCT A 2- CLIENT A - PRODUCT A 3- CLIENT B - PRODUCT A 4 - CLIENT C - PRODUCT B 5- CLIENT D - PRODUCT A 6- CLIENT D - PRODUCT A Every time the customer tries to buy and the purchase is refused, it generates a transaction, but it is for the same product.…
-
Data Architecture for Social Network - Would Love Input
I can schedule a virtual office meeting if preferable, but I think this would be an interesting thing to talk through with others... I'm wondering how Xano would suggest building some basic "friending" interactions. Current Databases 1. Users (Authenticated) 2. Posts1. All posts have a "sender" and "recipient." I will be…
-
Can i create unify API for different platforms?
Hi all! I want to create a service which will provide unified API for different platforms and I have some questions: • Can I create my own URL for API calls? For example, I want use https://mysite-name.com/api:fjF6GKKx/methon, not https://xrrck-inu6-aersl.f2.xano.io • What should I pay attention to when creating such a…
-
Array not returning unique values
I am attempting to return an array of unique values after a DB search down 1 column I am running into an odd issue where the unique filter is not filtering out the non-uniques? [Screen Shot 2022-05-06 at 1.08.50 PM.png][Screen Shot 2022-05-06 at 1.05.03 PM.png]
-
How do I catch an error from a function and continue running
[Screenshot 2022-04-28 at 4.14.50 PM.png]I'm calling a function from a task. How do I catch errors with an if-else and let the task continue to run? Thanks in advance.
-
Regular Expressions
Hi. I have this expression that I use to test for invalid email addresses. /^[A-Za-z0-9.-_]+@([A-Za-z0-9.-]+\.)[A-Za-z0-9-]+$/ It works fine except for a case where it matches abc@abc@abc.com, where there are 2 @s I have tested this regular expression on https://regex101.com/ and it works as expected. ie not matching…
-
Schedule external API call in advance
I'd like to trigger a message to my users about 7 working days before the end of the month. How should I go about configuring this in Xano? Tasks seem to only allow being configured to a single setting.
-
number of decimal places
[Captura de Tela 2022-04-25 às 18.12.46.png]Is there any way to set the number of decimal places. After using the subtraction filter it generated several decimal places. I would like it to be only 2 decimal places like the other values.
-
Lambda questions
First, Hooray for the Xano team and pushing out this power tool! I have some technical questions that may be of interest to the community as well: 1. What version of NodeJS does the lambda use? 2. What is the maximum code size of a lambda? 3. What is the maximum execution time of a lambda? 4. What is the way to return…
-
Terminating a background task
Hi everyone! Is there a way to terminate a background task that is currently running?
-
Get all records query with multiple search terms
I have a table with a text field with comma separated values. I want to GET ALL RECORDS from that table based on values submitting by a user. User input is JSON with 1 to 10(?) text values. Presently those values live in an array. I'm having trouble working with the conditional statement(s) in the table query. The user…
-
Automatically Linking different records
Hello, I am importing data from airtable into Xano. And within this, there will be people imported that are linked to companies. I am wondering if there is a way within Xano, that once the person is in the Xano database it automatically links them to the correct company. I have a photo attached below, which shows that when…
-
GDPR compliant and hosting in EU.
To use Xano for clients from larger companies i get questions about GDPR and if the hosting is inside EU. How far away is the checking of the final boxes for full GDPR? https://docs.xano.com/faq Will there be any hosting inside the EU?
-
Can we export data?
Hi all, We need to export live data source data and import into test data source. Is it somthing possible? Looking forward. Thanks
-
Save data in test data source
Hello All, I have a function that calls external api & get some results from them. That result we need to save in test data source. Please guide us. Thanks
-
Which data visualisation and reporting apps work best with Xano?
I'm a big fan of using Google Data Studio with BiqQuery and other integrated data sources. Is there a way to hook up Xano database data with Data Studio for real-time reports or is there some other platform others recommend, such as Tableau, PowerBI or something else? Open to suggestions. I saw the retool demo which looked…
-
External API is not working
Hello there, Hope you guys doing great. This below curl code is from postman it's working fine in postman, command line. But when in imports it into xano it's not working & returing the result false and status 0 always. Please help me to fix it. curl -X GET…
-
Webhooks Square Payment
Hi all, can you help me figuring out how to post the values to Xano from the below body { "merchant_id": "MLFYKPT2MHVND", "type": "payment.created", "event_id": "43980995-1fee-4d75-b040-3e885f241716", "created_at": "2022-04-11T13:41:46.691413241Z", "data": { "type": "payment", "id": "KkAkhdMsgzn59SM8A89WgKwekxLZY",…
-
Ordering columns in Xano
Does ordering columns in Xano UI changes the location of the field in the actual database? Based on the article below will the ordering of columns, allow me to save space in Xano. https://docs.gitlab.com/ee/development/ordering_table_columns.html
-
Export to PDF
Hi does anyone have a recommendation for generating PDF output from Xano? Thanks.
-
SMTP - could I use my own email server from Xano
Hi there, my app only sends a few transactional user emails, e.g., forgotten password. Could I connect to my own SMTP server from Xano? Or, alternatively, is there a service which connects to your own SMTP service via an REST API? Thank you and best regards Joerg
-
Can't get basic Lambda function to work
In my Lambda function I only had return "hello"; I got: Exception: Unable to locate input: return "hello";[Screen Shot 2022-04-01 at 21.13.28 PM.png]
-
Datasource in different branch
Hi all, We have setup different branch for development purpose now. The question is new branch still using the live database. So how we can change the datasource for different branches. So test data would not affact live datasource. We have few functions which we directly run at xano through xano platform, so there are no…
-
Best practise for test env & production
Hello guys, We need to setup test or development env and production env. So easliy work on dev env and push changes to production env. Please suggest or guide us to achieve this within our current workspace. Looking forward to hear you soon. Thanks
-
Image related question
Hello All, My apologies if this is an old question that's already answered. My question is, if I have lot's of images for my website needs, does Xano let me have a CDN?
-
Appending to a text variable
I'm constructing a text variable by appending a mix of static texts and variables to it. I'm using the `sprintf` filter to do so. It works well but it gets a little cumbersome after a few variables. Is there a better (more flexible) way to achieve this use case? [Screen Shot 2022-03-08 at 8.27.34 PM.png]
-
Best way to get the output of an API in a task?
I have a task that posts a report daily to Slack. The content of that report comes from Xano endpoints. Should I be using the “External API Request” in that case, even though it's all inside my Xano workspace (see screenshot attached)?[Screen Shot 2022-03-08 at 2.22.22 PM.png]
-
Query Json Column
Hi there, I was exploring xano, in my table, I've column type json, I want to query that column, lets the column stores data like tags e.g. ["xano","lowcode"], so if I query "xano" it should return all the records having tag xano
-
Xano x Outseta x Bubble
Hi there! Has anyone built their SaaS product using Xano x Outseta x Bubble. I have been playing around with Xano and Bubble for a couple of months now but having been introduced to Outseta this seems to make a lot of sense. The purpose of each tool would be: Outseta - Authorizations, subscriptions/billing, email marketing…