Publish Integration Procedure

 Show all Hide all

The procedure specified by the system setting "PublishIntegrationProcedure" is called when publish/integration.ashx is loaded.

You use this procedure if your publish site needs to receive communication from third party servers.

Type: Stored procedure
Area of use: Editable

Parameters:

@Method mandatory varchar
The HTTP method. Usually either GET or POST, though this depends on the caller.
@Referrer mandatory varchar
The HTTP referrer.

This value is easily forged and must not be used to, for example, verify that the call originates from a trusted server. It is only intended to be used for logging and debugging.
@Ip mandatory varchar
The caller's IP address. Not guaranteed to be an IPv4 address.

This value can be forged and must not be used to, for example, verify that the call originates from a trusted server. It is only intended to be used for logging and debugging.

Resultsets:

Resultset: #QueryString

This temp table is available when the procedure is called and contains all query string parameters.

Do note that the table can contain more than one value for the same name.
Repeat mode: repeated exactly once
Row count: zero or more rows

Columns:

Name mandatory string
The name of the query string parameter.
Value mandatory string
The value of the query string parameter.

Resultset: #Form

This temp table is available when the procedure is called and contains all posted form data.

Do note that the table can contain more than one value for the same name.

This table will in practice always be empty when the method is GET.
Repeat mode: repeated exactly once
Row count: zero or more rows

Columns:

Name mandatory string
The name of the form field.
Value mandatory string
The value in the form field.

Resultset: #Session

This temp table is available when the procedure is called and contains all session variables.

This table will in practice always be empty when call comes directly from a third party server, but will contain data if the third party redirects the client's browser back to publish.
Repeat mode:
Row count:

Columns:

Name mandatory string
The name of the session variable.
Value mandatory string
The value of the session variable.

Resultset: Forwarding

This table must be the first returned from the procedure. If present, it is used to redirect the client to a publish page.
Repeat mode: repeated exactly once
Row count: zero or one row

Columns:

ForwardPageId optional int
Publish page to forward to.
xxx optional string
Value to pass as query string parameter xxx.

Resultset: Session variables

This table must be second returned from the procedure. If present, it is used to update session variables.
Repeat mode:
Row count:

Columns:

xxx optional string
Value to assign to session variable xxx.