DatoQA — Historical Exchange Rates

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'language': {'enum': ['en', 'fr'], 'type': 'string', 'default': 'en'}, 'report_to': {'type': 'integer', 'maximum': 2025, 'minimum': -9007199254740991}, 'report_from': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 1960}, 'report_countries': {'type': 'array', 'items': {'type': 'string', 'pattern': '^[A-Z0-9]{3}$'}, 'maxItems': 10, 'minItems': 1, 'description': 'Optional free preview for these distinct World Bank country codes, e.g. FRA, DEU, ESP. General/economy connections only.'}, 'report_indicators': {'type': 'array', 'items': {'enum': ['population', 'gdp', 'gdp_per_capita', 'gdp_real', 'gdp_growth', 'inflation', 'life_expectancy', 'fertility', 'urban_population', 'internet_users', 'electricity_access', 'unemployment', 'renewable_energy', 'forest_area', 'agricultural_land', 'trade', 'exports', 'imports', 'infant_mortality', 'basic_drinking_water', 'basic_sanitation', 'primary_completion'], 'type': 'string'}, 'maxItems': 6, 'minItems': 1, 'description': 'Custom historical comparison: select up to six of the 22 WDI indicators. Supply report_from and report_to together, up to ten years. Missing cells block payment.'}}}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['name'], 'properties': {'name': {'type': 'string', 'const': 'DatoQA'}, 'title': {'type': 'string'}, 'tools': {'type': 'array', 'items': {'type': 'string'}}, 'profile': {'type': 'string'}, 'version': {'type': 'string'}, 'capabilities': {'type': 'array', 'items': {'type': 'string'}}, 'available_records': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}, 'independently_verified': {'type': 'boolean', 'const': False, 'description': 'Official-source checks are not independent factual corroboration.'}}, 'description': 'General availability catalog or a scoped thematic directory; theme metadata is not a live availability guarantee.', 'additionalProperties': {}}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['rows'], 'properties': {'rows': {'type': 'array', 'items': {'type': 'object', 'required': ['id', 'date', 'currency', 'amount'], 'properties': {'id': {'type': 'string', 'maxLength': 64, 'minLength': 1}, 'date': {'type': 'string'}, 'amount': {'type': 'string', 'pattern': '^-?\\d{1,36}(?:\\.\\d{1,18})?$'}, 'currency': {'type': 'string', 'pattern': '^[A-Z]{3}$'}}, 'additionalProperties': False}, 'maxItems': 500, 'minItems': 1}, 'rounding': {'enum': ['half_even', 'half_away_from_zero'], 'type': 'string', 'default': 'half_even'}, 'output_format': {'enum': ['json', 'both'], 'type': 'string', 'default': 'json', 'description': 'json keeps the response smaller. both includes the CSV in the same free result; no separate export purchase.'}, 'target_currency': {'enum': ['EUR', 'USD', 'JPY', 'CZK', 'DKK', 'GBP', 'HUF', 'PLN', 'RON', 'SEK', 'CHF', 'ISK', 'NOK', 'TRY', 'AUD', 'BRL', 'CAD', 'CNY', 'HKD', 'IDR', 'ILS', 'INR', 'KRW', 'MXN', 'MYR', 'NZD', 'PHP', 'SGD', 'THB', 'ZAR'], 'type': 'string', 'default': 'EUR'}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['status', 'target_currency', 'target_decimal_places', 'rows', 'sources', 'blocked_rows', 'total_eur', 'total_target', 'complete_artifact_available', 'billing'], 'properties': {'rows': {'type': 'array', 'items': {'type': 'object', 'required': ['row', 'status'], 'properties': {'row': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991}, 'status': {'enum': ['converted', 'blocked'], 'type': 'string'}}, 'additionalProperties': {}}}, 'status': {'enum': ['complete', 'incomplete'], 'type': 'string'}, 'billing': {'type': 'object', 'required': ['enabled', 'charged'], 'properties': {'charged': {'type': 'boolean', 'const': False}, 'enabled': {'type': 'boolean', 'const': False}}, 'additionalProperties': False}, 'sources': {'type': 'array', 'items': {'type': 'object', 'required': ['record_id', 'source_url', 'evidence_sha256', 'independently_verified'], 'properties': {'record_id': {'type': 'string'}, 'source_url': {'type': 'string'}, 'evidence_sha256': {'type': 'string'}, 'independently_verified': {'type': 'boolean', 'const': False}}, 'additionalProperties': {}}}, 'total_eur': {'type': ['string', 'null']}, 'blocked_rows': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}, 'total_target': {'type': ['string', 'null']}, 'target_currency': {'enum': ['EUR', 'USD', 'JPY', 'CZK', 'DKK', 'GBP', 'HUF', 'PLN', 'RON', 'SEK', 'CHF', 'ISK', 'NOK', 'TRY', 'AUD', 'BRL', 'CAD', 'CNY', 'HKD', 'IDR', 'ILS', 'INR', 'KRW', 'MXN', 'MYR', 'NZD', 'PHP', 'SGD', 'THB', 'ZAR'], 'type': 'string'}, 'target_decimal_places': {'anyOf': [{'type': 'number', 'const': 0}, {'type': 'number', 'const': 2}]}, 'complete_artifact_available': {'type': 'boolean'}}, 'additionalProperties': {}}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['id'], 'properties': {'id': {'type': 'string', 'pattern': '^[A-Za-z0-9_-]{1,128}$', 'description': 'Record id returned by a DatoQA data response; returns the retained source snapshot for that record.'}}}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['record_id', 'sha256', 'hash_scope', 'source_payload_json', 'first_observed_at', 'source_url', 'notice'], 'properties': {'notice': {'type': 'string'}, 'sha256': {'type': 'string'}, 'record_id': {'type': 'string'}, 'hash_scope': {'type': 'string', 'const': 'utf8_source_payload_json'}, 'source_url': {'type': 'string'}, 'first_observed_at': {'type': 'string'}, 'source_payload_json': {'type': 'string'}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['currency'], 'properties': {'date': {'type': 'string', 'description': 'Exact source date YYYY-MM-DD, for example 2008-09-15; cannot be combined with year. No filling of weekends or gaps.'}, 'year': {'type': 'integer', 'maximum': 2026, 'minimum': 1999, 'description': 'One source calendar year since 1999; defaults to the current year. Cannot be combined with date.'}, 'format': {'enum': ['json', 'csv'], 'type': 'string', 'default': 'json', 'description': 'CSV content with null flags, original values, source notes and provenance, alongside JSON. No missing-date filling.'}, 'currency': {'type': 'string', 'pattern': '^[A-Z]{3}$', 'description': 'Uppercase non-EUR currency code from list_exchange_rate_history, for example USD. Values are currency units per one EUR.'}}}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['status', 'returned', 'items', 'currency', 'year', 'requested_date'], 'properties': {'year': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991}, 'items': {'type': 'array', 'items': {'type': 'object', 'required': ['id', 'domain', 'data', 'freshness', 'citation', 'provenance'], 'properties': {'id': {'type': 'string'}, 'data': {'type': 'object', 'description': 'Source-specific payload; inspect units, observation dates, nulls and source notes.', 'propertyNames': {'type': 'string'}, 'additionalProperties': {}}, 'domain': {'type': 'string'}, 'citation': {'type': 'object', 'required': ['url', 'publisher', 'retrieved_at'], 'properties': {'url': {'type': 'string'}, 'publisher': {'type': 'string'}, 'retrieved_at': {'type': 'string'}}, 'additionalProperties': False}, 'freshness': {'type': 'object', 'required': ['observed_at', 'expires_at', 'age_seconds', 'meaning'], 'properties': {'meaning': {'type': 'string'}, 'expires_at': {'type': 'string'}, 'age_seconds': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}, 'observed_at': {'type': 'string'}}, 'additionalProperties': False}, 'provenance': {'type': 'object', 'required': ['source_id', 'source_name', 'source_url', 'license', 'retrieved_at', 'verified_at', 'valid_until', 'verification_method', 'content_sha256', 'verification_level', 'independently_verified', 'verification_scope'], 'properties': {'license': {'type': 'string'}, 'source_id': {'type': 'string'}, 'source_url': {'type': 'string'}, 'source_name': {'type': 'string'}, 'valid_until': {'type': 'string'}, 'verified_at': {'type': 'string'}, 'retrieved_at': {'type': 'string'}, 'content_sha256': {'type': 'string'}, 'verification_level': {'enum': ['official_source_and_schema_checked', 'public_aggregator_and_schema_checked', 'method_specific'], 'type': 'string'}, 'verification_scope': {'type': 'array', 'items': {'type': 'string'}}, 'verification_method': {'type': 'string'}, 'independently_verified': {'type': 'boolean', 'const': False, 'description': 'Official-source checks are not independent factual corroboration.'}}, 'additionalProperties': False}, 'display_label': {'type': 'string'}}, 'additionalProperties': {}}}, 'notice': {'type': 'string'}, 'status': {'enum': ['source_unavailable_or_stale', 'available_reference_rates', 'no_numeric_data_in_period'], 'type': 'string', 'description': 'Read this before using values; a successful transport does not establish data availability.'}, 'currency': {'type': 'string'}, 'returned': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0, 'description': 'Domain-specific result count, not necessarily the number of stored records in items.'}, 'directory': {'type': 'string'}, 'interpretation': {'type': 'object', 'required': ['independently_verified'], 'properties': {'independently_verified': {'type': 'boolean', 'const': False, 'description': 'Official-source checks are not independent factual corroboration.'}}, 'additionalProperties': {}}, 'requested_date': {'type': ['string', 'null']}, 'independently_verified': {'type': 'boolean', 'const': False, 'description': 'Official-source checks are not independent factual corroboration.'}}, 'additionalProperties': {}}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'currency': {'type': 'string', 'pattern': '^[A-Z]{3}$', 'description': 'Optional uppercase currency code, for example USD; omit for all available ECB reference currencies. Values are currency units per one EUR.'}}}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['status', 'returned', 'items'], 'properties': {'items': {'type': 'array', 'items': {'type': 'object', 'required': ['id', 'domain', 'data', 'freshness', 'citation', 'provenance'], 'properties': {'id': {'type': 'string'}, 'data': {'type': 'object', 'description': 'Source-specific payload; inspect units, observation dates, nulls and source notes.', 'propertyNames': {'type': 'string'}, 'additionalProperties': {}}, 'domain': {'type': 'string'}, 'citation': {'type': 'object', 'required': ['url', 'publisher', 'retrieved_at'], 'properties': {'url': {'type': 'string'}, 'publisher': {'type': 'string'}, 'retrieved_at': {'type': 'string'}}, 'additionalProperties': False}, 'freshness': {'type': 'object', 'required': ['observed_at', 'expires_at', 'age_seconds', 'meaning'], 'properties': {'meaning': {'type': 'string'}, 'expires_at': {'type': 'string'}, 'age_seconds': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}, 'observed_at': {'type': 'string'}}, 'additionalProperties': False}, 'provenance': {'type': 'object', 'required': ['source_id', 'source_name', 'source_url', 'license', 'retrieved_at', 'verified_at', 'valid_until', 'verification_method', 'content_sha256', 'verification_level', 'independently_verified', 'verification_scope'], 'properties': {'license': {'type': 'string'}, 'source_id': {'type': 'string'}, 'source_url': {'type': 'string'}, 'source_name': {'type': 'string'}, 'valid_until': {'type': 'string'}, 'verified_at': {'type': 'string'}, 'retrieved_at': {'type': 'string'}, 'content_sha256': {'type': 'string'}, 'verification_level': {'enum': ['official_source_and_schema_checked', 'public_aggregator_and_schema_checked', 'method_specific'], 'type': 'string'}, 'verification_scope': {'type': 'array', 'items': {'type': 'string'}}, 'verification_method': {'type': 'string'}, 'independently_verified': {'type': 'boolean', 'const': False, 'description': 'Official-source checks are not independent factual corroboration.'}}, 'additionalProperties': False}, 'display_label': {'type': 'string'}}, 'additionalProperties': {}}}, 'notice': {'type': 'string'}, 'status': {'enum': ['source_unavailable_or_stale', 'currency_not_supported', 'available_reference_rates'], 'type': 'string', 'description': 'Read this before using values; a successful transport does not establish data availability.'}, 'returned': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0, 'description': 'Domain-specific result count, not necessarily the number of stored records in items.'}, 'directory': {'type': 'string'}, 'selected_rate': {'anyOf': [{'type': 'object', 'required': ['currency', 'units_per_eur', 'source_decimal'], 'properties': {'currency': {'type': 'string'}, 'units_per_eur': {'type': 'number'}, 'source_decimal': {'type': 'string'}}, 'additionalProperties': False}, {'type': 'null'}]}, 'available_currencies': {'type': 'array', 'items': {'type': 'string'}}, 'independently_verified': {'type': 'boolean', 'const': False, 'description': 'Official-source checks are not independent factual corroboration.'}}, 'additionalProperties': {}}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['id'], 'properties': {'id': {'type': 'string', 'pattern': '^[A-Za-z0-9_-]+$', 'maxLength': 128, 'minLength': 1, 'description': 'Opaque record id returned by a DatoQA data response. Reuse it exactly; do not invent an id.'}}}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['id', 'domain', 'data', 'freshness', 'citation', 'provenance'], 'properties': {'id': {'type': 'string'}, 'data': {'type': 'object', 'description': 'Source-specific payload; inspect units, observation dates, nulls and source notes.', 'propertyNames': {'type': 'string'}, 'additionalProperties': {}}, 'domain': {'type': 'string'}, 'citation': {'type': 'object', 'required': ['url', 'publisher', 'retrieved_at'], 'properties': {'url': {'type': 'string'}, 'publisher': {'type': 'string'}, 'retrieved_at': {'type': 'string'}}, 'additionalProperties': False}, 'freshness': {'type': 'object', 'required': ['observed_at', 'expires_at', 'age_seconds', 'meaning'], 'properties': {'meaning': {'type': 'string'}, 'expires_at': {'type': 'string'}, 'age_seconds': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}, 'observed_at': {'type': 'string'}}, 'additionalProperties': False}, 'provenance': {'type': 'object', 'required': ['source_id', 'source_name', 'source_url', 'license', 'retrieved_at', 'verified_at', 'valid_until', 'verification_method', 'content_sha256', 'verification_level', 'independently_verified', 'verification_scope'], 'properties': {'license': {'type': 'string'}, 'source_id': {'type': 'string'}, 'source_url': {'type': 'string'}, 'source_name': {'type': 'string'}, 'valid_until': {'type': 'string'}, 'verified_at': {'type': 'string'}, 'retrieved_at': {'type': 'string'}, 'content_sha256': {'type': 'string'}, 'verification_level': {'enum': ['official_source_and_schema_checked', 'public_aggregator_and_schema_checked', 'method_specific'], 'type': 'string'}, 'verification_scope': {'type': 'array', 'items': {'type': 'string'}}, 'verification_method': {'type': 'string'}, 'independently_verified': {'type': 'boolean', 'const': False, 'description': 'Official-source checks are not independent factual corroboration.'}}, 'additionalProperties': False}, 'display_label': {'type': 'string'}}, 'additionalProperties': {}}

