Introducing RapidQL: Fetch, combine, and aggregate data from multiple APIs and databases in a single call

Have you ever wanted to grab an address, lookup the 10 nearest restaurants, and provide Uber price and ETAs — all in a single API call? What about fetching a list of users from a database and simultaneously doing email validation and phone number validation?

Well now you can, with RapidQL, our recently launched open source project.

And those are just two examples of the many combinations made possible when you can query, combine, and aggregate data from multiple APIs and databases in a single API call.

// Get a list of users and fetch the weather based on the city saved on their account
rql.log(`{
- MySQL.RQLDemo.rqlDemo.find(){
username,
city,
- Http.get(
url:"https://community-open-weather-map.p.rapidapi.com/weather",
params: {
"units": "imperial",
"q" : city
}
){
- weather {
main
},
- main {
temp
}
}
}
}`)

Check us out on ProductHunt to learn more about why we launched it and how it will help simplify fetching data from multiple data sources!

The inspiration for RapidQL is to make it easy for developers to simultaneously make requests to APIs as well as databases, defining only the fields you need returned from each and avoiding expensive additional round trips.

Queries made to databases like MySQL, PostgreSQL, and MongoDB can take advantage of aggregations like count and average. These results can be fed into the next query in the RapidQL statement.

And of course, you can also connect to more than 10,000 public APIs on RapidAPI’s Marketplace.

RapidQL itself is a JSON-like query language implemented in JavaScript. Just $ npm install rapidql to download it, then check out the documentation to see how to run your first query. You can also view a tutorial on our blog or a step-by-step video on our YouTube account.

To celebrate the launch of RapidQL, we’ll be highlighting and sharing any projects that you build over the next few weeks! Here’s how you can join in:

  • Take a look at the RapidQL docs
  • Create an example RapidQL call on CodePen
  • Tweet us your best ideas, mentioning @Rapid_API and #RapidQL. Include a link to the pen and a screenshot, if possible.
  • We’ll retweet all of the most useful, the funniest, and the most complex queries you build!

RapidQL is open source, and we welcome all contributions to the codebase. You’re invited to support the core system (see open issues in GitHub), as well as develop integrations with more data sources and database systems (see planned integration in project board in GitHub).

Current: Head of Sales Engineering RapidAPI. Former: Head of Developer Relations RapidAPI, Founder of HackCU. Part-time adventurer, full-time hooligan

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store