DCS Web Service - Revision history

Catglobe at 02:17, 23 June 2010

2010-06-23T02:17:29Z

← Older revision		Revision as of 02:17, 23 June 2010
Line 1:		Line 1:
	== Introduction ==		== Introduction ==

	The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.		The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.
	'''Do not use this service, a new data cache exists, more information about the API is available here '''[[~~Data_cache_service~~\|'''Data_cache_service''']]'''.'''

			'''Do not use this service, a new data cache exists, more information about the API is available here '''[[Data cache service\|'''Data_cache_service''']]'''.'''

	==Features==		==Features==

Catglobe: Important that this service is not used anymore, reference to new service included.

2010-06-23T02:17:11Z

Important that this service is not used anymore, reference to new service included.

← Older revision		Revision as of 02:17, 23 June 2010
Line 1:		Line 1:
	==Introduction==		== Introduction ==
	The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.
			The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.
			'''Do not use this service, a new data cache exists, more information about the API is available here '''[[Data_cache_service\|'''Data_cache_service''']]'''.'''

	==Features==		==Features==
	There are currently 2 functions supported, their return values are tables in [http://json.org JSON]'s array format.		There are currently 2 functions supported, their return values are tables in [http://json.org JSON]'s array format.

Catglobe: /* Features */

2009-06-02T03:41:06Z

Features

← Older revision		Revision as of 03:41, 2 June 2009
Line 6:		Line 6:
	//get top N data ordered by a column descendingly (DESC) or ascendingly (ASC)		//get top N data ordered by a column descendingly (DESC) or ascendingly (ASC)
	public object GetTopDCSData(int dcsId, string[] columns, int topN, string orderByColumn, string orderType)		public object GetTopDCSData(int dcsId, string[] columns, int topN, string orderByColumn, string orderType)

	//get specific columns' data		//get specific columns' data
	public object GetDCSData(int dcsId, string[] columns)		public object GetDCSData(int dcsId, string[] columns)

Catglobe: /* Examples */

2009-06-02T02:52:00Z

Examples

← Older revision		Revision as of 02:52, 2 June 2009
Line 76:		Line 76:
	</source>		</source>

	==Examples==		== Examples ==
	[[Display a questionnaire's answers in real time]]
			[[Display a questionnaire's answers in real time]]

			[[Media:TestDCSWebService.zip\|Connect to web service from an external site]]

Catglobe: /* Features */

2009-06-02T02:35:58Z

Features

← Older revision		Revision as of 02:35, 2 June 2009
Line 4:		Line 4:
	There are currently 2 functions supported, their return values are tables in [http://json.org JSON]'s array format.		There are currently 2 functions supported, their return values are tables in [http://json.org JSON]'s array format.
	<source lang=csharp>		<source lang=csharp>
			//get top N data ordered by a column descendingly (DESC) or ascendingly (ASC)
	public object GetTopDCSData(int dcsId, string[] columns, int topN, string orderByColumn, string orderType)		public object GetTopDCSData(int dcsId, string[] columns, int topN, string orderByColumn, string orderType)
			//get specific columns' data
	public object GetDCSData(int dcsId, string[] columns)		public object GetDCSData(int dcsId, string[] columns)
	</source>		</source>

Catglobe: /* Features */

2009-06-02T02:34:35Z

Features

← Older revision		Revision as of 02:34, 2 June 2009
Line 2:		Line 2:
	The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.		The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.
	==Features==		==Features==
	There are currently 2 functions supported, their return values are tables in [~~JSON\|~~http://json.org]'s array format.		There are currently 2 functions supported, their return values are tables in [http://json.org JSON]'s array format.
	<source lang=csharp>		<source lang=csharp>
	public object GetTopDCSData(int dcsId, string[] columns, int topN, string orderByColumn, string orderType)		public object GetTopDCSData(int dcsId, string[] columns, int topN, string orderByColumn, string orderType)

Catglobe: /* Features */

2009-06-02T02:33:57Z

Features

← Older revision		Revision as of 02:33, 2 June 2009
Line 2:		Line 2:
	The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.		The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.
	==Features==		==Features==
	There are currently 2 functions supported:		There are currently 2 functions supported, their return values are tables in [JSON\|http://json.org]'s array format.
	<source lang=csharp>		<source lang=csharp>
	public object GetTopDCSData(int dcsId, string[] columns, int topN, string orderByColumn, string orderType)		public object GetTopDCSData(int dcsId, string[] columns, int topN, string orderByColumn, string orderType)
	public object GetDCSData(int dcsId, string[] columns)		public object GetDCSData(int dcsId, string[] columns)
	</source>		</source>

	== How to use ==		== How to use ==

Catglobe at 02:31, 2 June 2009

2009-06-02T02:31:57Z

← Older revision		Revision as of 02:31, 2 June 2009
Line 1:		Line 1:
	==Introduction==		==Introduction==
	The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.		The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.
			==Features==
			There are currently 2 functions supported:
			<source lang=csharp>
			public object GetTopDCSData(int dcsId, string[] columns, int topN, string orderByColumn, string orderType)
			public object GetDCSData(int dcsId, string[] columns)
			</source>
	== How to use ==		== How to use ==

Catglobe: /* How to use */

2009-06-02T02:24:04Z

How to use

← Older revision		Revision as of 02:24, 2 June 2009
Line 8:		Line 8:

	<source lang="javascript">		<source lang="javascript">
	var dcsId = 4246;		//-------CONFIGURATION--------------------
	var columns = "'UserId','FirstName','DisabledDate','DeletedDate','Amt','Kommune_gammel','Region~~','Kommune~~','Postnummer','Boligtype'";		var dcsId = 4246;//Primary key of the DCS
			var columns = "'UserId', 'FirstName', 'DisabledDate', 'DeletedDate', 'Amt', 'Kommune_gammel', 'Region', 'Postnummer', 'Boligtype'";//selected columns

	var username = "maimai";//your username to login to Catglobe system		var username = "maimai";//your username to login to Catglobe system
	var password = "cg";//your password		var password = "cg";//your password
	var rootUrl = 'http://localhost/supernova';//replace this with your site, ex: http://mycatinet.catglobe.com		var rootUrl = 'http://localhost/supernova';//replace this with your site, ex: http://mycatinet.catglobe.com
			//--------------------------------------------------

	var webMethod = rootUrl + '/DataModule/DataCache/WebService/DCSWebService.asmx/GetDCSData';		var webMethod = rootUrl + '/DataModule/DataCache/WebService/DCSWebService.asmx/GetDCSData';
	var loginPage = rootUrl + '/Login.aspx?u=~~maimai~~&p=cg';//		var loginPage = rootUrl + '/Login.aspx?u='+username+'&p='+password;
	var parameters = "{'dcsId':" + dcsId + ",'columns':[" + columns + "]}";//JSON format		var parameters = "{'dcsId':" + dcsId + ",'columns':[" + columns + "]}";//JSON format

Catglobe at 02:20, 2 June 2009

2009-06-02T02:20:52Z

@@ Line 1: / Line 1: @@
 ==Introduction==
 The original reason for creating DCS web service was to retrieve data answered in a questionnaire and display them on a Portal element.
-==How to use ==
+== How to use  ==
-The condition xml should follow the format of:
+The simplest way is to use [http://docs.jquery.com/Ajax/jQuery.ajax#options ajax request using jquery].
-<source lang="xml" line="0">
-<criteria dcs-id="1" top-N="1000" order-by-column="StartDate" order-type="desc">
+If the request is not made from an internal page inside Catglobe system, we need to make a dummy login first, then make the call to the web service.
-<column name="StartDate"></column>
-<column name="Q25"></column>
+<source lang="javascript">
-<column name="BankName"></column>
+var dcsId = 4246;
-</criteria>
+var columns = "'UserId','FirstName','DisabledDate','DeletedDate','Amt','Kommune_gammel','Region','Kommune','Postnummer','Boligtype'";
 </source>