Référence d’entité/de table synapselinkexternaltablestate

Notes

Vous n’êtes pas sûr de la table par rapport à l’entité ? Voir Développeurs : Comprendre la terminologie dans Microsoft Dataverse.

Synapse Link external table states

Ajouté par : solution Synapse Link

Messages

Message Opération de l'API web Classe ou méthode SDK
Create POST [org URI]/api/data/v9.0/synapselinkexternaltablestates
Voir Créer
CreateRequest ou
Create
CreateMultiple CreateMultiple Action CreateMultipleRequest
Delete DELETE [org URI]/api/data/v9.0/synapselinkexternaltablestates(synapselinkexternaltablestateid)
Voir Supprimer
DeleteRequest ou
Delete
IsValidStateTransition IsValidStateTransition Function IsValidStateTransitionRequest
Retrieve GET [org URI]/api/data/v9.0/synapselinkexternaltablestates(synapselinkexternaltablestateid)
Voir Récupérer
RetrieveRequest ou
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/synapselinkexternaltablestates
Voir Rechercher des données
RetrieveMultipleRequest ou
RetrieveMultiple
SetState PATCH [org URI]/api/data/v9.0/synapselinkexternaltablestates(synapselinkexternaltablestateid)
Mettre à jour les propriétés statecode et statuscode.
SetStateRequest
Update PATCH [org URI]/api/data/v9.0/synapselinkexternaltablestates(synapselinkexternaltablestateid)
Voir Mettre à jour
UpdateRequest ou
Update
UpdateMultiple UpdateMultiple Action UpdateMultipleRequest

Propriétés

Propriété Valeur
CollectionSchemaName synapselinkexternaltablestates
DisplayCollectionName Synapse Link External Table States
DisplayName Synapse Link External Table State
EntitySetName synapselinkexternaltablestates
IsBPFEntity False
LogicalCollectionName synapselinkexternaltablestates
LogicalName synapselinkexternaltablestate
OwnershipType OrganizationOwned
PrimaryIdAttribute synapselinkexternaltablestateid
PrimaryNameAttribute name
SchemaName synapselinkexternaltablestate

Colonnes/Attributs inscriptibles

Ces colonnes/attributs renvoient la valeur true pour IsValidForCreate ou IsValidForUpdate (généralement les deux). Répertorié par SchemaName.

datalakefolder

Propriété Valeur
Description Unique identifier for Data Lake Folder associated with Synapse Link External Table State.
DisplayName Data Lake Folder
IsValidForForm True
IsValidForRead True
LogicalName datalakefolder
RequiredLevel ApplicationRequired
Targets datalakefolder
Type Lookup

EntityName

Propriété Valeur
Description Name of the entity
DisplayName Entity Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName entityname
MaxLength 64
RequiredLevel ApplicationRequired
Type String

ImportSequenceNumber

Propriété Valeur
Description Sequence number of the import that created this record.
DisplayName Import Sequence Number
Format None
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName importsequencenumber
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

LakehouseShortcutState

Propriété Valeur
Description State of lakehouse shortcut creation for an entity
DisplayName Lakehouse Shortcut State
IsValidForForm True
IsValidForRead True
LogicalName lakehouseshortcutstate
RequiredLevel None
Type Picklist

Choix/Options LakehouseShortcutState

Valeur Étiquette Description
0 Not Created Not created
1 Created Created
2 Failed Failed
3 Deleted Deleted
4 In Progress In Progress

LastSynchronizedOn

Propriété Valeur
DateTimeBehavior UserLocal
Description Last SynchronizedOn Date time
DisplayName Last Synchronized On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName lastsynchronizedon
RequiredLevel None
Type DateTime

LastSyncState

Propriété Valeur
Description Last data synchronization state
DisplayName Last Synchronization State
IsValidForForm True
IsValidForRead True
LogicalName lastsyncstate
RequiredLevel None
Type Picklist

Choix/Options LastSyncState

Valeur Étiquette Description
0 Not Created Not created
1 Created Created
2 Failed Failed
3 Deleted Deleted
4 In Progress In Progress

MaxRecordVersion

Propriété Valeur
Description Maximum record version synchronized to the lake
DisplayName Maximum Record Version
IsValidForForm False
IsValidForRead True
LogicalName maxrecordversion
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

MetadataVersion

Propriété Valeur
Description Metadata version
DisplayName Metadata Version
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName metadataversion
MaxLength 32
RequiredLevel ApplicationRequired
Type String

name

Propriété Valeur
Description The name of the custom entity.
DisplayName Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName name
MaxLength 100
RequiredLevel ApplicationRequired
Type String

OverriddenCreatedOn

