synapselinkexternaltablestate EntityType

Synapse Link external table states

Entity set path: 
[organization URI]/api/data/v9.2/synapselinkexternaltablestates
Base type: 
crmbaseentity
Table type: 
Standard
Display name: 
Synapse Link External Table State
Primary key: 
synapselinkexternaltablestateid
Primary name column: 
name
Operations supported: 
POST GET PATCH DELETE

Properties

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

lakehouseshortcutstate Edm.Int32

State of lakehouse shortcut creation for an entity

Display name: Lakehouse Shortcut State

Default options
Values Label
0 Not Created
1 Created
2 Failed
3 Deleted
4 In Progress
lastsynchronizedon Edm.DateTimeOffset

Last SynchronizedOn Date time

Display name: Last Synchronized On

lastsyncstate Edm.Int32

Last data synchronization state

Display name: Last Synchronization State

Default options
Values Label
0 Not Created
1 Created
2 Failed
3 Deleted
4 In Progress
maxrecordversion Edm.Int64

Maximum record version synchronized to the lake

Display name: Maximum Record Version

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

recordcount Edm.Int64

Record count synchronized to lake

Display name: Record Count

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
Values 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
Values 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
Values Label
0 Not Created
1 Created
2 Failed
3 Deleted
4 In Progress
timezoneruleversionnumber Edm.Int32

For internal use only.

Display name: Time Zone Rule Version Number

trinostate Edm.Int32

State of Trino registration for an entity

Display name: Trino State

Default options
Values Label
0 Not Created
1 Created
2 Failed
3 Deleted
4 In Progress
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 Lookup property data.

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

Operations

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

Name Binding
CreateMultiple Not Bound
DeleteMultiple Not Bound
IsValidStateTransition Not Bound
UpdateMultiple Not Bound

See also