AO Table Export Specification

Overview

The AO Table files contain the Vendor AO table data from DC. The file follows the format in Export File Specification.

A file is generated for each AO Table owned by the Vendor. There may be more than one file per table, as files may be provided incrementally or split across multiple files when they exceed the chunking limit.

Metadata Header (First Row)

The first line of every export file contains metadata about the export. The meta contains the table name, and column definitions from the DC table. All columns from the DC AO tables will be included.

Example metadata line (formatted for readability)

1
2
{"table":"AO_6FF49D_DOMAIN_SCAN",
  "columns":[{"name":"BLOCKED_DOMAINS_COUNT","type":"number","size":64,"nullable":true},
    {"name":"DISTINCT_DOMAINS_COUNT","type":"number","size":64,"nullable":true},
    {"name":"EXECUTION_TIME","type":"number","size":64,"nullable":true},
    {"name":"FINISHED_AT","type":"number","size":64,"nullable":true},
    {"name":"ID","type":"varchar","size":-1,"nullable":false},
    {"name":"LOOKUP_METHOD","type":"varchar","size":-1,"nullable":true},
    {"name":"STARTED_AT","type":"number","size":64,"nullable":true},
    {"name":"STATUS","type":"varchar","size":-1,"nullable":true},
    {"name":"DELETED","type":"boolean","size":1,"nullable":false},
    {"name":"TXN_SEQUENCE","type":"integer","size":19,"nullable":false}],
  "primaryKeys":["ID"],
  "rowCount":0,
  "TYPE":"METADATA"}

Data Record Lines

The data records lines contain the data from the DC tables.

Example data record line (formatted for readability)

1
2
{"BLOCKED_DOMAINS_COUNT":0,"DISTINCT_DOMAINS_COUNT":1,"EXECUTION_TIME":3923,"FINISHED_AT":1773982903301,
  "ID":"821a09b3-8593-4c4b-a636-e483564f4d01","LOOKUP_METHOD":"UMS","STARTED_AT":1773982899378,
  "STATUS":"FINISHED","DELETED":false,"TXN_SEQUENCE":0}