CallWebService Script Examples - Revision history

Ollvihe at 10:48, 21 February 2022

2022-02-21T10:48:46Z

← Older revision		Revision as of 10:48, 21 February 2022
Line 3:		Line 3:
	<pre>		<pre>
	(SELECT 'Method', 'GET') UNION ALL		(SELECT 'Method', 'GET') UNION ALL
	(SELECT 'Address', '~~http~~://google.com') UNION ALL		(SELECT 'Address', 'https://google.com') UNION ALL
	(SELECT 'Content-Type', 'application/json') UNION ALL		(SELECT 'Content-Type', 'application/json') UNION ALL
	(SELECT 'Accept', '/')		(SELECT 'Accept', '/')

Ollvihe at 10:48, 21 February 2022

2022-02-21T10:48:19Z

@@ Line 29: / Line 29: @@
 </nowiki>
 </pre>
 [[Category:Examples]]

Ollvihe at 20:49, 25 October 2021

2021-10-25T20:49:43Z

← Older revision		Revision as of 20:49, 25 October 2021
Line 1:		Line 1:
	This page contains script examples for the [[~~QPR ProcessAnalyzer~~ Scripting Commands#--.23CallWebService\|CallWebService]] script command.		This page contains script examples for the [[SQL Scripting Commands#--.23CallWebService\|CallWebService]] script command.

	<pre>		<pre>

Ollvihe at 11:06, 27 May 2020

2020-05-27T11:06:43Z

← Older revision		Revision as of 11:06, 27 May 2020
Line 4:		Line 4:
	(SELECT 'Method', 'GET') UNION ALL		(SELECT 'Method', 'GET') UNION ALL
	(SELECT 'Address', 'http://google.com') UNION ALL		(SELECT 'Address', 'http://google.com') UNION ALL
	(SELECT '~~ContentType~~', 'application/json') UNION ALL		(SELECT 'Content-Type', 'application/json') UNION ALL
	(SELECT 'Accept', '/')		(SELECT 'Accept', '/')
	--#CallWebService		--#CallWebService

Ollvihe: /* Reload Model in the Memory */

2019-09-06T11:10:14Z

Reload Model in the Memory

← Older revision		Revision as of 11:10, 6 September 2019
Line 100:		Line 100:
	--#CallWebService		--#CallWebService
	PRINT 'LogOff result: ' + COALESCE(@_ResponseText, '<none>') + ' StatusCode: ' + CAST(@_ResponseStatusCode AS NVARCHAR(MAX)) + ' Success: ' + CAST(@_ResponseSuccess AS NVARCHAR(MAX));		PRINT 'LogOff result: ' + COALESCE(@_ResponseText, '<none>') + ' StatusCode: ' + CAST(@_ResponseStatusCode AS NVARCHAR(MAX)) + ' Success: ' + CAST(@_ResponseSuccess AS NVARCHAR(MAX));

	</pre>		</pre>

Ollvihe: /* Reload Model in the Memory */

2019-09-06T11:08:59Z

Reload Model in the Memory

← Older revision		Revision as of 11:08, 6 September 2019
Line 31:		Line 31:

	== Reload Model in the Memory ==		== Reload Model in the Memory ==
	The following script triggers a reload (drop and load) for a QPR ProcessAnalyzer model. The script executes quickly as it does not wait for the model to be loaded, and thus the result of the reloading is not available in the script.		The following script triggers a reload (drop and load) for a QPR ProcessAnalyzer model. The script executes quickly as it does not wait for the model to be loaded, and thus the result of the reloading is not available in the script. The following information needs to be configured in the beginning of the script: QPR ProcessAnalyzer web service url, model id, username and password.

	<pre>		<pre>

Ollvihe: /* Reload model */

2019-09-06T10:53:57Z

Reload model

← Older revision		Revision as of 10:53, 6 September 2019
Line 30:		Line 30:
	</pre>		</pre>

	== Reload ~~model~~ ==		== Reload Model in the Memory ==
	The following script triggers a reload for a model. The script does not wait for the model to be loaded, so the result of the reloading is not available.		The following script triggers a reload (drop and load) for a QPR ProcessAnalyzer model. The script executes quickly as it does not wait for the model to be loaded, and thus the result of the reloading is not available in the script.

	<pre>		<pre>

Ollvihe at 10:52, 6 September 2019

2019-09-06T10:52:03Z

← Older revision		Revision as of 10:52, 6 September 2019
Line 29:		Line 29:
	</nowiki>		</nowiki>
	</pre>		</pre>


	== Reload model ==		== Reload model ==

Ollvihe: /* A ProcessAnalyzer script example to authenticate user, make a simple query into the server and logoff */

2019-09-06T10:51:50Z

A ProcessAnalyzer script example to authenticate user, make a simple query into the server and logoff

← Older revision		Revision as of 10:51, 6 September 2019
Line 30:		Line 30:
	</pre>		</pre>


			== Reload model ==
			The following script triggers a reload for a model. The script does not wait for the model to be loaded, so the result of the reloading is not available.

			<pre>
			DECLARE @paWSUrl NVARCHAR(MAX);
			DECLARE @modelId NVARCHAR(MAX);
			DECLARE @username NVARCHAR(MAX);
			DECLARE @password NVARCHAR(MAX);
			SET @paWSUrl = 'http://localhost/QPRPA/';
			SET @modelId = '12345';
			SET @username = 'qpr';
			SET @password = 'demo';

			SELECT @paWSUrl AS paWSUrl, @modelId AS modelId, @username AS username, @password AS password INTO #loginData;

			-- Authenticate
			(SELECT 'Method', 'POST') UNION ALL
			(SELECT 'Address', @paWSUrl + '/MainService.svc/webHttp/Authenticate') UNION ALL
			(SELECT 'Body', '{"logOnName":"' + @username + '","password":"' + @password + '","parameters":[]}') UNION ALL
			(SELECT 'ContentType', 'application/json') UNION ALL
			(SELECT 'Accept', 'application/json')
			--#CallWebService
			PRINT 'Authentication result: ' + COALESCE(@_ResponseText, '<none>') + ' StatusCode: ' + CAST(@_ResponseStatusCode AS NVARCHAR(MAX)) + ' Success: ' + CAST(@_ResponseSuccess AS NVARCHAR(MAX));

			DECLARE @sessionId NVARCHAR(MAX);
			DECLARE @pos INT;

			-- Extract session id
			SET @pos = PATINDEX('%"SessionId","Value":"%', @_ResponseText);
			PRINT @pos;
			IF @pos > 0
			BEGIN
			SET @sessionId = SUBSTRING(@_ResponseText, @pos + 21, LEN(@_ResponseText))
			SET @pos = PATINDEX('%"%',@sessionId);
			IF @pos > 0
			BEGIN
			SET @sessionId = SUBSTRING(@sessionId, 0, @pos);
			PRINT 'Session id: ' + @sessionId;
			END;
			END;

			SELECT @sessionId AS sessionId INTO #SessionData;

			DECLARE @paWSUrl NVARCHAR(MAX);
			DECLARE @modelId NVARCHAR(MAX);
			SELECT @paWSUrl = paWSUrl FROM #loginData;
			SELECT @modelId = modelId FROM #loginData;

			(SELECT 'Method', 'POST') UNION ALL
			(SELECT 'Address', @paWSUrl + '/MainService.svc/webHttp/ResetModelCache') UNION ALL
			(SELECT 'Body', '{"sessionId": "' + @sessionId + '","modelId":"' + @modelId + '","parameters": [{"Key":"ReloadModel","Value":"1"}]}') UNION ALL
			(SELECT 'ContentType', 'application/json') UNION ALL
			(SELECT 'Accept', 'application/json')
			--#CallWebService
			PRINT 'QueryObjectProperties result: ' + COALESCE(@_ResponseText, '<none>') + ' StatusCode: ' + CAST(@_ResponseStatusCode AS NVARCHAR(MAX)) + ' Success: ' + CAST(@_ResponseSuccess AS NVARCHAR(MAX));

			DECLARE @sessionId NVARCHAR(MAX);
			DECLARE @paWSUrl NVARCHAR(MAX);
			SELECT @sessionId = sessionId FROM #SessionData;
			SELECT @paWSUrl = paWSUrl FROM #loginData;

			-- LogOff
			(SELECT 'Method', 'POST') UNION ALL
			(SELECT 'Address', @paWSUrl + '/MainService.svc/webHttp/LogOff') UNION ALL
			(SELECT 'Body', '{"sessionId": "' + @sessionId + '"}') UNION ALL
			(SELECT 'ContentType', 'application/json') UNION ALL
			(SELECT 'ExecuteInClientSide', '1') UNION ALL
			(SELECT 'Accept', 'application/json')
			--#CallWebService
			PRINT 'LogOff result: ' + COALESCE(@_ResponseText, '<none>') + ' StatusCode: ' + CAST(@_ResponseStatusCode AS NVARCHAR(MAX)) + ' Success: ' + CAST(@_ResponseSuccess AS NVARCHAR(MAX));

			</pre>

	== A ProcessAnalyzer script example to authenticate user, make a simple query into the server and logoff ==		== A ProcessAnalyzer script example to authenticate user, make a simple query into the server and logoff ==

MarHink at 08:21, 21 May 2018

2018-05-21T08:21:37Z

@@ Line 28: / Line 28: @@
 -09-14T13:59:49.7230130+03:00 	Notification 	85 	<!doctype html><html itemscope="" itemtype="http:/
 </nowiki>
 </pre>
 [[Category:Examples]]