Clean Table

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['csv', 'fields'], 'properties': {'csv': {'type': 'string', 'maxLength': 48000, 'minLength': 1, 'description': 'The delimited table, including its header row (1–48000 bytes, at most 2000 data rows).'}, 'fields': {'type': 'array', 'items': {'type': 'object', 'required': ['field', 'column', 'type'], 'properties': {'type': {'enum': ['text', 'date', 'money', 'code'], 'type': 'string', 'description': 'What the value must become.'}, 'field': {'type': 'string', 'maxLength': 64, 'minLength': 1, 'description': 'Output field name.'}, 'column': {'type': 'string', 'maxLength': 128, 'minLength': 1, 'description': 'Source column header, matched case-insensitively.'}, 'required': {'type': 'boolean', 'description': 'A missing value sends the row to exceptions (default true).'}}}, 'maxItems': 12, 'minItems': 1, 'description': 'The agreed schema: which source column becomes which output field, and of what type.'}, 'dateOrder': {'enum': ['DMY', 'MDY'], 'type': 'string', 'description': "Your system's date order. The file's own proof always wins over this."}, 'dedupeKey': {'type': 'string', 'maxLength': 64, 'minLength': 1, 'description': 'Output field to deduplicate on. Omit for no deduplication.'}}}

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