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

SHFE inventory
WeeklyDATAAPI
Service
Data & API
Starting Date
May 23, 2014
Catagory
Zinc > Refined Zinc > Inventory
URL
https://dataapi.smm.cn/GetDataEn/zn_shfe_inventory
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
      • [] 25 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "Total inventory this week"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory this week"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory change"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory change"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory this week in Shanghai"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory this week in Shanghai"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory change in Shanghai"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory change in Shanghai"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory this week in Guangdong"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory this week in Guangdong"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory change in Guangdong"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory change in Guangdong"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory this week in Jiangsu"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory this week in Jiangsu"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory change in Jiangsu"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory change in Jiangsu"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory this week in Zhejiang"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory this week in Zhejiang"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory change in Zhejiang"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory change in Zhejiang"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory this week in Tianjin"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory this week in Tianjin"
          • "mt"
          • ""
        • {} 3 keys
          • "Total inventory change in Tianjin"
          • "mt"
          • ""
        • {} 3 keys
          • "Futures inventory change in Tianjin"
          • "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
Total inventory this weekfloatmt
Futures inventory this weekfloatmt
Total inventory changefloatmt
Futures inventory changefloatmt
Total inventory this week in Shanghaifloatmt
Futures inventory this week in Shanghaifloatmt
Total inventory change in Shanghaifloatmt
Futures inventory change in Shanghaifloatmt
Total inventory this week in Guangdongfloatmt
Futures inventory this week in Guangdongfloatmt
Total inventory change in Guangdongfloatmt
Futures inventory change in Guangdongfloatmt
Total inventory this week in Jiangsufloatmt
Futures inventory this week in Jiangsufloatmt
Total inventory change in Jiangsufloatmt
Futures inventory change in Jiangsufloatmt
Total inventory this week in Zhejiangfloatmt
Futures inventory this week in Zhejiangfloatmt
Total inventory change in Zhejiangfloatmt
Futures inventory change in Zhejiangfloatmt
Total inventory this week in Tianjinfloatmt
Futures inventory this week in Tianjinfloatmt
Total inventory change in Tianjinfloatmt
Futures inventory change in Tianjinfloatmt
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
SHFE inventory
WeeklyDATAAPI
Catagory
Zinc > Refined Zinc > Inventory
Service
Data & API
Starting Date
May 23, 2014