REST-Jdbc — Compatible REST APIs

The datasqill REST JDBC driver (jdbc:rest:) is generic: it does not ship with built-in API adapters. Any REST endpoint can be mapped to SQL tables via a spec file. This page lists well-known REST APIs that can be connected with the driver using a suitable spec file.

Some APIs already have step-by-step examples with ready-made specs. All other entries are an orientation guide for blogs, evaluation, and your own spec development.

When does an API fit well?

Criterion	Ideal
Response format	JSON with an array of objects (optionally via `dataPath`, e.g. `/value`, `/data`, `/results`)
Read	`GET` on collection endpoints
Write	`POST` / `PUT` / `PATCH` / `DELETE` (optional, can be disabled per entity)
Pagination	`none`, `offset`, `page`, or OData `nextLink`
Auth	None, Basic, Bearer, OAuth2, API key, mTLS
Filter	Query parameters or native expressions (`$filter`, `q`, …)

Public test and demo APIs

Ideal for tutorials — mostly free, often no registration required.

API	Base URL	Typical tables	Auth	Pagination	Fit	Docs
JSONPlaceholder	`jsonplaceholder.typicode.com`	users, posts, comments	none	page	✅	Example
DummyJSON	`dummyjson.com`	users, products	none	limit	✅	—
REST Countries	`api.restcountries.com`	countries	Bearer (API key)	offset	✅	Example
OpenWeatherMap	`api.openweathermap.org`	forecast	API key	none	✅	Example
Open-Meteo	`api.open-meteo.com/v1`	forecast, archive	none	none	✅	—
WeatherAPI.com	`api.weatherapi.com/v1`	forecast, current	API key	none	✅	—
ReqRes	`reqres.in/api`	users, resources	none	page	✅	—
SWAPI (Star Wars)	`swapi.dev/api`	people, planets, films	none	page	✅	—
PokéAPI	`pokeapi.co/api/v2`	pokemon, berry, location	none	offset/limit	✅	—
RandomUser.me	`randomuser.me/api`	users (`results`)	none	page	✅	—
Fake Store API	`fakestoreapi.com`	products, users, carts	none	none	✅	—
Rick and Morty API	`rickandmortyapi.com/api`	character, episode	none	page	✅	—
CoinGecko	`api.coingecko.com/api/v3`	coins, markets	none / API key	page	✅	—
Frankfurter	`api.frankfurter.app`	exchange rates	none	none	✅	—
NASA APIs	`api.nasa.gov`	APOD, NEO, imagery	API key	page	✅	—
openFDA	`api.fda.gov`	drug, device, food	API key	skip/limit	✅	—
TMDB	`api.themoviedb.org/3`	movie, tv, person	API key	page	✅	—
Spotify Web API	`api.spotify.com/v1`	tracks, playlists	OAuth2	offset	✅	—
Wikipedia REST	`en.wikipedia.org/api/rest_v1`	page summary	none	none	✅	—

Microsoft and enterprise OData ecosystem

Especially well suited thanks to $filter, $select, @odata.nextLink.

API	Base URL	Typical tables	Auth	Fit	Docs
Microsoft Graph	`graph.microsoft.com/v1.0`	users, groups, messages, events	OAuth2 / Bearer	✅	Example
Dynamics 365	`*.crm.dynamics.com/api/data/v9.2`	accounts, contacts	OAuth2	✅	—
SharePoint Online	`*.sharepoint.com/.../_api/web/lists`	list items	OAuth2	✅	—
Azure DevOps	`dev.azure.com/{org}/_apis`	work items, repos	PAT / OAuth2	✅	—
Power BI REST	`api.powerbi.com/v1.0/myorg`	datasets, reports	OAuth2	✅	—
ServiceNow Table API	`*.service-now.com/api/now/table`	incident, user	Basic / OAuth2	✅	—
SAP OData	`*.sap.com/sap/opu/odata/...`	business objects	OAuth2 / mTLS	✅	—
SuccessFactors OData	`*.successfactors.com/odata/v2`	Employee, Job	OAuth2	✅	—
BambooHR API	`api.bamboohr.com`	employees	API key	✅	—
Personio API	`api.personio.de/v1`	employees	Bearer	✅	—

DevOps, code, and infrastructure