Propriété Valeur
DateTimeBehavior UserLocal
Description Date and time that the record was migrated.
DisplayName Record Created On
Format DateOnly
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName overriddencreatedon
RequiredLevel None
Type DateTime

RecordCount

Propriété Valeur
Description Record count synchronized to lake
DisplayName Record Count
IsValidForForm False
IsValidForRead True
LogicalName recordcount
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

SchemaModifiedOn

Propriété Valeur
DateTimeBehavior UserLocal
Description Schema modified on date-time
DisplayName Schema Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName schemamodifiedon
RequiredLevel None
Type DateTime

statecode

Propriété Valeur
Description Status of the Synapse Link External Table State
DisplayName Status
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

Choix/Options statecode

Valeur Étiquette Statut par défaut Nom invariant
0 Active 1 Active
1 Inactive 2 Inactive

statuscode

Propriété Valeur
Description Reason for the status of the Synapse Link External Table State
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status

Choix/Options statuscode

Valeur Étiquette État
1 Active 0
2 Inactive 1

SynapseDatabaseName

Propriété Valeur
Description Synapse database name
DisplayName Synapse Database Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName synapsedatabasename
MaxLength 100
RequiredLevel ApplicationRequired
Type String

synapselinkexternaltablestateId

Propriété Valeur
Description Unique identifier for entity instances
DisplayName Synapse Link External Table State
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName synapselinkexternaltablestateid
RequiredLevel SystemRequired
Type Uniqueidentifier

SynapseWorkspaceName

Propriété Valeur
Description Synapse workspace name
DisplayName Synapse Workspace Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName synapseworkspacename
MaxLength 100
RequiredLevel ApplicationRequired
Type String

TableState

Propriété Valeur
Description External table state
DisplayName Table State
IsValidForForm True
IsValidForRead True
LogicalName tablestate
RequiredLevel ApplicationRequired
Type Picklist

Choix/Options TableState

Valeur Étiquette Description
0 Not Created Not created
1 Created Created
2 Failed Failed
3 Deleted Deleted
4 In Progress In Progress

TimeZoneRuleVersionNumber

Propriété Valeur
Description For internal use only.
DisplayName Time Zone Rule Version Number
Format None
IsValidForForm False
IsValidForRead True
LogicalName timezoneruleversionnumber
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

TrinoState

Propriété Valeur
Description State of Trino registration for an entity
DisplayName Trino State
IsValidForForm True
IsValidForRead True
LogicalName trinostate
RequiredLevel None
Type Picklist

Choix/Options TrinoState

Valeur Étiquette Description
0 Not Created Not created
1 Created Created
2 Failed Failed
3 Deleted Deleted
4 In Progress In Progress

UTCConversionTimeZoneCode

Propriété Valeur
Description Time zone code that was in use when the record was created.
DisplayName UTC Conversion Time Zone Code
Format None
IsValidForForm False
IsValidForRead True
LogicalName utcconversiontimezonecode
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

Colonnes/Attributs en lecture seule

Ces colonnes/attributs renvoient la valeur false pour IsValidForCreate ou IsValidForUpdate. Répertorié par SchemaName.

CreatedBy

Ajouté par : solution Active Solution

Propriété Valeur
Description Unique identifier of the user who created the record.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedByName

Ajouté par : solution Active Solution

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

Ajouté par : solution Active Solution

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

CreatedOn

Propriété Valeur
DateTimeBehavior UserLocal
Description Date and time when the record was created.
DisplayName Created On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

CreatedOnBehalfBy

Ajouté par : solution Active Solution

Propriété Valeur
Description Unique identifier of the delegate user who created the record.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOnBehalfByName

Ajouté par : solution Active Solution

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Ajouté par : solution Active Solution

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

datalakefolderName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName datalakefoldername
MaxLength 100
RequiredLevel None
Type String

ModifiedBy

Ajouté par : solution Active Solution

Propriété Valeur
Description Unique identifier of the user who modified the record.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedByName

Ajouté par : solution Active Solution

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

Ajouté par : solution Active Solution

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

ModifiedOn

Propriété Valeur
DateTimeBehavior UserLocal
Description Date and time when the record was modified.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

Ajouté par : solution Active Solution

Propriété Valeur
Description Unique identifier of the delegate user who modified the record.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

Ajouté par : solution Active Solution

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Ajouté par : solution Active Solution

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

OrganizationId

Ajouté par : solution Active Solution

Propriété Valeur
Description Unique identifier for the organization
DisplayName Organization Id
IsValidForForm False
IsValidForRead True
LogicalName organizationid
RequiredLevel None
Targets organization
Type Lookup

OrganizationIdName

