removedInput schema / $schema
Removed value: -"http://json-schema.org/draft-07/schema#"
addedInput schema / properties / bbox / examples
Added value: +[
+ "2.2241,48.8156,2.4699,48.9022"
+]
changedInput schema / properties / datasetId / description
Previous value: -"The exact dataset ID from the \"id\" field in list_datasets results. Do not use the title or slug."New value: +"The \"id\" of a datafair_list_account_datasets result, not its title or slug."
removedInput schema / properties / filters / additionalProperties
Removed value: -{
- "type": "string"
-}
changedInput schema / properties / filters / description
Previous value: -"Column filters as key-value pairs: column_key + suffix, all values strings. Example: { \"ville_eq\": \"Paris\", \"age_lte\": \"30\", \"nom_search\": \"Jean\" }. Suffixes include _eq, _in, _gt/_lt, _search and more; if one is rejected the 400 error lists what the column supports. Never _c_-prefix a column filter (use ville_eq, not _c_ville_eq)."New value: +"Column filters { \"<column key><suffix>\": \"<value as a string>\" }, e.g. { \"ville_eq\": \"Paris\", \"age_lte\": \"30\", \"nom_search\": \"Jean\" }. Suffixes: _eq _neq _in _nin (comma-separated) _gt _gte _lt _lte _starts _exists _nexists _search (words, the default for text) _contains (when enabled). A rejected suffix answers a 400 listing the column's. Never prefix with _c_."
addedInput schema / properties / filters / patternProperties
Added value: +{
+ ".*": {
+ "default": "",
+ "type": "string"
+ }
+}
removedInput schema / properties / filters / propertyNames
Removed value: -{
- "pattern": "^.+_(search|eq|neq|in|nin|starts|contains|gte?|lte?|n?exists)$"
-}
changedInput schema / properties / groupByColumns / description
Previous value: -"Columns to GROUP BY (like SQL GROUP BY). These define the categories/buckets, NOT the column to compute metrics on. Use column keys from describe_dataset (min 1, max 3)."New value: +"Columns to GROUP BY (like SQL GROUP BY), 1 to 3 keys from datafair_describe_dataset. NOT the column to compute the metric on."
removedInput schema / properties / groupByColumns / maxItems
Removed value: -3
removedInput schema / properties / groupByColumns / minItems
Removed value: -1
removedInput schema / properties / metric / additionalProperties
Removed value: -false
changedInput schema / properties / metric / description
Previous value: -"Optional metric to compute ON EACH GROUP. If not provided, defaults to counting rows per group."New value: +"Metric computed ON EACH GROUP. Omit to count rows per group."
addedInput schema / properties / metric / enum
Added value: +[
+ "avg",
+ "sum",
+ "min",
+ "max",
+ "cardinality",
+ "value_count"
+]
removedInput schema / properties / metric / properties
Removed value: -{
- "column": {
- "description": "The column to compute the metric ON (e.g., \"salary\" for average salary). This is NOT the grouping column. Use column keys from describe_dataset.",
- "type": "string"
- },
- "type": {
- "description": "Metric to compute on each group. \"count\" counts rows per group (identical to omitting the metric parameter — does NOT count non-null values of the specified column).",
- "enum": [
- "sum",
- "avg",
- "min",
- "max",
- "count"
- ],
- "type": "string"
- }
-}
removedInput schema / properties / metric / required
Removed value: -[
- "column",
- "type"
-]
changedInput schema / properties / metric / type
Previous value: -"object"New value: +"string"
addedInput schema / properties / metricColumn
Added value: +{
+ "description": "The column to compute the metric on, for the average or sum of that column. Requires metric.",
+ "type": "string"
+}
addedInput schema / properties / q
Added value: +{
+ "description": "Full-text search across all columns, restricting the rows. Prefer filters for structured criteria.",
+ "maxLength": 1000,
+ "type": "string"
+}
changedInput schema / properties / sort / description
Previous value: -"Sort order for aggregation results. Use special keys: \"count\" or \"-count\" (by row count asc/desc), \"key\" or \"-key\" (by column value asc/desc), \"metric\" or \"-metric\" (by metric value asc/desc). Default: sorts by metric desc (if metric specified), then count desc. Example: \"-count\" to sort by most frequent values first"New value: +"Array with one sort key per aggregation level: \"count\"/\"-count\" (group size), \"key\"/\"-key\" (group value), \"metric\"/\"-metric\" (metric value). Example: [\"-count\"]."
addedInput schema / properties / sort / items
Added value: +{
+ "type": "string"
+}
changedInput schema / properties / sort / type
Previous value: -"string"New value: +"array"
changedOutput schema / (root)
Previous value: -{
- "$schema": "http://json-schema.org/draft-07/schema#",
- "additionalProperties": false,
- "properties": {
- "aggs": {
- "description": "Array of aggregation results for each group (limited to 20 rows)",
- "type": "array"
- },
- "datasetId": {
- "description": "The dataset ID that was aggregated",
- "type": "string"
- },
- "requestUrl": {
- "description": "Direct URL to API results in JSON format (must be included in responses for citation and direct access to aggregated view)",
- "type": "string"
- },
- "total": {
- "description": "The total number of rows in the dataset",
- "type": "number"
- },
- "total_other": {
- "description": "Number of rows NOT included in the returned aggregations (only the top groups are returned). Add this to the sum of all group totals to reconstruct the dataset total.",
- "type": "number"
- },
- "total_values": {
- "description": "The total number of different values aggregated across all specified columns",
- "type": "number"
- }
- },
- "required": [
- "datasetId",
- "total",
- "total_values",
- "total_other",
- "requestUrl",
- "aggs"
- ],
- "type": "object"
-}New value: +null