Public API tester

Paste a JSON or XML API URL and see it the way an analytics tool will: which part of the response holds the rows, what each column’s type is, what’s missing or suspicious — plus a CSV export and the exact settings to connect it as a live dataset.

Free, no sign-up. Your browser calls the API directly — nothing goes through a QuantumLayers server, and nothing is stored.

Request

Try a keyless public dataset below, or paste any API endpoint. GET requests only.

+ Authorization header (only if the API needs one)

Sent only to the API above, from your browser. Adding a header makes the browser do a CORS pre-check first, which some APIs refuse — if a key can go in the URL instead, prefer that.

Or paste a response body / open a saved file (JSON, XML or CSV)

Use this when an API blocks browser calls (no CORS): open the URL in a new tab, copy what it returns, paste it here.

What this checks

  • Where the rows are. Most APIs wrap their data — {"data": [...]}, [paging, rows], columnar arrays, maps keyed by date, SDMX. The tester finds the table the same way QuantumLayers’ REST connector does, shows the response path it used, and suggests a better one when the automatic pick looks wrong.
  • Column types. Each column is typed with QuantumLayers’ own rules (integer, float, date, datetime, text) — including treating ID and postcode-like columns as text, not numbers.
  • Data quality. Missing values, sentinel codes like -999, numbers delivered as strings, columns that are entirely empty, list indexes flattened into dozens of columns, and signs that you only got the first page of results.
  • Whether a browser can call it. If the API doesn’t send CORS headers, browsers can’t read it directly. That doesn’t matter for a server-side connector — paste the body to test it anyway.

one test vs. a live dataset

This fetched the API once. QuantumLayers keeps it fresh.

Connect the same URL and response path as a REST dataset in QuantumLayers and it re-syncs on a schedule, from the server (no CORS limits), with charts, statistics, monitor alerts and AI insights on top.

Connect this API free →