Association Audit

post

https://app.financekey.com/OData/dbo_Association_CT

Describes the association between two entities.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Body Params

startLSN

string

required

endLSN

string | null

seqVal

string

required

operationId

int32

updateMask

string | null

parentEntityId

string | null

The parent entity in the association. If this is a foreign key, then it is the master entity.

childEntityId

string | null

The Child Entity in the relationship. For Foreign Keys this is the Foreign Table.

associationTypeId

string | null

The type of association.

composite

boolean | null

The Composite field in the Association table is a bit type field, which is a single bit data type representing a Boolean value of either 0 or 1, either False or True. This field is used to represent a single combination or composite of two or more entities that can be defined in the table and is generally used to represent an association between the entities and determine if they are related or not.

referenceId

int32 | null

The name of the field that is referenced. In a Foreign Key association, this is the name of the field that the parent table uses to reference the child/foreign table. For a Collection, this is the name of the field that references the parent table.

name

string | null

The name by which the association should be referred to. The name will be used on the Entity definition to refer to the collection or Foreign Key

displayId

int32 | null

The name of the field that should be displayed inside the drop down list.

filter

string | null

A filter expression that should be applied to the list before items are displayed.

foreignKeyAssociationId

int32 | null

When the collection is part of a many to many association, use this field to specify the '3rd' table in the relationship.

viewId

int32 | null

The ViewId field in the Association table is an integer data type that represents the unique identification number associated with each view or page related to the association.

commandId

int32 | null

Headers

content-type

string

enum

Defaults to application/json;odata.metadata=minimal;odata.streaming=true

Generated from available request content types

Response

200

Language

URL

Loading…

Response

Click Try It! to start a request and see the response here!