-
Which is faster/better: an api endpoint that pulls from 9 tables or a task that does it every 2 mins
I am creating an app which has a homescreen that needs to pull data from roughly 9 tables. My current plan is to create a homescreen table that is refreshed with a background task every 2 minutes with the latest data from those 9 tables. That way the homescreen frontend api call only needs to pull from one table to load…
-
How do I get the content of a .txt file stored in my database?
For example, I have a .txt file saved in my database and would like to get its content. How do I get it? I only see the following: {path, name, type, size, mime, meta, url}, no body for the .txt file.
-
Automating workflow on record creation or update
Hi, I just started using Xano and I'd like to learn if it's possible for me to trigger a workflow on the creation or update of a record in the database? One of my uses cases requires the data in a field to be used in an (external) API call to receive a response that can be saved in another field. For example: let's say I…
-
How do I create a program that can schedule recurring dates
Hi all, I'm trying to build an application where the admin is able to schedule a program to recur based on the days of the week and the time. For instance, every Monday, Tuesday, and Thursday at 7 am, there is a breakfast offer. Could I get some help in building this? Such as how the database and API should be designed?…
-
How to execute a task that is running every minute but only at a specified time?
I have a task that is running every minute and have a slurry of functions to run but only at certain times. Essentially I want to write a condition that if current time is 1am for instance, execute my function once (it should only happen when that time is hit, every other minute that elapses after should not continue to…
-
What happens to a task if a loop fails a precondition?
I'm hoping that if my tasks hit a failed precondition, that they would just move on to the next item in the list. If it stops the task entirely, I'll have some re-engineering to do…
-
Create a task that updates a field with ChatGPT result
Hi guys, I have a band table with the fields "Name", "About_en" and "About_es" (and some others). I'd like Xano to have a task that identifies when a "About_en" is empty and use a merged pre-defined prhase to call ChatGPT api and save the result in "About_en" and translaton to "About_es". The phrase would be like "Describe…
-
Schedule workflows
Hi all I am an experienced Bubble user, considering using Xano as the backend for a new app. I am still learning, and here is something I don't know how to do. I'd like to proceed pre-scheduled workflows, with multiple action happening at different date & time, with conditions to proceed. Real life example (not my use…
-
Background Tasks - Can this be done
It's great that Xano provides a Background Tasks feature. I have a requirement and I wanted to understand if Xano's Background Tasks could handle this level of functionality. This is the outline spec: Get list of users that have registered during the previous 24 hours = newUsers.ToList(); foreach newUser in newUsers select…
-
What are common reasons that would cause a background task to timeout?
I am running a task using pagination and streamining to loop over 166,000 records and modify a field. The task is timing out after around 4 hours and then continues to run consume DB resources for some period of time. I am making 0 external API calls so I cant guess what I'm timing out. Is the total time a task can run…