-
How can I make a count/aggregate on object's array
Hi there, I need help setting up a query that includes a count of an object column within a database table. The set-up: I have a database called "notifications" Each notification has a column called "reactions" This column is an array of an object. Each reaction being for example an object containing userID, date, … so in…
-
File resource duplicates object
Hey everyone, hope you're doing well. I have an issue apparently caused by a file resource. I have this input that is a list of objects The data I send from the frontend is this I then do a loop on the variations list to perform the desired action, but I'm being confronted with the loop running twice even I just sent one…
-
Simple Post request on Twitter
Hi All, I am new here. I was wondering if there are tutorials regarding an External API request that need OAuth 2.0 . I want to post a tweet from XANO but I find it confusing when it comes to authentication. I manage to make API calls only the ones that do not need authentication. Any help is welcome.
-
Help! I've hit a brick wall with a bulk update function
Hi. I am completely new to xano and I'm struggling to understand it. I was using adalo for an MVP build but hit a wall because the database functionality in adalo didn't support bulk updates. So I'm hoping I can achieve what I want to do in Xano. My app is essentially a to-do list that will break down a big goal (or…
-
Associative table X Object type field
I have the following question. I have a Contacts table and I want to be able to add various types of data (email and phone numbers) to the contact. The phone field ("value") will have many lookups. "contactId": 1 "type" : "phone" "value" : "+55891278917" "contactId": 1 "type" : "phone" "value" : "+55082738233" "contactId":…
-
Best practices for utilizing workspaces
Hello, Xano community! I'm seeking advice on best practices for utilizing workspaces. Specifically, I'm interested in understanding whether it's recommended to divide a platform into multiple services or modules, each residing in its own workspace. For example, one workspace is dedicated to user and permission management…
-
Exporting a txt file?
I have an requirement that I must export data as a .txt file. Is it possible to do this in Xano? If it's not possible to do it natively in Xano, is there a workaround to export it? Thanks
-
Help with Dynamic Population
Hi there. I am trying to dynamically populate a webflow project. I have a query parameter "?id=[integer]" at the end of my URL. This integer will match the "programID" value of each object. So, if the query param is "?id=1" then only objects who have a programID value of 1 will be populated onto the page. Below is my…
-
🚨 How to make Stripe billing and auto tax work on Xano api stripe checkout session. Not working!
I'm trying to following the stripe docs for adding billing_address_collection & automatic_tax but for some reason it always returns these as false and null and not sure what I'm doing wrong! I've copied this: into Xano like this: But doesn't return this in the response:
-
flutterflow com Xano
Bom dia todos bem? Espero que sim. Alguém poderia me ajudar? Serei grato. Estou desenvolvendo um app no flutterflow e usando o Xano como backend. No Xano criei algumas tabelas relacionais, e dentro dessa tabela tenho uma coluna onde insiro uma lista de id's e outra onde só trago um id (ex:- o criador daquele item). Na…
-
Adding specific data to record only once when 1st object in list is created 🧐
[ {"type": "preface", "body": "some paragraph"}, {"type": "chapter_1", "body": "some paragraph2"}, {"type": "chapter_2", "body": "some paragraph3"}, {"type": "chapter_3", "body": "some paragraph3"} ]My function stack adds one record (1 object at a time), then queries all records. But I need to add the preface content only…
-
Flutterwave or DPO Payments Integration
Has anyone tried integrating with either Flutterwave or DPO, some guidance would be much appreciated.😃
-
Build a custom sitemap with Xano?
My Bubble website uses Xano to populate all of it's product pages. So for example the URLs look like the following: domain.com/product/565 domain.com/product/985 domain.com/product/1183 domain.com/product/89 When the page is loaded on Bubble, it knows to make an API call to Xano looking for the ID in the URL (So…
-
Creating tagging system in Flutterflow
Hello, I would like to create a tagging system in Flutterflow. For every item in the table there would be string tags to select from the list of custom tags created by the user. The user would be able to create, edit and delete the tags. It would be perfect to filter with any tag also. My idea was to do UI in a form of…
-
Post with array input cannot have lambda in function stack?
I have a POST endpoint that is ingesting webhooks from a third party (wrike). The payloads are a single array like this: [ { "title": "Follow up on status of RFI with Architects", "taskId": "IEACIWZSKQZGQVIU", "oldValue": "Follow up on status of RFI with Architect", "eventType": "TaskTitleChanged", "webhookId":…
-
Why would a background task not complete when ran as cron but complete when ran manually
I have a task that modifies a list of records. When i run this, it takes 30 seconds, roughly. When it's ran as a cron it wont finish and will sometimes invoke itself several times before finishing any single invocation. the task is relatively simple but you can see here that it runs for long periods of time without…
-
How do I create an object from two lists with repeated items?
Hi all, I have the following two tables: [0,0,1,0,0,1,0] and [a,b,c,d,e,f] and I would want the following object: {0:[a,b,d,f],1:[c,e]} That is, I want items in the first list to become the keys (0 and 1) and corresponding items in the other list to become the values and where the items in the first list are repeated,…
-
Can anyone help? I need to execute a jar file to generate a digital signature. Willing to pay!
I need to execute a jar file to generate a digital signature. I have excellent documentation for the jar file signature process and subsequent APIs. I can likely handle everything after obtaining the digital signature (see below). My specific ask is for help obtaining the digital signature by executing the jar file in or…
-
Is it possible to get the most recent record for each group?
Hi everyone! I have a table candidate link to tables order and worker. Each line in this table candidate have different status like: I want to make a query all request filtered by "where order_id = input.order_id" to fetch only the candidates of a specific order. But I want to only have one record per worker_id so I can…
-
Searching for Xano experts from Ukraine!
I recently started a project on Xano and I'm looking for a mentor or consultant to help me get to grips with the tool faster and solve some hot issues. If you have experience with more than one project in Xano and you are from Ukraine, write to me on Telegram or if you have such acquaintances - share the contact. Thanks!…
-
Question about dynamically populating pages.
So I recently realized that rendering data on a page from a backend like xano would result in either a nondescriptive URL path, or an uncrawlable query parameter by search engines. For example, (with a token) example.com/user-profiles example.com/user-profiles?id=239487234987 I've created a marketplace using webflow and…
-
simple query to get a set of search terms
A big challenges of a query is to get useful information from flawed user input.. The fuzzy search tool is really amazing at doing just that. But synonyms and spelling may still present challenges to users especially on mobile devices. I would like to generate a list of words that a user could tap on their screen to…
-
How to correctly save Markdown in Xano Database?
I am trying to save markdown in a textfield in Xano and render it in React with react-markdown. If I copy my markdown into the text field it does not get rendered correctly. If I hardcode the same markdown and use it as input for my Renderer it works just fine. I don't have any filters on the text field in the Database. I…