Obtaining the System of Record Table Schema

When creating and updating records, you supply values for the fields in the data product's schema. You can obtain the schema for a given data product using the API or Tamr Cloud UI.

To obtain the schema programmatically, use either:

  • The list records operation to return a list of records in the SOR table: POST /v1alpha1/tables/{tableId}/records:list
  • The get record operation to return a specific record: GET /api/v1alpha1/tables/{tableId}/records/{recordId}

The schema is returned in the response data block for both operations. For example:

"data": {
    "name": "Acme, Inc.",
    "address": "123 Main St.",
    "city": "Anytown",
    "zip": "12345",
    "phone": "555-1234",
    "website": "http://acme.example.com",
    "country": "USA"
  },

To obtain the schema from the Tamr Cloud UI:

  1. Open the 360 page for a record in the data product.
  2. In the Record History section at the bottom of the page, select a change.
  3. Select Copy Data to copy the data object (schema) from the change to your clipboard, and paste it into a text editor.