Opendatasoft · Example Payload

Dataset Records Query

Open DataDatasetsPublic DataODataRESTGovernmentCities

Dataset Records Query is an example object payload from Opendatasoft, with 2 top-level fields. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

requestresponse

Example Payload

{
  "request": {
    "method": "GET",
    "url": "https://{domain}/api/explore/v2.1/catalog/datasets/{dataset_id}/records",
    "parameters": {
      "where": "country_code='US' AND population > 100000",
      "limit": 20,
      "offset": 0,
      "order_by": "population desc",
      "select": "name, country_code, population, coordinates",
      "lang": "en",
      "timezone": "America/New_York"
    }
  },
  "response": {
    "total_count": 311,
    "results": [
      {
        "record_id": "b5c7f8a2e3d1",
        "timestamp": "2023-06-01T00:00:00Z",
        "size": 42,
        "fields": {
          "name": "New York City",
          "country_code": "US",
          "population": 8336817,
          "coordinates": {
            "lon": -74.006,
            "lat": 40.7128
          }
        },
        "geometry": {
          "type": "Point",
          "coordinates": [
            -74.006,
            40.7128
          ]
        },
        "links": []
      },
      {
        "record_id": "c4d6e9b1a2f0",
        "timestamp": "2023-06-01T00:00:00Z",
        "size": 40,
        "fields": {
          "name": "Los Angeles",
          "country_code": "US",
          "population": 3979576,
          "coordinates": {
            "lon": -118.2437,
            "lat": 34.0522
          }
        },
        "geometry": {
          "type": "Point",
          "coordinates": [
            -118.2437,
            34.0522
          ]
        },
        "links": []
      }
    ],
    "links": [
      {
        "href": "/api/explore/v2.1/catalog/datasets/geonames-all-cities/records?limit=20&offset=20",
        "rel": "next"
      }
    ]
  }
}

Work with this as data

Every example here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for examples

4 MCP tools reach this

find_examplesBrowse and filter every example in the catalog.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools

Call it yourself

curl for this page

This example

curl "https://apis.io/api/v1/examples/dataset-records-query"

All examples

curl "https://apis.io/api/v1/examples?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no email required.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.