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: |
HttpDefaultContentType | nvarchar (MAX) |
Default ContentType HTTP Request Header value used with the HttpRequest Stored Procedure. Default: |
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 |
HttpDefaultAccess default value:
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8