Development Guide

How to Use Open API

1. Choose the Open API to use

Check the service information in the [Open API List] menu.

2. Download the Spec

[Download Spec] includes instructions for using the Open API.

3. Issue API Key

The Open API provided by ZANSIS is a RESTful web service. RESTful web services use an HTTP-based interface and operate through GET or POST URIs, so parameter values are included in the URL when loading the page.
You must log in to obtain an API key.

4. Register URL

① Open API URL The Open API URL of OCGS is http://zansis.ocgs.go.tz/uportal/openapi/
② Open API Name The Open API services of ZANSIS have unique names. The request URL is listed in the downloaded specification.
③ Default Parameters If default parameters are omitted, the results will be displayed using the default values in the specification.
The API key (KEY) must be added after it has been issued.
If there is no API key, the default value will be treated as "sample" and only 5 records will be returned, so an API key must be entered.
The request document (Type) specifies the output format such as XML or JSON. The default value is XML.
Data Count (pSize) refers to the number of records returned by the API query.
④ Request Parameters These are parameter values specifically defined for each ZANSIS service. These request parameters are only available for services that provide them.

5. Request Open API from Application

You can now develop a new application using the Open API. The requested data will be displayed within your application.

Sample Source Code

<script src="https://code.jquery.com/jquery-1.12.4.min.js" integrity="sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ=" crossorigin="anonymous"></script>
<script type="text/javascript" src="https://code.highcharts.com/highcharts.js" /></script>
<script type="text/javascript" src="https://code.highcharts.com/modules/exporting.js" /></script>
<script type="text/javascript">
	$.ajaxPrefilter('json', function(options, orig, jqXHR){
		return 'jsonp';
	});
	$.ajax({
		url         : 'http://zansis.ocgs.go.tz/uportal/openapi/SttsApiTblData.do?STATBL_ID=TABLE-C_2_2&DTACYCLE_CD=YY&WRTTIME_IDTFR_ID=2024&Type=json',
		type        : 'GET',
		dataType    : 'json',
		success     : function (result) {
			drawBarChart(result);
			drawPieChart(result);
			drawGrid(result);
			
		},
		error       : function (result) {
		}
	});

	function drawBarChart(jsonData) {
		var rows = jsonData.SttsApiTblData[1].row;
		if(rows) {
			var representativeRow = rows[0], 
				statNm = representativeRow.STATBL_ID, 
				itemNm1 = representativeRow.CLS_NM, 
				uiNm = representativeRow.UI_NM;
	
			var dataArray = [];
			$.each(rows, function(idx, row) {
				var tmp = [];
				tmp.push(row.WRTTIME_IDTFR_ID);
				tmp.push(Number(row.DTA_VAL));
				dataArray.push(tmp);
			});
	
			$('#barChart').highcharts({
				chart: {
					type: 'column'
				},
		        credits: {
		            enabled: false
		        },
				title: {
					text: ''
				},
				xAxis: {
					type: 'category',
					labels: {
						style: {
							fontSize: '13px',
							fontFamily: 'Verdana, sans-serif'
						}
					}
				},
				yAxis: {
					min: 0,
					title: {
						text: uiNm
					},
					 labels: {
					    	formatter: function(){
					    		return commaWon(this.value);
					    	}
							/* style: { color: Highcharts.getOptions().colors[0] } */
					    }
				},
				tooltip: {
					pointFormat: '{point.y}'+uiNm
				},
				series: [{
					name: itemNm1,
					data: dataArray
				}]
			});
		}
	}
</script>

<div id="barChart" style="min-width:300px;height:400px;margin:0 auto;"></div>

<script src="https://code.jquery.com/jquery-1.12.4.min.js" integrity="sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ=" crossorigin="anonymous"></script>
<script type="text/javascript" src="https://code.highcharts.com/highcharts.js" /></script>
<script type="text/javascript" src="https://code.highcharts.com/modules/exporting.js" /></script>
<script type="text/javascript">
	$.ajaxPrefilter('json', function(options, orig, jqXHR){
		return 'jsonp';
	});
	$.ajax({
		url         : 'http://zansis.ocgs.go.tz/uportal/openapi/SttsApiTblData.do?STATBL_ID=TABLE-C_2_2&DTACYCLE_CD=YY&WRTTIME_IDTFR_ID=2024&Type=json',
		type        : 'GET',
		dataType    : 'json',
		success     : function (result) {
			drawBarChart(result);
			drawPieChart(result);
			drawGrid(result);
			
		},
		error       : function (result) {
		}
	});

	function drawPieChart(jsonData) {
		var rows = jsonData.SttsApiTblData[1].row;
		if(rows) {
			var representativeRow = rows[0], statNm = representativeRow.STATBL_ID, 
				itemNm1 = representativeRow.CLS_NM, 
				uiNm = representativeRow.UI_NM;
				
			var dataArray = [];
			$.each(rows, function(idx, row) {
				var tmp = [];
				tmp.push(row.WRTTIME_IDTFR_ID);
				tmp.push(Number(row.DTA_VAL));
				dataArray.push(tmp);
			});
	
			$('#pieChart').highcharts({
		        credits: {
		            enabled: false
		        },
				chart: {
	                plotBackgroundColor: null,
	                plotBorderWidth: null,
	                plotShadow: false,
	                type: 'pie'
	            },
	            title: {
	                text: ''
	            },
	            tooltip: {
	                pointFormat: '{point.percentage:.1f}%'
	            },
	            plotOptions: {
	                pie: {
	                    allowPointSelect: true,
	                    cursor: 'pointer',
	                    dataLabels: {
	                        enabled: false
	                    },
	                    showInLegend: true
	                }
	            },
	            series: [{
	                colorByPoint: true,
	                data: dataArray
	            }]
			});
		}
}
</script>

