Returning Details for a Single Column

If you wish to see metrics and details around a single column you can use the following API.

curl "https://<YOUR API ENDPOINT>/inspection/input/field/<YOUR DATA SOURCE ID>/<column name>/<data type>?onlyDistributions=true" \
-H 'Content-Type: application/json' \
-H 'Authorization: <YOUR API KEY>' \
|jq '[.fields[]]'

This will return the details of the column.

{
  "distribution": [
    {
      "value": "Technician",
      "count": 15
    },
    {
      "value": "Device",
      "count": 13
    }
  ],
  "fillDistribution": [
    {
      "value": 0,
      "count": 1
    },
    {
      "value": 1,
      "count": 28
    }
  ],
  "recordFillDistribution": [
    {
      "value": 0,
      "count": 1
    },
    {
      "value": 1,
      "count": 28
    }
  ],
  "lengthDistribution": [
    {
      "value": 6,
      "count": 13,
      "minValue": 6,
      "maxValue": 6
    },
    {
      "value": 10,
      "count": 15,
      "minValue": 10,
      "maxValue": 10
    }
  ],
  "fieldType": "string",
  "availableSamples": [
    {
      "operation": {
        "clazz": "UploadFileInput",
        "id": "6d0358d5-4ab5-40a6-8cfc-59df492168f6",
        "globalId": "6d0358d5-4ab5-40a6-8cfc-59df492168f6",
        "organizationId": "1b834115-5cd1-4939-897e-eda130dafdf8",
        "computeEnvironment": "b84e6e78-e26e-40a6-9890-00ddc3201136",
        "connectionPointer": "4c6dedaf-5878-4fcc-b82e-6bb2b5050cc3",
        "displayData": {
          "name": "test",
          "description": "",
          "creationTime": "2020-09-12T14:25:56.344935Z",
          "createdBy": "Yoni Iny (yoni@upsolver.com)",
          "modifiedTime": "2020-09-12T14:25:56.415150Z",
          "modifiedBy": "Yoni Iny (yoni@upsolver.com)",
          "versionId": "7f0f1c81-4e2f-48cc-9078-8da02cd4e357"
        },
        "contentType": {
          "clazz": "CsvContentType",
          "inferTypes": false,
          "header": "a,b,c,d,e,f,g,h,i",
          "delimiter": ",",
          "nullValue": "\\N",
          "nestedJsons": [],
          "keepOriginalNestedJsonString": false,
          "headers": [
            "a",
            "b",
            "c",
            "d",
            "e",
            "f",
            "g",
            "h",
            "i"
          ]
        },
        "startExecutionFrom": "2020-09-12T14:23:00Z",
        "folder": "uploads/d967c7c8-2d87-4154-a455-4fdbcb582048",
        "isDeleted": false,
        "version": 48,
        "workspaces": [],
        "previewId": "d5a4c870ad88e4f886a0ec2a95bb175d",
        "executionParallelism": 1,
        "status": {
          "clazz": "Running"
        },
        "safeStartTime": "2020-09-12T14:23:00Z"
      },
      "samples": []
    }
  ],
  "lastUpdate": "2020-09-22T21:22:00Z",
  "knownTotalValues": 28,
  "distinctValuesCount": 2,
  "maximumDistinctValuesCount": 1000,
  "stringRange": {
    "min": "Device",
    "max": "Technician"
  },
  "seen": {
    "first": "2020-09-12T14:23:00Z",
    "last": "2020-09-12T14:23:00Z"
  },
  "resultTimeRange": {
    "startTime": "2020-09-12T14:23:00Z",
    "endTime": "2020-09-22T21:22:00Z"
  },
  "totalRows": 29,
  "hasMoreDistribution": false,
  "totalValues": 28,
  "fillRate": 0.9655172228813171
}