SMM DatabaseMy Data & API
Contact Us
SMM Data Excel Plug-in

Updata SMM data in Excel by downloading SMM Data Excel Plug-in

OS: Win 7/8/9/10

Excel: Ver.07 and above

DOWNLOAD

Home>Database>Nickel>Nickel Ore>Balance>Ore Balance in China>
Ore Balance in China
QuarterlyDATAAPI
Service
Data & API
Starting Date
Jan 01, 2017
Catagory
Nickel > Nickel Ore > Balance
URL
https://dataapi.smm.cn/GetDataEn/ni_ore_balance_in_china
Supported Formats
JSON
HTTP Request Method
POST
Request Parameters
Names
Requires
Types of Range
Descriptions
tokenTrueStringThis parameter is required when using OAuth.You will get the access_token after oauth authorization.token
sdatetimeFalseStringStart Date,The default value is A Year ago, e.g.,2018-01-01
edatetimeFalseStringEnd Date,The default value is Today, e.g.,2018-08-13
Response
    • 200
    • "OK"
    • {} 3 keys
      • 0
      • [] 13 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "Supply-Imports from Indonesia-Physical volume"
          • "1,0000 wmt"
          • ""
        • {} 3 keys
          • "Supply-Imports from Indonesia-Metal volume"
          • "1,0000 mt"
          • ""
        • {} 3 keys
          • "Supply-Imports from the Philippines-Physical volume"
          • "1,0000 wmt"
          • ""
        • {} 3 keys
          • "Supply-Imports from the Philippines-Metal volume"
          • "1,0000 mt"
          • ""
        • {} 3 keys
          • "Supply-Imports from other countries-Physical volume"
          • "1,0000 wmt"
          • ""
        • {} 3 keys
          • "Supply-Imports from other countries-Metal volume"
          • "1,0000 mt"
          • ""
        • {} 3 keys
          • "Supply-Total imports-Physical volume"
          • "1,0000 wmt"
          • ""
        • {} 3 keys
          • "Supply-Total imports-Metal volume"
          • "1,0000 mt"
          • ""
        • {} 3 keys
          • "Demand-Downstream purchases and stockpiling-Physical volume "
          • "1,0000 wmt"
          • ""
        • {} 3 keys
          • "Demand-Downstream purchases and stockpiling-Metal volume"
          • "1,0000 mt"
          • ""
        • {} 3 keys
          • "Nickel ore supply and demand balance-quarter -Physical volume"
          • "1,0000 wmt"
          • ""
        • {} 3 keys
          • "Nickel ore supply and demand balance-quarter-Metal volume"
          • "1,0000 mt"
          • ""
      • [] 2 items
        • [] 4 items
          • "2016-05-27"
          • "97.5"
          • "9.8"
          • "……"
        • [] 4 items
          • "2016-05-27"
          • "97.5"
          • "9.8"
          • "……"
Returned Parameters Description
Type
Status
Descriptions
CodeRequest Status “200” means normal, other status codes are shown in schedule 1
MsgReturn Description“OK” indicates normal. Other states are shown in schedule 1
DataReturn ResultReturn the corresponding data according to the requested parameters
Data.StatusPermission Status“0” means no permission,” 1” means permission
Data.Field1D Structure ArrayReturn data header description
Data.Field.NameNameIndicates the name corresponding to the column data
Data.Field.UnitUnitThe unit corresponding to the column data
Data.Field.InfoDescriptionDescription of the column data
Content2D dataReturn all eligible data
Returned Field Description
Field Name
Fied Type
Unit
Descriptions
Datedatetime
Supply-Imports from Indonesia-Physical volumeinteger1,0000 wmt
Supply-Imports from Indonesia-Metal volumefloat1,0000 mt
Supply-Imports from the Philippines-Physical volumeinteger1,0000 wmt
Supply-Imports from the Philippines-Metal volumefloat1,0000 mt
Supply-Imports from other countries-Physical volumeinteger1,0000 wmt
Supply-Imports from other countries-Metal volumefloat1,0000 mt
Supply-Total imports-Physical volumeinteger1,0000 wmt
Supply-Total imports-Metal volumefloat1,0000 mt
Demand-Downstream purchases and stockpiling-Physical volume integer1,0000 wmt
Demand-Downstream purchases and stockpiling-Metal volumefloat1,0000 mt
Nickel ore supply and demand balance-quarter -Physical volumefloat1,0000 wmt
Nickel ore supply and demand balance-quarter-Metal volumefloat1,0000 mt
How to get token
URL
https://platform.smm.cn/usercenter/auth
HTTP Request Method
POST
Request Parameters
Requires
Types of Range
Descriptions
user_nameTrueStringEamil Address
passwordTrueStringMD5 password
sourceTrueStringSource,The default value is dataapi
Response
    • 0
    • ""
    • {} 1 key
      • "eyJhbGciOiJIUjZWxLCJjb21wYW55X3N0YXR1cyI6MCwiY3JlYXRlbWFpbCI6Inh1lIjmNCdWc…"
Notes

All interfaces require authorization, and each interface has a start date. A new authorization is required after expiration.

Phone:+86 - (021)5155 0306

Schedule 1
Status
Descriptions
200SUCCESS
400INVALID REQUEST
401NOT CERTIFIED
403REJECT A REQUEST
404PAGE LOSS
422UNPROCESSABLE ENTITY
500SERVER ERROR
Ore Balance in China
QuarterlyDATAAPI
Catagory
Nickel > Nickel Ore > Balance
Service
Data & API
Starting Date
Jan 01, 2017