mapping contract audit derived

{
  "input": {
    "body": {
      "csv": "country,region\nAU,APAC\nNZ,APAC\nGB,EMEA\nGB,UK\nIE,\nUS,AMER\n",
      "source_column": "country",
      "target_column": "region",
      "expect_injective": true,
      "required_sources": [
        "AU",
        "NZ",
        "GB",
        "US",
        "FR"
      ],
      "permitted_targets": [
        "APAC",
        "EMEA",
        "AMER",
        "LATAM"
      ]
    },
    "type": "http",
    "method": "POST",
    "bodyType": "json"
  },
  "output": {
    "type": "json",
    "example": {
      "valid": false,
      "limits": {
        "maxRows": 5000,
        "maxListed": 200,
        "maxColumns": 64,
        "maxCsvBytes": 262144,
        "maxDatasets": 10,
        "maxFindings": 500,
        "maxCategories": 1000,
        "maxKeyColumns": 4
      },
      "passed": false,
      "complete": false,
      "findings": [
        {
          "row": 6,
          "code": "TARGET_EMPTY",
          "detail": "Row 6 maps IE to nothing, which is a gap rather than a mapping.",
          "source": "IE"
        },
        {
          "row": 4,
          "code": "SOURCE_MAPS_TO_SEVERAL_TARGETS",
          "detail": "GB maps to 2 different targets, so a lookup is not a function and whichever row is read last wins.",
          "source": "GB"
        },
        {
          "code": "TARGET_MAPPED_FROM_SEVERAL_SOURCES",
          "detail": "APAC is the target of 2 sources, and a one-to-one mapping was expected.",
          "target": "APAC"
        }
      ],
      "row_count": 6,
      "request_id": "example-request",
      "service_id": "mapping_contract_audit",
      "assumptions": [
        "Values are canonicalised exactly, so a numeric code written 01 and 1 is the same value and a conflict between them is found.",
        "One source mapping to several targets is always a finding, because a lookup built from it is not a function. One target receiving several sources is only a finding when a one-to-one mapping is declare..."
      ],
      "limitations": [
        "Structure and coverage of the mapping supplied. Whether each individual mapping is correct is not assessed.",
        "valid is true only when the table was fully read, every required source was mapped, every target was permitted, and no source was ambiguous."
      ],
      "observed_at": "2026-10-02T00:00:00.000Z",
      "not_examined": [
        "PERMITTED_TARGET_UNUSED: LATAM is permitted and nothing maps to it, so any handling for it is never reached."
      ],
      "coverage_rate": 0.8,
      "finding_count": 5,
      "service_version": "1.0.0",
      "findings_by_code": {
        "TARGET_EMPTY": 1,
        "TARGET_NOT_PERMITTED": 1,
        "REQUIRED_SOURCE_UNMAPPED": 1,
        "SOURCE_MAPS_TO_SEVERAL_TARGETS": 1,
        "TARGET_MAPPED_FROM_SEVERAL_SOURCES": 1
      },
      "unmapped_sources": [
        "FR"
      ],
      "ambiguous_sources": [
        {
          "rows": [
            4,
            5
          ],
          "source": "GB",
          "targets": [
            "EMEA",
            "UK"
          ]
        }
      ],
      "empty_source_count": 0,
      "empty_target_count": 1,
      "distinct_source_count": 4,
      "distinct_target_count": 4,
      "ambiguous_source_count": 1
    }
  }
}