SuiteQL Query Library

HTTP Requests - Outbound

Returns information about outbound HTTP requests being made.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-outbound-http-requests/
SELECT
	TO_CHAR( OutboundRequest.Time, 'YYYY-MM-DD hh:mi:ss') AS RequestTime,
	OutboundRequest.Key,
	OutboundRequest.RequestID,
	OutboundRequest.Elapsed,
	OutboundRequest.Host,
	OutboundRequest.Port,
	OutboundRequest.URL,
	OutboundRequest.StatusCode,
	OutboundRequest.Error,
	OutboundRequest.RequestContentType,	
	OutboundRequest.RequestContentLength,
	OutboundRequest.ResponseContentType,
	OutboundRequest.ResponseContentLength,
	OutboundRequest.ScriptDeploymentURL,
	OutboundRequest.ScriptID,
	Script.Name AS ScriptName,
	Script.ScriptType,
	BUILTIN.DF( Script.Owner ) AS ScriptOwner,	
	MediaItemFolder.Name AS FolderName,	
	File.Name AS FileName,
	File.CreatedDate AS FileCreatedDate,
	File.LastModifiedDate AS FileLastModifiedDate
FROM
	OutboundRequest
	LEFT OUTER JOIN Script ON
		( Script.ScriptID = OutboundRequest.ScriptID )
	LEFT OUTER JOIN File ON
		( File.ID = Script.ScriptFile )
	LEFT OUTER JOIN MediaItemFolder ON
		( MediaItemFolder.ID = File.Folder )
WHERE
	OutboundRequest.Time BETWEEN TO_DATE( '2020-01-01', 'YYYY-MM-DD' ) AND TO_DATE( '2020-12-31', 'YYYY-MM-DD' )
ORDER BY
	OutboundRequest.Time DESC

← Back to Query Library