Referencia de tabla o entidad synapselinkexternaltablestate

Nota

¿No está seguro de tabla frente a entidad? Vea Desarrolladores: comprender la terminología en Microsoft Dataverse.

Synapse Link external table states

Añadido por: solución Synapse Link

Mensajes

Mensaje Operación de API web Método o clase de SDK
Create POST [org URI]/api/data/v9.0/synapselinkexternaltablestates
Vea Crear
CreateRequest o
Create
CreateMultiple CreateMultiple Action CreateMultipleRequest
Delete DELETE [org URI]/api/data/v9.0/synapselinkexternaltablestates(synapselinkexternaltablestateid)
Vea Eliminar
DeleteRequest o
Delete
IsValidStateTransition IsValidStateTransition Function IsValidStateTransitionRequest
Retrieve GET [org URI]/api/data/v9.0/synapselinkexternaltablestates(synapselinkexternaltablestateid)
Vea Recuperar
RetrieveRequest o
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/synapselinkexternaltablestates
Vea Consultar datos
RetrieveMultipleRequest o
RetrieveMultiple
SetState PATCH [org URI]/api/data/v9.0/synapselinkexternaltablestates(synapselinkexternaltablestateid)
Actualizar propiedades statecode y statuscode.
SetStateRequest
Update PATCH [org URI]/api/data/v9.0/synapselinkexternaltablestates(synapselinkexternaltablestateid)
Vea Actualizar
UpdateRequest o
Update
UpdateMultiple UpdateMultiple Action UpdateMultipleRequest

Propiedades

Propiedad Valor
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

Columnas/atributos que se pueden escribir

Estas columnas o atributos devuelven true para IsValidForCreate o IsValidForUpdate (generalmente ambos). Listado por SchemaName.

datalakefolder

Propiedad Valor
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

Propiedad Valor
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

Propiedad Valor
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

Propiedad Valor
Description State of lakehouse shortcut creation for an entity
DisplayName Lakehouse Shortcut State
IsValidForForm True
IsValidForRead True
LogicalName lakehouseshortcutstate
RequiredLevel None
Type Picklist

Elecciones/opciones de LakehouseShortcutState

Valor Etiqueta Descripción
0 Not Created Not created
1 Created Created
2 Failed Failed
3 Deleted Deleted
4 In Progress In Progress

LastSynchronizedOn

Propiedad Valor
DateTimeBehavior UserLocal
Description Last SynchronizedOn Date time
DisplayName Last Synchronized On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName lastsynchronizedon
RequiredLevel None
Type DateTime

LastSyncState

Propiedad Valor
Description Last data synchronization state
DisplayName Last Synchronization State
IsValidForForm True
IsValidForRead True
LogicalName lastsyncstate
RequiredLevel None
Type Picklist

Elecciones/opciones de LastSyncState

Valor Etiqueta Descripción
0 Not Created Not created
1 Created Created
2 Failed Failed
3 Deleted Deleted
4 In Progress In Progress

MaxRecordVersion

Propiedad Valor
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

Propiedad Valor
Description Metadata version
DisplayName Metadata Version
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName metadataversion
MaxLength 32
RequiredLevel ApplicationRequired
Type String

name

Propiedad Valor
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

Propiedad Valor
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

Propiedad Valor
Description Record count synchronized to lake
DisplayName Record Count
IsValidForForm False
IsValidForRead True
LogicalName recordcount
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

SchemaModifiedOn

Propiedad Valor
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

Propiedad Valor
Description Status of the Synapse Link External Table State
DisplayName Status
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

Elecciones/opciones de statecode

Valor Etiqueta Estado predeterminado Nombre invariable
0 Active 1 Active
1 Inactive 2 Inactive

statuscode

Propiedad Valor
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

Elecciones/opciones de statuscode

Valor Etiqueta Estado
1 Active 0
2 Inactive 1

SynapseDatabaseName

Propiedad Valor
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

Propiedad Valor
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

Propiedad Valor
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

Propiedad Valor
Description External table state
DisplayName Table State
IsValidForForm True
IsValidForRead True
LogicalName tablestate
RequiredLevel ApplicationRequired
Type Picklist

Elecciones/opciones de TableState

Valor Etiqueta Descripción
0 Not Created Not created
1 Created Created
2 Failed Failed
3 Deleted Deleted
4 In Progress In Progress

TimeZoneRuleVersionNumber

Propiedad Valor
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

Propiedad Valor
Description State of Trino registration for an entity
DisplayName Trino State
IsValidForForm True
IsValidForRead True
LogicalName trinostate
RequiredLevel None
Type Picklist

Elecciones/opciones de TrinoState