<div id="pieChart" style="min-width:300px;height:400px;margin:0 auto;"></div>

Text
District	Person

<script src="https://code.jquery.com/jquery-1.12.4.min.js" integrity="sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ=" crossorigin="anonymous"></script>
<script type="text/javascript">
	$.ajaxPrefilter('json', function(options, orig, jqXHR){
		return 'jsonp';
	});
	$.ajax({
		url         : 'http://zansis.ocgs.go.tz/uportal/openapi/SttsApiTblData.do?STATBL_ID=TABLE-C_2_2&DTACYCLE_CD=YY&WRTTIME_IDTFR_ID=2024&Type=json',
		type        : 'GET',
		dataType    : 'json',
		success     : function (result) {
			drawBarChart(result);
			drawPieChart(result);
			drawGrid(result);
			
		},
		error       : function (result) {
		}
	});

	function drawGrid(jsonData) {
		var rows = jsonData.ArcData.row;
		if(rows) {
			var html = '';
			$.each(rows, function(idx, row) {
				html += '<tr>';
				html += '	<td style="border: 2px solid gray; text-align: center;">' + row.ITEM_NAME2 + '</td>';
				html += '	<td style="border: 2px solid gray; text-align: center;">' + row.DATA_VALUE + '</td>';
				html += '</tr>';
			});
			$('#grid').append(html);
		}
	}
</script>

<table style="border: 2px solid gray; width: 700px; text-align: center;">
	<colgroup>
		<col width="50%">
		<col width="">
	</colgroup>
	<thead>
		<tr>
			<th style="border: 2px solid gray; text-align: center;">District</th>
			<th style="border: 2px solid gray; text-align: center;">Person</th>
		</tr>
	</thead>
	<tbody id="grid">
	</tbody>
</table>

Guide by Java Program

1. Environment

Eclipse IDE for Enterprise Java and Web Developers ▶ Version: 2025-09 (4.37.0)
Apache Tomcat 9.0.105
Java : JDK 1.8

2. Eclipse Installation

Access the official Eclipse website and download the program.
Download URL: https://www.eclipse.org/downloads/packages/
Download [Eclipse IDE for Enterprise Java and Web Developers] and extract it.
Run the Eclipse program.
Before running Eclipse, make sure to install Java and Apache Tomcat.

3. Create a Project

After launching Eclipse, select [Create a Dynamic Web Project].
Enter the Project name and set the Dynamic Web Module version to 4.0.
Click the Finish button.

4. Create and Code a JSP File

Right-click the webapp folder of the created project and select JSP File.
Enter the File name and click the Finish button.
The file sample.jsp has been created in the webapp folder.
Code the sample.jsp file as follows.

After launching Eclipse, select [Create a Dynamic Web Project].

source code

   <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
	   <%@ page import="java.io.*" %>
	   <%@ page import="java.net.*" %>
	   <%@ page import="javax.xml.*" %>
	   <%@ page import="javax.xml.parsers.*" %>
	   <%@ page import="org.w3c.dom.*" %>
	   <%
	   	URL url = null;
	   	URLConnection urlConnection = null;
	   	
	   	String stringUrl = "http://zansis.ocgs.go.tz/uportal/openapi/SttsApiTblData.do?STATBL_ID=TABLE-C_2_2&DTACYCLE_CD=YY&WRTTIME_IDTFR_ID=2024&Type=json";
	   	InputStream is = null;
	   	String data = "";
	   	
	   	try {
	   		
	   		url = new URL(stringUrl);
	   		urlConnection = url.openConnection();
	   		urlConnection.setDoOutput(true);
	   		
	   		is = urlConnection.getInputStream();
	   		 
	   	 	byte[] buf = new byte[2048];
	   	 	int len = -1;
	   	 	StringBuffer sb = new StringBuffer();
	   	 	
	   	 	while ((len = is.read(buf, 0, buf.length)) != -1) {
	   	 		sb.append(new String(buf, 0, len));
	   	 	}
	   		
	   	 	data = sb.toString();
	   	 	
	   	} catch (MalformedURLException e) {
	   		e.getMessage();
	   	} catch (IOException e) {
	   		e.getMessage();
	   	} finally {
	   		if (is != null) {
	   			is.close();
	   		}
	   	}
	   %>
	   <!DOCTYPE html>
	   <html>
	   <head>
	   	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	   	<title>Insert title here</title>
	   </head>
	   <body>
	   	java sample page
	   	<%=data%>;
	   </body>
	   </html>

5. Server Setup and Project Configuration

Select File > New > Other to create a server.
Select Server and proceed to the next step.
Select Apache > Tomcat v9.0 Server and proceed to the next step.
Choose the Tomcat installation directory and set the JRE.
Click the Next button.
Select the project in the Available area and click the Add button to move it to the Configured area.
Click the Finish button.
A new server has been created in the Servers tab at the bottom of the screen. Double-click it to move to the Modules tab.
Select JavaApiSample in Web Modules and click the Edit button.
Enter [/] in the Path field and click the OK button.
Right-click the project and select Properties.
In the Properties window, select Targeted Runtimes.
Check Apache Tomcat v9.0 on the right side and click Apply and Close.

6. Run and Verify the Server

In the Servers tab at the bottom of the screen, right-click Tomcat v9.0 Server and select Start.
In the web browser address bar, enter http://localhost:8080/sample.jsp and check the result.

Full menu

Statistical Database

Thematic Statistics

Open API

Bulletin Board

Introduction

Statistical Database

Thematic Statistics

Open API

Bulletin Board

Introduction