-
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…
-
Need help connecting APIs using Xano? Let's collaborate and streamline your integration process!
As a Xano user for almost a year, I'm excited to offer my assistance with API integration. While I have experience with the platform, I'm always eager to learn more and improve my skills. In fact, I believe that the best way to continue learning is through collaboration and working with others to solve problems. So, by…
-
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 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…
-
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.…
-
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…
-
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:…