Valor Etiqueta Descripción
0 Not Created Not created
1 Created Created
2 Failed Failed
3 Deleted Deleted
4 In Progress In Progress

UTCConversionTimeZoneCode

Propiedad Valor
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

Columnas/atributos de sólo lectura

Estas columnas o atributos devuelven false tanto para IsValidForCreate como para IsValidForUpdate. Listado por SchemaName.

CreatedBy

Añadido por: solución Active Solution

Propiedad Valor
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

Añadido por: solución Active Solution

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

Añadido por: solución Active Solution

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

CreatedOn

Propiedad Valor
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

Añadido por: solución Active Solution

Propiedad Valor
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

Añadido por: solución Active Solution

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Añadido por: solución Active Solution

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

datalakefolderName

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName datalakefoldername
MaxLength 100
RequiredLevel None
Type String

ModifiedBy

Añadido por: solución Active Solution

Propiedad Valor
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

Añadido por: solución Active Solution

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

Añadido por: solución Active Solution

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

ModifiedOn

Propiedad Valor
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

Añadido por: solución Active Solution

Propiedad Valor
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

Añadido por: solución Active Solution

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Añadido por: solución Active Solution

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

OrganizationId

Añadido por: solución Active Solution

Propiedad Valor
Description Unique identifier for the organization
DisplayName Organization Id
IsValidForForm False
IsValidForRead True
LogicalName organizationid
RequiredLevel None
Targets organization
Type Lookup

OrganizationIdName

Añadido por: solución Active Solution

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName organizationidname
MaxLength 100
RequiredLevel SystemRequired
Type String

VersionNumber

Añadido por: solución Active Solution

Propiedad Valor
Description Version Number
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

Relaciones de uno a varios

Listado por SchemaName.

synapselinkexternaltablestate_SyncErrors

Añadido por: solución System Solution

Igual que la relación de varios a uno synapselinkexternaltablestate_SyncErrors de la tabla syncerror.

Propiedad Valor
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

Añadido por: solución System Solution

Igual que la relación de varios a uno synapselinkexternaltablestate_DuplicateMatchingRecord de la tabla duplicaterecord.

Propiedad Valor
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

Añadido por: solución System Solution

Igual que la relación de varios a uno synapselinkexternaltablestate_DuplicateBaseRecord de la tabla duplicaterecord.

Propiedad Valor
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

Añadido por: solución System Solution

Igual que la relación de varios a uno synapselinkexternaltablestate_AsyncOperations de la tabla asyncoperation.

Propiedad Valor
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

Añadido por: solución System Solution

Igual que la relación de varios a uno synapselinkexternaltablestate_MailboxTrackingFolders de la tabla mailboxtrackingfolder.

Propiedad Valor
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

Añadido por: solución System Solution

Igual que la relación de varios a uno synapselinkexternaltablestate_ProcessSession de la tabla processsession.

Propiedad Valor
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

Añadido por: solución System Solution

Igual que la relación de varios a uno synapselinkexternaltablestate_BulkDeleteFailures de la tabla bulkdeletefailure.

Propiedad Valor
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

Añadido por: solución System Solution

Igual que la relación de varios a uno synapselinkexternaltablestate_PrincipalObjectAttributeAccesses de la tabla principalobjectattributeaccess.

Propiedad Valor
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

Relaciones de varios a uno

Cada relación de varios a uno se define mediante una relación de uno a varios correspondiente con la tabla relacionada. Listado por SchemaName.

lk_synapselinkexternaltablestate_createdby

Añadido por: solución System Solution

Consulte la relación de uno a varios lk_synapselinkexternaltablestate_createdby de la tabla systemuser.

lk_synapselinkexternaltablestate_createdonbehalfby

Añadido por: solución System Solution

Consulte la relación de uno a varios lk_synapselinkexternaltablestate_createdonbehalfby de la tabla systemuser.

lk_synapselinkexternaltablestate_modifiedby

Añadido por: solución System Solution

Consulte la relación de uno a varios lk_synapselinkexternaltablestate_modifiedby de la tabla systemuser.

lk_synapselinkexternaltablestate_modifiedonbehalfby

Añadido por: solución System Solution

Consulte la relación de uno a varios lk_synapselinkexternaltablestate_modifiedonbehalfby de la tabla systemuser.

organization_synapselinkexternaltablestate

Añadido por: solución System Solution

Consulte la relación de uno a varios organization_synapselinkexternaltablestate de la tabla organization.

synapselinkexternaltablestates

Añadido por: solución Data lake workspaces

Consulte la relación de uno a varios synapselinkexternaltablestates de la tabla datalakefolder.

Consultar también

Referencia de tabla o entidad de Dataverse Referencia de la API web synapselinkexternaltablestate EntityType