Ajouté par : solution Active Solution

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName organizationidname
MaxLength 100
RequiredLevel SystemRequired
Type String

VersionNumber

Ajouté par : solution Active Solution

Propriété Valeur
Description Version Number
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

Relations un-à-plusieurs

Répertorié par SchemaName.

synapselinkexternaltablestate_SyncErrors

Ajouté par : solution System Solution

Identique à la relation plusieurs à un synapselinkexternaltablestate_SyncErrors pour la table/entité syncerror.

Propriété Valeur
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName synapselinkexternaltablestate_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

synapselinkexternaltablestate_DuplicateMatchingRecord

Ajouté par : solution System Solution

Identique à la relation plusieurs à un synapselinkexternaltablestate_DuplicateMatchingRecord pour la table/entité duplicaterecord.

Propriété Valeur
ReferencingEntity duplicaterecord
ReferencingAttribute duplicaterecordid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName synapselinkexternaltablestate_DuplicateMatchingRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

synapselinkexternaltablestate_DuplicateBaseRecord

Ajouté par : solution System Solution

Identique à la relation plusieurs à un synapselinkexternaltablestate_DuplicateBaseRecord pour la table/entité duplicaterecord.

Propriété Valeur
ReferencingEntity duplicaterecord
ReferencingAttribute baserecordid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName synapselinkexternaltablestate_DuplicateBaseRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

synapselinkexternaltablestate_AsyncOperations

Ajouté par : solution System Solution

Identique à la relation plusieurs à un synapselinkexternaltablestate_AsyncOperations pour la table/entité asyncoperation.

Propriété Valeur
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName synapselinkexternaltablestate_AsyncOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

synapselinkexternaltablestate_MailboxTrackingFolders

Ajouté par : solution System Solution

Identique à la relation plusieurs à un synapselinkexternaltablestate_MailboxTrackingFolders pour la table/entité mailboxtrackingfolder.

Propriété Valeur
ReferencingEntity mailboxtrackingfolder
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName synapselinkexternaltablestate_MailboxTrackingFolders
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

synapselinkexternaltablestate_ProcessSession

Ajouté par : solution System Solution

Identique à la relation plusieurs à un synapselinkexternaltablestate_ProcessSession pour la table/entité processsession.

Propriété Valeur
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName synapselinkexternaltablestate_ProcessSession
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

synapselinkexternaltablestate_BulkDeleteFailures

Ajouté par : solution System Solution

Identique à la relation plusieurs à un synapselinkexternaltablestate_BulkDeleteFailures pour la table/entité bulkdeletefailure.

Propriété Valeur
ReferencingEntity bulkdeletefailure
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName synapselinkexternaltablestate_BulkDeleteFailures
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

synapselinkexternaltablestate_PrincipalObjectAttributeAccesses

Ajouté par : solution System Solution

Identique à la relation plusieurs à un synapselinkexternaltablestate_PrincipalObjectAttributeAccesses pour la table/entité principalobjectattributeaccess.

Propriété Valeur
ReferencingEntity principalobjectattributeaccess
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName synapselinkexternaltablestate_PrincipalObjectAttributeAccesses
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Relations plusieurs-à-un

Chaque relation plusieurs-à-un est définie par une relation un-à-plusieurs correspondante avec la table associée. Répertorié par SchemaName.

lk_synapselinkexternaltablestate_createdby

Ajouté par : solution System Solution

Voir la relation un à plusieurs lk_synapselinkexternaltablestate_createdby pour la table/entité systemuser.

lk_synapselinkexternaltablestate_createdonbehalfby

Ajouté par : solution System Solution

Voir la relation un à plusieurs lk_synapselinkexternaltablestate_createdonbehalfby pour la table/entité systemuser.

lk_synapselinkexternaltablestate_modifiedby

Ajouté par : solution System Solution

Voir la relation un à plusieurs lk_synapselinkexternaltablestate_modifiedby pour la table/entité systemuser.

lk_synapselinkexternaltablestate_modifiedonbehalfby

Ajouté par : solution System Solution

Voir la relation un à plusieurs lk_synapselinkexternaltablestate_modifiedonbehalfby pour la table/entité systemuser.

organization_synapselinkexternaltablestate

Ajouté par : solution System Solution

Voir la relation un à plusieurs organization_synapselinkexternaltablestate pour la table/entité organization.

synapselinkexternaltablestates

Ajouté par : solution Data lake workspaces

Voir la relation un à plusieurs synapselinkexternaltablestates pour la table/entité datalakefolder.

Voir aussi

Référence d’entité/de table Dataverse Référence d’API web synapselinkexternaltablestate EntityType