API	Base URL	Typical tables	Auth	Fit	Docs
GitHub	`api.github.com`	repos, issues, pulls	Bearer / OAuth2	✅	Example
GitLab	`gitlab.com/api/v4`	projects, issues	Bearer / OAuth2	✅	—
Bitbucket Cloud	`api.bitbucket.org/2.0`	repositories	Bearer / Basic	✅	—
Jira Cloud	`*.atlassian.net/rest/api/3`	issue, project	Basic / Bearer	✅	—
Confluence Cloud	`*.atlassian.net/wiki/rest/api`	content, space	Basic / Bearer	✅	—
Trello	`api.trello.com/1`	boards, cards	API key + token	✅	—
Asana	`app.asana.com/api/1.0`	tasks, projects	Bearer	✅	—
Notion	`api.notion.com/v1`	databases, pages	Bearer	⚠️ cursor pagination	—
Airtable	`api.airtable.com/v0`	records	Bearer	⚠️ offset in response	—
Docker Hub	`hub.docker.com/v2`	repositories	Bearer	✅	—
Terraform Cloud	`app.terraform.io/api/v2`	workspaces	Bearer	✅	—
Datadog	`api.datadoghq.com/api/v1`	monitors	API key	✅	—
Elasticsearch	`*/_search`	hits (`/hits/hits`)	API key / Basic	⚠️ scroll protocol	—
Cloudflare	`api.cloudflare.com/client/v4`	zones, dns	API token	✅	—
DigitalOcean	`api.digitalocean.com/v2`	droplets	Bearer	✅	—
Hetzner Cloud	`api.hetzner.cloud/v1`	servers	Bearer	✅	—

CRM, marketing, and sales

API	Base URL	Typical tables	Auth	Fit	Docs
Webmetic	customer-specific	wem_company	API key / Bearer	✅	Example
HubSpot CRM	`api.hubapi.com/crm/v3/objects`	contacts, deals	OAuth2	✅	—
Pipedrive	`api.pipedrive.com/v1`	deals, persons	API token	✅	—
Zoho CRM	`www.zohoapis.com/crm/v2`	Leads, Contacts	OAuth2	✅	—
Mailchimp Marketing	`*.api.mailchimp.com/3.0`	lists, members	API key	✅	—
Intercom	`api.intercom.io`	contacts	Bearer	✅	—
Zendesk Support	`*.zendesk.com/api/v2`	tickets, users	Basic / OAuth2	✅	—
Freshdesk	`*.freshdesk.com/api/v2`	tickets	API key	✅	—
Calendly	`api.calendly.com`	scheduled_events	Bearer	✅	—
Typeform	`api.typeform.com`	forms, responses	Bearer	✅	—

E-commerce and payments

API	Base URL	Typical tables	Auth	Fit
WooCommerce	`*/wp-json/wc/v3`	products, orders	Basic	✅
Magento / Adobe Commerce	`*/rest/V1`	products, orders	Bearer	✅
BigCommerce	`api.bigcommerce.com/stores/...`	products	OAuth2	✅
Shopware	`*/api`	products, orders	OAuth2	✅
Mollie	`api.mollie.com/v2`	payments	API key	✅
Chargebee	`*.chargebee.com/api/v2`	subscriptions	API key	✅
Shopify Admin	`*.myshopify.com/admin/api/...`	products, orders	OAuth2	⚠️ cursor pagination
Stripe	`api.stripe.com/v1`	customers, charges	Bearer	⚠️ cursor, `dataPath` `/data`
PayPal	`api-m.paypal.com/v2`	payments	OAuth2	⚠️ cursor
Square	`connect.squareup.com/v2`	customers	OAuth2	⚠️ cursor

Communication, support, and collaboration

API	Base URL	Typical tables	Auth	Fit
Microsoft Teams (via Graph)	`graph.microsoft.com/v1.0`	teams, channels	OAuth2	✅
Mattermost	`*/api/v4`	channels, posts	Bearer	✅
Zoom	`api.zoom.us/v2`	meetings, users	OAuth2	✅
Twilio	`api.twilio.com`	messages, calls	Basic	✅
SendGrid	`api.sendgrid.com/v3`	templates	Bearer	✅
PagerDuty	`api.pagerduty.com`	incidents	API key	✅

HR, recruiting, and workforce

API	Base URL	Typical tables	Auth	Fit
BambooHR	`api.bamboohr.com`	employees	API key	✅
Personio	`api.personio.de/v1`	employees	Bearer	✅
Greenhouse	`harvest.greenhouse.io/v1`	candidates	Basic	✅
Lever	`api.lever.co/v1`	opportunities	Bearer	✅
Clockify	`api.clockify.me/api/v1`	time entries	API key	✅
Harvest	`api.harvestapp.com/v2`	time entries	Bearer	✅

Content, CMS, and digital asset management

API	Base URL	Typical tables	Auth	Fit
WordPress REST	`*/wp-json/wp/v2`	posts, pages	Basic / OAuth	✅
Contentful	`cdn.contentful.com/spaces/...`	entries	Bearer	✅
Strapi	`*/api`	content-types	Bearer	✅
Directus	`*/items`	collections	Bearer	✅
Ghost Admin API	`*/ghost/api/admin`	posts	JWT	⚠️ JWT auth, nested fields
Cloudinary Admin	`api.cloudinary.com/v1_1`	resources	Basic	✅

