Interaction dataset for the JSON data schema
Learn about the interaction dataset for the JSON-based schema.
This table holds data for all interactions. Use these datasets to view your interaction metadata.
| Field | Description | Data type/Mode |
|---|---|---|
| Uri | The universal resource identifier. It is in the format <ObjectTypeSpecifier>/Id. Example: For interactions the
| Data type: STRING Mode: NULLABLE |
| Type | The interaction type in Reltio. | Data type: STRING Mode: NULLABLE |
| Id | The interaction identifier in Reltio. | Data type: STRING Mode: NULLABLE |
| createdTime | The timestamp when the entity is created in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| createdBy | The user who created the entity. | Data type: STRING Mode: NULLABLE |
| updatedTime | The timestamp when the entity is last updated in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| updatedBy | The user who last updated the entity. | Data type: STRING Mode: NULLABLE |
| deletedTime | The time when the entity is deleted. | Data type: TIMESTAMP Mode: NULLABLE |
| deleted | An indicator that tells you whether the entity is deleted or not. | Data type: BOOLEAN Mode: NULLABLE |
| startDate | The date when the entity is created in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| endDate | The date when the entity is marked for a soft delete, if it is already deleted, in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| eventTime | The time when an event is logged in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| insertedTime | The time when an entity is inserted in the GBQ table. | Data type: TIMESTAMP Mode: NULLABLE |
| versionTime | The object version in Reltio. | Data type: INTEGER Mode: NULLABLE |
| conflictedAttributes | The location of all attributes that are currently not in the attributes schema. After the tables are deleted and data is resynchronized, these values are added to the attribute column in the attributes schema. | Data type: STRING Mode: NULLABLE |
| Crosswalk | A representation of the interaction's crosswalk ID in Reltio. | Data type: STRING Mode: NULLABLE |
| attributes | The location of the entity's attribute information in JSON format. | Data type: JSON Mode: NULLABLE |