Variable SqlTriggerParametersConst
SqlTriggerParameters: {
OnNewItems: {
database: {
description: "Database name";
dynamicValuesOperationId: "GetDatabases";
name: "database";
required: true;
summary: "Database name";
type: "string";
};
filter: {
description: "An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).";
name: "$filter";
required: false;
summary: "Filter Query";
type: "string";
};
orderby: {
description: "An ODATA orderBy query for specifying the order of entries.";
name: "$orderby";
required: false;
summary: "Order By";
type: "string";
};
select: {
description: "Specific fields to retrieve from entries (default = all).";
name: "$select";
required: false;
summary: "Select Query";
type: "string";
};
server: {
description: "Name of SQL server";
dynamicValuesOperationId: "GetServers";
name: "server";
required: true;
summary: "Server name";
type: "string";
};
table: {
description: "Name of SQL table";
dynamicValuesOperationId: "GetTablesForGetOnNewItems_V2";
name: "table";
required: true;
summary: "Table name";
type: "string";
};
top: {
description: "Total number of entries to retrieve (default = all).";
name: "$top";
required: false;
summary: "Top Count";
type: "integer";
};
xMsOperationContext: {
description: "Special header to enable operation simulation";
name: "x-ms-operation-context";
required: false;
summary: "x-ms-operation-context";
type: "string";
};
};
OnUpdatedItems: {
database: {
description: "Database name";
dynamicValuesOperationId: "GetDatabases";
name: "database";
required: true;
summary: "Database name";
type: "string";
};
filter: {
description: "An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).";
name: "$filter";
required: false;
summary: "Filter Query";
type: "string";
};
orderby: {
description: "An ODATA orderBy query for specifying the order of entries.";
name: "$orderby";
required: false;
summary: "Order By";
type: "string";
};
select: {
description: "Specific fields to retrieve from entries (default = all).";
name: "$select";
required: false;
summary: "Select Query";
type: "string";
};
server: {
description: "Name of SQL server";
dynamicValuesOperationId: "GetServers";
name: "server";
required: true;
summary: "Server name";
type: "string";
};
table: {
description: "Name of SQL table";
dynamicValuesOperationId: "GetTablesForGetOnUpdatedItems_V2";
name: "table";
required: true;
summary: "Table name";
type: "string";
};
top: {
description: "Total number of entries to retrieve (default = all).";
name: "$top";
required: false;
summary: "Top Count";
type: "integer";
};
};
} = ...
Type Declaration
-
ReadonlyOnNewItems: {
database: {
description: "Database name";
dynamicValuesOperationId: "GetDatabases";
name: "database";
required: true;
summary: "Database name";
type: "string";
};
filter: {
description: "An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).";
name: "$filter";
required: false;
summary: "Filter Query";
type: "string";
};
orderby: {
description: "An ODATA orderBy query for specifying the order of entries.";
name: "$orderby";
required: false;
summary: "Order By";
type: "string";
};
select: {
description: "Specific fields to retrieve from entries (default = all).";
name: "$select";
required: false;
summary: "Select Query";
type: "string";
};
server: {
description: "Name of SQL server";
dynamicValuesOperationId: "GetServers";
name: "server";
required: true;
summary: "Server name";
type: "string";
};
table: {
description: "Name of SQL table";
dynamicValuesOperationId: "GetTablesForGetOnNewItems_V2";
name: "table";
required: true;
summary: "Table name";
type: "string";
};
top: {
description: "Total number of entries to retrieve (default = all).";
name: "$top";
required: false;
summary: "Top Count";
type: "integer";
};
xMsOperationContext: {
description: "Special header to enable operation simulation";
name: "x-ms-operation-context";
required: false;
summary: "x-ms-operation-context";
type: "string";
};
}
-
ReadonlyOnUpdatedItems: {
database: {
description: "Database name";
dynamicValuesOperationId: "GetDatabases";
name: "database";
required: true;
summary: "Database name";
type: "string";
};
filter: {
description: "An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).";
name: "$filter";
required: false;
summary: "Filter Query";
type: "string";
};
orderby: {
description: "An ODATA orderBy query for specifying the order of entries.";
name: "$orderby";
required: false;
summary: "Order By";
type: "string";
};
select: {
description: "Specific fields to retrieve from entries (default = all).";
name: "$select";
required: false;
summary: "Select Query";
type: "string";
};
server: {
description: "Name of SQL server";
dynamicValuesOperationId: "GetServers";
name: "server";
required: true;
summary: "Server name";
type: "string";
};
table: {
description: "Name of SQL table";
dynamicValuesOperationId: "GetTablesForGetOnUpdatedItems_V2";
name: "table";
required: true;
summary: "Table name";
type: "string";
};
top: {
description: "Total number of entries to retrieve (default = all).";
name: "$top";
required: false;
summary: "Top Count";
type: "integer";
};
}