Table Relationships

URL	`http://<wmservice-url>/tableRelationships`
Parent Resource	Workflow Manager Service

Description

Represents a list of registered table relationships in the ArcGIS Workflow Manager system. Each table can be associated with job types as either an extended properties relationship (one-to-one) or a linked properties relationship (one-to-many).

Parameters

Parameter	Details
f	Description: The response format. The default response format is html. Values: html \| json

Example Usage

Example 1: URL for the table relationships in the "Workflow" service on sampleserver.

http://sampleserver/arcgis/rest/services/Workflow/WMServer/tableRelationships

JSON Response Syntax

{
  "tableRelationships": [
    {
      "tableName": "<tableName1>",
      "tableAlias": "<tableAlias1>",
      "linkField": "<linkField1>",
      "cardinality": <cardinality1>  // Valid values: 1 (one-to-one), 2 (one-to-many)
    },
    {
      "tableName": "<tableName2>",
      "tableAlias": "<tableAlias2>",
      "linkField": "<linkField2>",
      "cardinality": <cardinality2>
    },
    ...
  ]
}

JSON Response Example

{
  "tableRelationships": [
    {
      "tableName": "JTXX_QAQC_STATUS",
      "tableAlias": "JTXX_QAQC_STATUS",
      "linkField": "JOB_ID",
      "cardinality": 1
    },
    {
      "tableName": "JTXX_RELATED_CUSTOMERS",
      "tableAlias": "JTXX_RELATED_CUSTOMERS",
      "linkField": "JOB_ID",
      "cardinality": 2
    },
  ]
}