Discovered Dependencies for an Entity

/api/repositories/{repository}/entities/{entity}/dependencies/discovered

Parameter	Type	Purpose
repository	string	the name of the Repository
entity	int	The ID of the entity to view

Get

GET /api/repositories/(string: repository)/entities/(int: entityID)/dependencies/discovered

Lists discovered dependencies of the corresponding Entity

GET /api/repositories/jupiter/entities/1/dependencies/discovered HTTP/1.1
Accept: application/json

Response Code	Reason
200	No error
500	Server error

The response will be a Standard Response, with a list of discovered dependencies in the corresponding Entity.

Columns

The columns array will contain the list of columns for each data row.

Human Name	Column Name	Description
Lh Attrs	_lhnames	The attributes that determine the rh attribute
Rh Attr	_rhname	The attribute that is determined by the lh attribute(s)
Status	__STATUS	Whether the dependency is Discovered or Permanent.
Verified	_verified	Whether the rule quality has been verified against all rows.
Job	JOB_ID	The scheduler job that created this rule.
Quality %	GOODNESS	A measure of how well the attributes form a dependency
Confirming LR Values	CONFIRMATIONS	The number of lh values that do determine their rh value.
Conflicting LH Values	SETS	The number of distinct lh values that do not determine their rh value
Resolved %	_resolved	The percentage of conflicting LH Values that have been resolved
Normalise Flag	_normalise	Dependency can be included in a normalisation (1=true, 0=false)
Conflicting Rows	CONTRADICTIONS	The number of rows where the lh value does not determine their rh value
Verified Date	_checked_date	When the dependency was last verified.
Verified By	CHECKED_BY	Who verified the dependency.
Created Date	_created_date	When the dependency rule was created.
Created By	CREATED_BY	Who created the dependency rule.
Dependency Key	_fd_key	Internal key for this dependency
Rh Attr ID	RH_ATTR	Ids of the right hand attributes that form the primary key
Lh Attr Ids	LH_ATTRS	Ids of the left hand attributes that form the primary key

Data Row

The data row will contain the list of discovered dependencies in the corresponding Entity:

"rows": [
{
    "dataRow": [
    "Account Holder",
    "Deactivated Date",
    "Discovered",
    "Yes",
    "1",
    "99.875",
    "1602",
    "1",
    "",
    "0",
    "3",
    "2015/02/12 13:36:48",
    "bob",
    "2015/02/12 13:36:48",
    "bob",
    "19 14",
    "19",
    "14"
    ],
    "metadata": {
        "url": "/api/repositories/alpha/entities/1/dependencies/19-14/conflicts/"
    }
}

If there are no discovered dependencies in the Entity, rows will be an empty string.

Post

POST /api/repositories/(string: repository)/entities/(int: entityID)/dependencies/discovered

Lists discovered dependencies of the corresponding entity, allow user to pass in supported options (Paging, Columns, Sorting & Cache) see Standard Request for more information on these options.

POST /api/repositories/{repository}/entities/{entity}/dependencies/discovered HTTP/1.1
Content-Type: application/json

{
    "command": "get",
    "options": {
        "pageStart": "1",
        "pageSize": "65"
    }
}

Response Code	Reason
200	Success
400	Bad Request
500	Server error

The request packet must contain the command element. The options elements is optional.

The response will be a Standard Response, with a list of discovered dependencies in the corresponding Entity.

The columns array will contain the list of columns for each data row as listed in above columns.

The data row will contain the list of discovered dependencies in the corresponding Entity similar to ones listed in above data row

Discovered Dependencies for an Attribute

/api/repositories/{repository}/entities/{entity}/attributes/{attribute}/dependencies/discovered

Parameter	Type	Purpose
repository	string	the name of the Repository
entity	int	The ID of the entity to view
attribute	int	The ID of the attribute to view

Get

GET /api/repositories/(string: repository)/entities/(int: entityID)/attributes/(int: attributeID)/dependencies/discovered

Lists discovered dependencies of the corresponding attribute

GET /api/repositories/jupiter/entities/1/attributes/1/dependencies/discovered HTTP/1.1
Accept: application/json

Response Code	Reason
200	No error
400	Bad Request
500	Server error

The response will be a Standard Response, with a list of discovered dependencies in the corresponding Attributes.

Columns

The columns array will contain the list of columns for each data row as listed in above columns.

Data Row

The data row will contain the list of discovered dependencies in the corresponding Attributes:

"rows": [
{
    "dataRow": [
    "Line 03",
    "Line 01",
    "Discovered",
    "Yes",
    "1",
    "98.000",
    "49",
    "1",
    "",
    "0",
    "2",
    "2015/02/05 11:53:02",
    "bob@TEST-7",
    "2015/02/05 11:53:02",
    "bob@TEST-7",
    "1 3",
    "1",
    "3"
    ],
    "metadata": {
    "url": "/api/repositories/test/entities/1/attributes/1/dependencies/1-3/conflicts/"
    }
}
]

If there are no discovered dependencies in the Attributes, rows will be an empty string.

Post

POST /api/repositories/(string: repository)/entities/(int: entityID)/attributes/(int: attributeID)/dependencies/discovered

Lists discovered dependencies of the corresponding attribute, allow user to pass in supported options (Paging, Columns, Sorting & Cache) see Standard Request for more information on these options.

POST /api/repositories/{repository}/entities/{entity}/attributes/{attribute}/dependencies/discovered HTTP/1.1
Content-Type: application/json

{
    "command": "get",
    "options": {
        "pageStart": "1",
        "pageSize": "65"
    }
}

Response Code	Reason
200	Success
400	Bad Request
500	Server error

The request packet must contain the command element. The options elements is optional.

The response will be a Standard Response, with a list of discovered dependencies in the corresponding Attributes.

The columns array will contain the list of columns for each data row as listed in above columns.

The data row will contain the list of discovered dependencies in the corresponding Attributes similar to ones listed in above data row