-
Google Sheets API: Import Data to Xano
Hi all! I just launched a new Snippet and tutorial, which covers importing data from a Google Sheets spreadsheet to Xano via the Google Sheets API. There are a lot of variables and nuances that can go into this depending on your spreadsheet format and size. This Snippet and tutorial are designed to give you an educational…
-
Snippets
-
Add filters on Xano snippets page
I think I'm not the only one, but I think it would be more practical to add the filters of search, date selection, category, ... etc. On the snippets page to facilitate its use by the community because it's impossible to find a feature 😡 Also try to clean up so as not to limit the appearance of test snippets. Which…
-
Flutterwave or DPO Payments Integration
Has anyone tried integrating with either Flutterwave or DPO, some guidance would be much appreciated.😃
-
I SOLVED THE REGEX SYNTAX!!!!
@Lachlan McPherson I figured it out!!!! Here's the situation… I needed to be able to take a numbered list and break each sentence generated in the numbered list. However, whenever there were non-letter or numeric characters like "''.?/" it would cause my syntax to only return a partial sentence, leaving the rest of my work…
-
OpenAI Examples
Learn the basics of using the OpenAI API with Xano with three examples. Here's how to get started: Snippet Video walk-through Instructions: how to add a snippet The snippet contains: GET /review_generator: an endpoint from to create a review of a restaurant GET /recipe-creator: an endpoint from that generates a recipe from…
-
Filter Response
I have the following response from my database as part of a larger dataset. How would one filter this to only include the offers where type (which is an enum) === "product"? I have gone round and round and can't seem to find the best way to create a variable with only the product offers.…
-
One-Time Password (4-digit code) log in with SMS Text
We built this Snippet during a recent office hours session. Use it to send your users a random 4-digit code via text for them to authenticate with. Snippet: https://www.xano.com/snippet/gORBRj22/
-
Can I share or copy an API between my workspaces?
How can I share or copy an API between my workspaces?
-
Mailparser : Raw email to object
After having some trouble parsing emails in Xano and seeing that I wasn't the only one, here's a snippet that I'm sharing that will help you parse an email received from a webhook or download a raw email (ex: from an S3 bucket or any other URL): https://www.xano.com/snippet/UbdFLSlf/ 2 groups : Download from URL Receive…
-
Filter Query All Records with an Enum value
Filter a Query All Records function using an Enum value. Snippet: https://www.xano.com/snippet/K9BrwRIt Video walk-through: https://www.loom.com/share/1ca1e49cbbab47d3a96af1ae3149f050 Instructions: how to add a snippet It features: TABLE sandwich: a table of sandwiches with the bread used and a list of ingredients. GET…
-
Can't find installed snippet
I am trying to use a Xano snippet from a CRM weweb template but although I get a message saying it's completed, there's nothing in Xano. Where can I find my installed snippet? (https://www.xano.com/snippet/do5gPVyN/)
-
Stripe Secure Webhook
Secure your data sent from Stripe to Xano via webhook, following Stripe's recommended approach for manual verification described here: If you are new to connecting Stripe to Xano, start with the Stripe Checkout template. Then, follow the instructions below to install this snippet. Here's how to get started: Snippet: Video…
-
Rightpad function
Pad text from the right using this custom function. Here's how to use it: Snippet: https://www.xano.com/snippet/GdqgTOBm Video walk-through: https://www.loom.com/share/e3ce9730cbee4dfe8a6097bb0fa8498d Instructions: how to add a snippet It features: GET /rightpad: an endnode that takes inputs of text, pad, and length.…
-
Random Number Generator
Generate a random number with this snippet, using a Lambda function. Snippet: https://www.xano.com/snippet/kNYFQdMy Video walk-through: https://www.loom.com/share/ab0e0e6d9a1e425fa22559f7e1b582bf Instructions: how to add a snippet It features: GET /random_number: an API that accepts two inputs, min (an integer) and max (an…
-
Invoice Number Generator
An invoice number is a unique code assigned to each invoice, which you can accomplish by ensuring every invoice number has the same number of characters. Generate a number for an invoice with leading zeros, such as: 00015 00301 12022 Here's how to get started: Snippet: https://www.xano.com/snippet/t1MmPPr- Loom…
-
Product Price by Quantity
Set your product prices based on the quantity of items ordered. Snippet: https://www.xano.com/snippet/0y4bkQyR Video walk-through: https://www.loom.com/share/0396b8f475bc4de8b5605935f4d78cd0 Instructions: how to add a snippet It features: GET /product_price - find the price for a product using the inputs of product_id and…
-
Leftpad Function
This snippet creates a code like "00045" by adding zeros to the left of a number (45 in this example) to create a string with a specific number of characters. Snippet: https://www.xano.com/snippet/6DUeN15v/ Loom walk-through: https://www.loom.com/share/5140921f5e474d1a9411b1bced147025 How to add a Snippet:…
-
Learn Xano: Webhook with Typeform
This snippet is a companion to our documentation on Webhooks, demonstrating an example exercise on connecting to Typeform using a webhook: Snippet: https://www.xano.com/snippet/K0O5co6M/ Webhooks - Xano documentation: https://docs.xano.com/api/webhooks How to add a Snippet:…
-
Categorize expenses by location
This snippet provides an endpoint for categorizing expenses based on the location where the transaction occurred. Snippet: https://www.xano.com/snippet/6SPxQGdC Loom walk-through: https://www.loom.com/share/e1ff94ff741e494897dfa6a9f138e396 How to add a…
-
Create JSON from input
This snippet converts an input into a JSON object with nested arrays. Snippet: https://www.xano.com/snippet/h3tdku7r/ Loom walk-through: https://www.loom.com/share/b16160ffb02941caafc297cdf536ca3d How to add a Snippet: https://docs.xano.com/xano-features/snippets/preview-and-add-a-snippet It features: GET /to_json_person:…
-
Teams with Codes
Create teams that users can join with a unique, randomly generated "team code." Snippet - Team Code: https://www.xano.com/snippet/KmxQvGw8/ Loom walk-through: https://www.loom.com/share/7ad427f985da4130ba2b2190fbb3c402 How to add a Snippet: https://docs.xano.com/xano-features/snippets/preview-and-add-a-snippet It features:…