Download

Access resource data via a web API with powerful query support. Further information in the main CKAN Data API and DataStore documentation.

Endpoints »

The Data API can be accessed via the following actions of the CKAN action API.

Create	`https://www.data.gov.my/data/api/3/action/datastore_create`
Update / Insert	`https://www.data.gov.my/data/api/3/action/datastore_upsert`
Query	`https://www.data.gov.my/data/api/3/action/datastore_search`
Query (via SQL)	`https://www.data.gov.my/data/api/3/action/datastore_search_sql`

Querying »

Query example (first 5 results)

https://www.data.gov.my/data/api/3/action/datastore_search?limit=5&resource_id=2903e39a-dde6-4053-818e-ebdb8066d8b7

Query example (results containing 'jones')

https://www.data.gov.my/data/api/3/action/datastore_search?q=jones&resource_id=2903e39a-dde6-4053-818e-ebdb8066d8b7

Query example (via SQL statement)

https://www.data.gov.my/data/api/3/action/datastore_search_sql?sql=SELECT * from "2903e39a-dde6-4053-818e-ebdb8066d8b7" WHERE title LIKE 'jones'

Example: Javascript »

A simple ajax (JSONP) request to the data API using jQuery.

        var data = {
          resource_id: '2903e39a-dde6-4053-818e-ebdb8066d8b7', // the resource id
          limit: 5, // get 5 results
          q: 'jones' // query for 'jones'
        };
        $.ajax({
          url: 'https://www.data.gov.my/data/api/3/action/datastore_search',
          data: data,
          dataType: 'jsonp',
          success: function(data) {
            alert('Total results found: ' + data.result.total)
          }
        });

Example: Python »

      import urllib
      url = 
'https://www.data.gov.my/data/api/3/action/datastore_search?limit=5&resource_id=2903e39a-dde6-4053-818e-ebdb8066d8b7&q=title:jones'
      fileobj = urllib.urlopen(url)
      print fileobj.read()

dataset

URL: https://archive.data.gov.my/data/dataset/2468f9f3-cb2a-4937-877f-9f50842f43a6/resource/cbf166a0-b111-4d4c-875e-dc44927cce43/download/m-20210315105103_202210311241100_principal-statistics-of-retail-trade-2000-2021-malaysia-annuall.csv

This data set shows the Principal statistics of retail trade, 2000 - 2021, Malaysia (Annual)

Footnote: Data for 2005 to 2010 has been revised basing on the Census of Distributive Trade 2009

Source: Department of Statistics, Malaysia

Fullscreen Embed

This resource view is not available at the moment. Click here for more information.

Download resource

Data Dictionary

Column	Type	Label	Description
Year	text
Value of sales RM Million	text
Number of persons engaged	text
Salaries & Wages RM Million	text

Additional Information

Field	Value
Data last updated	October 31, 2022
Metadata last updated	October 31, 2022
Created	October 31, 2022
File Format	CSV
License	Creative Commons Attribution

CKAN Data API

dataset

Embed resource view

Data Dictionary

Additional Information