Azure Connectors Node.js SDK
    Preparing search index...

    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";
          };
      }