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()

1947 2004 Balance Of Payments Net Annually

URL: https://archive.data.gov.my/data/dataset/81806aac-b98b-442e-a597-0168a7e07ef8/resource/d625b291-718f-48cc-9e1d-201df8f4b3db/download/m-20210309103216_202309070338440_1947-2004-balance-of-payments-net-annually.csv

This data set shows the Balance Of Payments (Net), 1947 - 2023 (Annually)

Footnote: Value Errors and Omissions (Net) for year 1949 - 1953 includes private capital inflow Value Net Change in Bank Negara Malaysia's External Reserves for year 1949 - 1953 includes Inflow of Sterling balances Balance on Current Account 1947-1998 = Goods f.o.b. (Net) + Services (Net) + Unrequited Transfers (Net) Balance on Current Account 1999-2004 = Goods f.o.b. (Net) + Services (Net) + Income (Net) + Current Transfers (Net) Basic Balance = Balance on Current Account + Capital (Net) Balance on Capital and Financial Account = Capital Account (Net) + Financial Account Value for year 2021 are Final
Value for year 2022 are Revised Value for year 2023 are Preliminary for period of January - June 2023

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
Category	text
Item	text
Year	text
Value in RM Million	text

Additional Information

Field	Value
Data last updated	September 11, 2023
Metadata last updated	September 11, 2023
Created	September 11, 2023
File Format	CSV
License	Creative Commons Attribution

CKAN Data API

1947 2004 Balance Of Payments Net Annually

Embed resource view

Data Dictionary

Additional Information