synapselinkexternaltablestate EntityType

Synapse Link external table states

Entity Set Path
[organization URI]/api/data/v9.0/synapselinkexternaltablestates
Base Type
Display Name
Synapse Link External Table State
Primary Key
Primary Key Attribute
Operations Supported


Properties represent fields of data stored in the entity.Some properties are read-only.

Name Type Details
createdon Edm.DateTimeOffset

Date and time when the record was created.

Display Name: Created On

Read Only
entityname Edm.String

Name of the entity

Display Name: Entity Name

importsequencenumber Edm.Int32

Sequence number of the import that created this record.

Display Name: Import Sequence Number

metadataversion Edm.String

Metadata version

Display Name: Metadata Version

modifiedon Edm.DateTimeOffset

Date and time when the record was modified.

Display Name: Modified On

Read Only
name Edm.String

The name of the custom entity.

Display Name: Name

overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display Name: Record Created On

schemamodifiedon Edm.DateTimeOffset

Schema modified on date-time

Display Name: Schema Modified On

statecode Edm.Int32

Status of the Synapse Link External Table State

Display Name: Status

Default Options
Value Label
0 Active
1 Inactive
statuscode Edm.Int32

Reason for the status of the Synapse Link External Table State

Display Name: Status Reason

Default Options
Value Label
1 Active
2 Inactive
synapsedatabasename Edm.String

Synapse database name

Display Name: Synapse Database Name

synapselinkexternaltablestateid Edm.Guid

Unique identifier for entity instances

Display Name: Synapse Link External Table State

synapseworkspacename Edm.String

Synapse workspace name

Display Name: Synapse Workspace Name

tablestate Edm.Int32

External table state

Display Name: Table State

Default Options
Value Label
0 Not Created
1 Created
2 Failed
3 Deleted
timezoneruleversionnumber Edm.Int32

For internal use only.

Display Name: Time Zone Rule Version Number

utcconversiontimezonecode Edm.Int32

Time zone code that was in use when the record was created.

Display Name: UTC Conversion Time Zone Code

versionnumber Edm.Int64

Version Number

Display Name: Version Number

Read Only

Lookup Properties

Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Retrieve data about lookup properties.

Name Single-valued navigation property Description
_createdby_value createdby

Unique identifier of the user who created the record.

_createdonbehalfby_value createdonbehalfby

Unique identifier of the delegate user who created the record.

_datalakefolder_value datalakefolder

Unique identifier for Data Lake Folder associated with Synapse Link External Table State.

_modifiedby_value modifiedby

Unique identifier of the user who modified the record.

_modifiedonbehalfby_value modifiedonbehalfby

Unique identifier of the delegate user who modified the record.

_organizationid_value organizationid

Unique identifier for the organization

Single-valued navigation properties

Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.

Name Type Partner
createdby systemuser lk_synapselinkexternaltablestate_createdby
createdonbehalfby systemuser lk_synapselinkexternaltablestate_createdonbehalfby
datalakefolder datalakefolder synapselinkexternaltablestates
modifiedby systemuser lk_synapselinkexternaltablestate_modifiedby
modifiedonbehalfby systemuser lk_synapselinkexternaltablestate_modifiedonbehalfby
organizationid organization organization_synapselinkexternaltablestate

Collection-valued navigation properties

Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.

Name Type Partner
synapselinkexternaltablestate_AsyncOperations asyncoperation regardingobjectid_synapselinkexternaltablestate
synapselinkexternaltablestate_BulkDeleteFailures bulkdeletefailure regardingobjectid_synapselinkexternaltablestate
synapselinkexternaltablestate_DuplicateBaseRecord duplicaterecord baserecordid_synapselinkexternaltablestate
synapselinkexternaltablestate_DuplicateMatchingRecord duplicaterecord duplicaterecordid_synapselinkexternaltablestate
synapselinkexternaltablestate_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_synapselinkexternaltablestate
synapselinkexternaltablestate_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_synapselinkexternaltablestate
synapselinkexternaltablestate_ProcessSession processsession regardingobjectid_synapselinkexternaltablestate
synapselinkexternaltablestate_SyncErrors syncerror regardingobjectid_synapselinkexternaltablestate


The following operations can be used with the synapselinkexternaltablestate entity type.

Name Binding
IsValidStateTransition Not Bound


The following solutions include the synapselinkexternaltablestate entity type.

Name Description
Synapse Link

See also