Analytics, BI, and data platforms

API	Base URL	Typical tables	Auth	Fit
Matomo	`*/index.php`	visits	token	✅
PostHog	`app.posthog.com/api`	events	API key	✅
Looker API	`*.looker.com/api/4.0`	looks	OAuth2	✅
Metabase	`*/api`	cards	API key	✅
Databricks REST	`*.cloud.databricks.com/api/2.0`	clusters, jobs	Bearer	✅
Google Sheets API	`sheets.googleapis.com/v4`	spreadsheets	OAuth2	⚠️ `pageToken` in response

IoT, logistics, and industry

API	Base URL	Typical tables	Auth	Fit
HERE Maps	`geocode.search.hereapi.com/v1`	geocode	API key	✅
DHL Tracking	`api-eu.dhl.com/track`	shipments	API key	✅
UPS	`onlinetools.ups.com/api`	tracking	OAuth2	✅
Shippo	`api.goshippo.com`	shipments	API token	✅

Security, identity, and compliance

API	Base URL	Typical tables	Auth	Fit
Okta	`*.okta.com/api/v1`	users, groups	SSWS token	✅
Auth0 Management	`*.auth0.com/api/v2`	users, clients	Bearer	✅
Keycloak Admin REST	`*/admin/realms/...`	users	Bearer	✅
Have I Been Pwned	`haveibeenpwned.com/api/v3`	breaches	API key	✅

Science, education, and healthcare

API	Base URL	Typical tables	Auth	Fit
PubMed / NCBI E-utilities	`eutils.ncbi.nlm.nih.gov`	articles	optional	✅
Crossref	`api.crossref.org`	works	mailto pool	✅
OpenAlex	`api.openalex.org`	works, authors	mailto pool	✅
ClinicalTrials.gov	`clinicaltrials.gov/api/v2`	studies	none	✅
HL7 FHIR (REST)	`*/fhir`	Patient, Observation	Bearer	⚠️ `jsonPath` per field
Canvas LMS	`*/api/v1`	courses, users	Bearer	✅

Other SaaS

API	Base URL	Typical tables	Auth	Fit
DocuSign	`*.docusign.net/restapi`	envelopes	OAuth2	✅
Figma REST	`api.figma.com/v1`	files	Bearer	✅
Miro	`api.miro.com/v2`	boards	Bearer	✅
Twitch Helix	`api.twitch.tv/helix`	streams, users	OAuth2	✅
PocketBase	`*/api/collections/.../records`	records	Bearer	✅
n8n Public API	`*/api/v1`	workflows	API key	✅
Google Drive	`www.googleapis.com/drive/v3`	files	OAuth2	⚠️ `pageToken` in response
YouTube Data API	`www.googleapis.com/youtube/v3`	videos	OAuth2	⚠️ `pageToken` in response

Legend

Symbol	Meaning
✅	Good fit — similar patterns to the documented examples
⚠️	Usable, but with spec effort or limitations (see next section)

Fit column: assessment of how well the API matches the driver. Docs column: link to a ready-made guide with spec file in the project.

What does ⚠️ mean?

⚠️ marks APIs that are fundamentally usable with the driver, but need more spec work or hit limits of current driver features.

Situation	Examples	Solvable with spec?	Driver extension
JSON list in wrapper object	Stripe (`/data`), RandomUser (`/results`)	Yes — set `dataPath`	No
Nested fields	Microsoft Graph calendar, FHIR resources	Yes — `jsonPath`, `selectName`, `defaultWrite`	No
Cursor via query parameter	Stripe, Shopify, Notion, Sentry	Partly — first page or manual `FILTER`	In preparation via pagination type `cursor`
`pageToken` only in response	Google Drive, YouTube Data API	First page readable	In preparation via pagination type `pageToken`
Scroll/search protocol	Elasticsearch, OpenSearch	Individual search queries	In preparation via pagination type `scroll`
Offset only in response	Airtable	Single pages	In preparation via pagination type `offsetInResponse`
Complex write bodies	Shopify, Ghost Admin	Reading usually easier than writing	In preparation via extended write defaults in the spec

In short: for ⚠️ APIs, a thoughtful spec is often enough for SELECT. For comfortable pagination across all records, the driver extensions listed above are in preparation — until then, first pages and manual FILTER are possible.

Feedback and contact

Already using a REST API with our driver? We'd love to hear from you. Missing a REST API on this list? Feel free to get in touch with us so we can expand and document more use cases.