Defaults

Table containing various update-able default values that are used within SQLHTTP

  • Table
  • SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017
Column name Data type Description
SessionMaxInactiveDuration int

Default number of minutes after which SQLHTTP will no longer consider a session valid and purge its associated values.

Default: 120

HttpDefaultUserAgent nvarchar (8000)

Default UserAgent HTTP Request Header value used with the HTTPRequest Stored Procedure. See the UserAgents Table for more information.

Default:
Chrome 32.0.1667.0 (Win 8 – 64 bit)

HttpDefaultContentType nvarchar (MAX)

Default ContentType HTTP Request Header value used with the HTTPRequest Stored Procedure.

Default:
application/x-www-form-urlencoded

HttpDefaultAccept nvarchar (MAX)

Default Accept Request Header value used with the HTTPRequest Stored Procedure.

Default: (See Remarks)

JsonDefaultNoNameNode varchar (50)

Default XML node name used with the JSON_To_XML stored procedure.

Default: NoName

Remarks:

HttpDefaultAccess default value:
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8

See Also: