GET api/DataEntityLookups?include={include}

Request Information

URI Parameters

Name	Description	Type	Additional information
include		string	Default value is
Body Parameters

None.
Response Information

Resource Description

Collection of DataEntityLookup
Name	Type	Additional information
Id	integer	None.
DataEntityId	integer	None.
TableName	string	None.
InFormId	integer	None.
DemUniqueId	globally unique identifier	None.
IsDeleted	boolean	None.
DataEntity	DataEntity	None.
DataEntityLookupForms	Collection of DataEntityLookupForm	None.
Response Formats

application/json, text/json

Sample:
[
  {
    "Id": 1,
    "DataEntityId": 1,
    "TableName": "sample string 2",
    "InFormId": 1,
    "DemUniqueId": "12ca0122-0721-4d4a-a657-fd7f0072b05e",
    "IsDeleted": true,
    "DataEntity": {
      "Id": 1,
      "OrganisationId": 1,
      "ClientId": 1,
      "ParentRepoId": 1,
      "DemEntityId": 1,
      "DemUniqueId": "4f2fee40-e209-4f7d-8478-8d3b308f8853",
      "EntityName": "sample string 2",
      "DataEntityTypeId": 1,
      "IsActive": true,
      "InFormId": 1,
      "IsDeleted": true,
      "IsPrivate": true,
      "HasSecondaryRepositories": true,
      "DataEntityType": {
        "Id": 1,
        "Type": "sample string 2"
      },
      "DataEntityEndpoints": [
        {
          "Id": 1,
          "Guid": "22325628-e2ca-4037-abd5-89c47daf2a20",
          "DataEntityId": 1,
          "Name": "sample string 2",
          "IsDeleted": true,
          "PerspectiveTableId": 4,
          "DataEntityEndpointColumns": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Alias": "sample string 6",
              "Ordinal": 1
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Alias": "sample string 6",
              "Ordinal": 1
            }
          ],
          "DataEntityRelationships": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "SourceTableId": 4,
              "SourceKeyFieldId": 5,
              "TargetTableId": 6,
              "TargetKeyFieldId": 7
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "SourceTableId": 4,
              "SourceKeyFieldId": 5,
              "TargetTableId": 6,
              "TargetKeyFieldId": 7
            }
          ],
          "DataEntityEndpointFilters": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Operator": "sample string 6",
              "Clause": "sample string 7",
              "Settable": true
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Operator": "sample string 6",
              "Clause": "sample string 7",
              "Settable": true
            }
          ]
        },
        {
          "Id": 1,
          "Guid": "22325628-e2ca-4037-abd5-89c47daf2a20",
          "DataEntityId": 1,
          "Name": "sample string 2",
          "IsDeleted": true,
          "PerspectiveTableId": 4,
          "DataEntityEndpointColumns": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Alias": "sample string 6",
              "Ordinal": 1
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Alias": "sample string 6",
              "Ordinal": 1
            }
          ],
          "DataEntityRelationships": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "SourceTableId": 4,
              "SourceKeyFieldId": 5,
              "TargetTableId": 6,
              "TargetKeyFieldId": 7
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "SourceTableId": 4,
              "SourceKeyFieldId": 5,
              "TargetTableId": 6,
              "TargetKeyFieldId": 7
            }
          ],
          "DataEntityEndpointFilters": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Operator": "sample string 6",
              "Clause": "sample string 7",
              "Settable": true
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Operator": "sample string 6",
              "Clause": "sample string 7",
              "Settable": true
            }
          ]
        }
      ],
      "DataEntityLookups": [],
      "DataEntityMatchings": [
        {
          "Id": 1,
          "DataEntityId": 1,
          "Name": "sample string 2",
          "MatchingId": 1,
          "IsDeleted": true,
          "LastRun": "2026-01-13T01:40:56.0379995+00:00"
        },
        {
          "Id": 1,
          "DataEntityId": 1,
          "Name": "sample string 2",
          "MatchingId": 1,
          "IsDeleted": true,
          "LastRun": "2026-01-13T01:40:56.0379995+00:00"
        }
      ],
      "DataEntityUsers": [
        {
          "Id": 1,
          "RoleId": 1,
          "UserId": "sample string 2",
          "UniqueEntityId": 3,
          "UserPkId": 1,
          "DataEntityId": 1,
          "Role": {
            "Id": 1,
            "ApplicationId": 1,
            "Name": "sample string 2",
            "RoleId": "sample string 3",
            "Application": {
              "Id": 1,
              "ApplicationName": "sample string 2"
            }
          }
        },
        {
          "Id": 1,
          "RoleId": 1,
          "UserId": "sample string 2",
          "UniqueEntityId": 3,
          "UserPkId": 1,
          "DataEntityId": 1,
          "Role": {
            "Id": 1,
            "ApplicationId": 1,
            "Name": "sample string 2",
            "RoleId": "sample string 3",
            "Application": {
              "Id": 1,
              "ApplicationName": "sample string 2"
            }
          }
        }
      ],
      "DataEntityProcesses": [
        {
          "Id": 1,
          "DataEntityId": 2,
          "ProcessId": 3,
          "ProcessRunId": 4,
          "Name": "sample string 5",
          "IsDeleted": true,
          "ProcessRun": {}
        },
        {
          "Id": 1,
          "DataEntityId": 2,
          "ProcessId": 3,
          "ProcessRunId": 4,
          "Name": "sample string 5",
          "IsDeleted": true,
          "ProcessRun": {}
        }
      ],
      "DataEntityForms": [
        {
          "Id": 1,
          "DataEntityId": 1,
          "FormId": 2,
          "IsDeleted": true
        },
        {
          "Id": 1,
          "DataEntityId": 1,
          "FormId": 2,
          "IsDeleted": true
        }
      ]
    },
    "DataEntityLookupForms": [
      {
        "Id": 1,
        "DataEntityLookupId": 2,
        "FormId": 3,
        "IsDeleted": true
      },
      {
        "Id": 1,
        "DataEntityLookupId": 2,
        "FormId": 3,
        "IsDeleted": true
      }
    ]
  },
  {
    "Id": 1,
    "DataEntityId": 1,
    "TableName": "sample string 2",
    "InFormId": 1,
    "DemUniqueId": "12ca0122-0721-4d4a-a657-fd7f0072b05e",
    "IsDeleted": true,
    "DataEntity": {
      "Id": 1,
      "OrganisationId": 1,
      "ClientId": 1,
      "ParentRepoId": 1,
      "DemEntityId": 1,
      "DemUniqueId": "4f2fee40-e209-4f7d-8478-8d3b308f8853",
      "EntityName": "sample string 2",
      "DataEntityTypeId": 1,
      "IsActive": true,
      "InFormId": 1,
      "IsDeleted": true,
      "IsPrivate": true,
      "HasSecondaryRepositories": true,
      "DataEntityType": {
        "Id": 1,
        "Type": "sample string 2"
      },
      "DataEntityEndpoints": [
        {
          "Id": 1,
          "Guid": "22325628-e2ca-4037-abd5-89c47daf2a20",
          "DataEntityId": 1,
          "Name": "sample string 2",
          "IsDeleted": true,
          "PerspectiveTableId": 4,
          "DataEntityEndpointColumns": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Alias": "sample string 6",
              "Ordinal": 1
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Alias": "sample string 6",
              "Ordinal": 1
            }
          ],
          "DataEntityRelationships": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "SourceTableId": 4,
              "SourceKeyFieldId": 5,
              "TargetTableId": 6,
              "TargetKeyFieldId": 7
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "SourceTableId": 4,
              "SourceKeyFieldId": 5,
              "TargetTableId": 6,
              "TargetKeyFieldId": 7
            }
          ],
          "DataEntityEndpointFilters": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Operator": "sample string 6",
              "Clause": "sample string 7",
              "Settable": true
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Operator": "sample string 6",
              "Clause": "sample string 7",
              "Settable": true
            }
          ]
        },
        {
          "Id": 1,
          "Guid": "22325628-e2ca-4037-abd5-89c47daf2a20",
          "DataEntityId": 1,
          "Name": "sample string 2",
          "IsDeleted": true,
          "PerspectiveTableId": 4,
          "DataEntityEndpointColumns": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Alias": "sample string 6",
              "Ordinal": 1
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Alias": "sample string 6",
              "Ordinal": 1
            }
          ],
          "DataEntityRelationships": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "SourceTableId": 4,
              "SourceKeyFieldId": 5,
              "TargetTableId": 6,
              "TargetKeyFieldId": 7
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "SourceTableId": 4,
              "SourceKeyFieldId": 5,
              "TargetTableId": 6,
              "TargetKeyFieldId": 7
            }
          ],
          "DataEntityEndpointFilters": [
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Operator": "sample string 6",
              "Clause": "sample string 7",
              "Settable": true
            },
            {
              "Id": 1,
              "DataEntityId": 2,
              "DataEntityEndpointId": 3,
              "DataEntityStructureId": 4,
              "DataEntityStructureFieldId": 5,
              "Operator": "sample string 6",
              "Clause": "sample string 7",
              "Settable": true
            }
          ]
        }
      ],
      "DataEntityLookups": [],
      "DataEntityMatchings": [
        {
          "Id": 1,
          "DataEntityId": 1,
          "Name": "sample string 2",
          "MatchingId": 1,
          "IsDeleted": true,
          "LastRun": "2026-01-13T01:40:56.0379995+00:00"
        },
        {
          "Id": 1,
          "DataEntityId": 1,
          "Name": "sample string 2",
          "MatchingId": 1,
          "IsDeleted": true,
          "LastRun": "2026-01-13T01:40:56.0379995+00:00"
        }
      ],
      "DataEntityUsers": [
        {
          "Id": 1,
          "RoleId": 1,
          "UserId": "sample string 2",
          "UniqueEntityId": 3,
          "UserPkId": 1,
          "DataEntityId": 1,
          "Role": {
            "Id": 1,
            "ApplicationId": 1,
            "Name": "sample string 2",
            "RoleId": "sample string 3",
            "Application": {
              "Id": 1,
              "ApplicationName": "sample string 2"
            }
          }
        },
        {
          "Id": 1,
          "RoleId": 1,
          "UserId": "sample string 2",
          "UniqueEntityId": 3,
          "UserPkId": 1,
          "DataEntityId": 1,
          "Role": {
            "Id": 1,
            "ApplicationId": 1,
            "Name": "sample string 2",
            "RoleId": "sample string 3",
            "Application": {
              "Id": 1,
              "ApplicationName": "sample string 2"
            }
          }
        }
      ],
      "DataEntityProcesses": [
        {
          "Id": 1,
          "DataEntityId": 2,
          "ProcessId": 3,
          "ProcessRunId": 4,
          "Name": "sample string 5",
          "IsDeleted": true,
          "ProcessRun": {}
        },
        {
          "Id": 1,
          "DataEntityId": 2,
          "ProcessId": 3,
          "ProcessRunId": 4,
          "Name": "sample string 5",
          "IsDeleted": true,
          "ProcessRun": {}
        }
      ],
      "DataEntityForms": [
        {
          "Id": 1,
          "DataEntityId": 1,
          "FormId": 2,
          "IsDeleted": true
        },
        {
          "Id": 1,
          "DataEntityId": 1,
          "FormId": 2,
          "IsDeleted": true
        }
      ]
    },
    "DataEntityLookupForms": [
      {
        "Id": 1,
        "DataEntityLookupId": 2,
        "FormId": 3,
        "IsDeleted": true
      },
      {
        "Id": 1,
        "DataEntityLookupId": 2,
        "FormId": 3,
        "IsDeleted": true
      }
    ]
  }
]
application/xml

Sample:
An exception has occurred while using the formatter 'XmlMediaTypeFormatter' to generate sample for media type 'application/xml'. Exception message: Object graph for type 'DOMDM.WebApi.Models.DataEntity' contains cycles and cannot be serialized if reference tracking is disabled.
text/xml

Sample:
An exception has occurred while using the formatter 'XmlMediaTypeFormatter' to generate sample for media type 'text/xml'. Exception message: Object graph for type 'DOMDM.WebApi.Models.DataEntity' contains cycles and cannot be serialized if reference tracking is disabled.