{'type': 'object', 'properties': {}}

{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['endpoint', 'source', 'base_currency', 'currencies', 'years', 'missing_or_expired_years', 'numeric_values', 'frequency', 'query', 'refresh', 'original_data_free', 'independently_verified'], 'properties': {'query': {'type': 'string'}, 'years': {'type': 'array', 'items': {'type': 'object', 'required': ['year', 'currencies', 'numeric_values', 'published_days', 'retrieved_at', 'expires_at'], 'properties': {'year': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991}, 'currencies': {'type': 'array', 'items': {'type': 'string'}}, 'expires_at': {'type': 'string'}, 'retrieved_at': {'type': 'string'}, 'numeric_values': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}, 'published_days': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}}, 'additionalProperties': {}}}, 'source': {'type': 'string'}, 'refresh': {'type': 'string'}, 'endpoint': {'type': 'string'}, 'frequency': {'type': 'string'}, 'currencies': {'type': 'array', 'items': {'type': 'string'}}, 'base_currency': {'type': 'string', 'const': 'EUR'}, 'numeric_values': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}, 'original_data_free': {'type': 'boolean', 'const': True}, 'independently_verified': {'type': 'boolean', 'const': False, 'description': 'Official-source checks are not independent factual corroboration.'}, 'missing_or_expired_years': {'type': 'array', 'items': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991}}}, 'additionalProperties': False}