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, $expand, @odata.nextLink.
| API |
Base URL |
Typical tables |
Auth |
Fit |
Docs |
| Microsoft Graph |
graph.microsoft.com/v1.0 |
users, groups, messages, events, calendarView |
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, groups |
OAuth2 |
✅ preferClientRouting → 307, driver follows |
— |
| 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 |
⚠️ jsonPointer 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 — jsonPointer, 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.
