API and JSON

Wappler includes powerful visual tools that allow you to connect to any data API or hosted JSON files. In this category you will learn how to add and use dynamic data from such data sources on your pages.

Connect Google Sheets to your page

Overview In this post, we will connect our web application with Google Sheets. So, you can actually use the Sheets as a database replacement, and pull the data written on them. We will use this data…

Connecting to Airtable API

Intro You can use the Server API Connector to connect to and pull data from Airtable. We will use this data to populate a Bootstrap table on our page. Airtable Setup There are a couple of steps you…

API Connector components, how to use and connect REST/Curl API's

With the API Connector in Wappler, you have gained a lot of power to directly connect to API’s and fetch data or call their actions. The API Connector is based on three components: API Data Source A…

API Data Source & API Action - Different settings?

HI guys, hope you can help me out with that connection problem. Using the same settings for API Datasource and API Action. API Datasource works great but API Action shows: Server returned code: 401 …

Mass geocoding using API

Introduction At last the long promised method of mass geocoding the wappler way no scripts involved. As this is basically a reply to a post from @mimuk i will base this tutorial around his data tab…

General API Tips & Tricks

I thought I would just add a few little tips and tricks I have found whist working with APIs Fetch Schema: If your API provider has a million security parts you need to jump through first, or if the…

Create Record in Table via API

Hi Guys, I´ve watched all tutorials about Wappler (I think) but could not find any where is shown how to work with server side API Action to create a record in a database. Could someone help me out …

Unable to display Server side "API Action" data on my page

Hi Wappler-ions, I have been struggling with this, any help would be greatly appreciated. I have attached a gif for easy reference (click on the gif to see clearly). Here is what I’m doing: Create…

How to get an Amadeus Access token for API use

Having recently gone through the process I thought I would share my experience of how to gain a bearer token for the Amadeus API The Amadeus API generally is easy to use with primarily GET requests b…

Using API Data Source

In this tutorial we will show you the basics of API Data Source. We are going to connect to the popular Unsplash API to retrieve the latest photos in a nice masonry layout. This API requires an api k…

The recommended / best steps to load API and auto insert it to database

I need advice on the steps how to: Load API data Auto insert the data into database Load the database I don’t want to directly use the API data as output instead I want to use my database which get…

Data Types and Binding

When you have a rich data to bind, specially one retrieved from complex APIs with the API Data Source, it is good to understand the structure of the data. Your Data Structure When you call the Data …

Caching API Data

Sometimes data APIs have restrictions like limits for requests per IP or hourly request limits. In cases like these, it’s useful to have data cached for your user. You can do this by using the state m…

Working with JSON Data

You can use JSON files on your server as a data source for your pages. First in app structure select App and add new component: Open Data: And select JSON Data Source: In the properties pane…