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

LME inventory
DailyDATAAPI
Service
Data & API
Starting Date
Feb 01, 2011
Catagory
Zinc > Refined Zinc > Inventory
URL
https://dataapi.smm.cn/GetDataEn/zn_lme_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
      • [] 74 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "Total"
          • "mt"
          • ""
        • {} 3 keys
          • "Changes"
          • "mt"
          • ""
        • {} 3 keys
          • "Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Asia Total"
          • "mt"
          • ""
        • {} 3 keys
          • "Europe Total"
          • "mt"
          • ""
        • {} 3 keys
          • "Americas Total"
          • "mt"
          • ""
        • {} 3 keys
          • "Dubai"
          • "mt"
          • ""
        • {} 3 keys
          • "Dubai / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Dubai / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Liverpool"
          • "mt"
          • ""
        • {} 3 keys
          • "Liverpool / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Liverpool / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Diliaste"
          • "mt"
          • ""
        • {} 3 keys
          • "Diliaste / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Diliaste / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Flissingen"
          • "mt"
          • ""
        • {} 3 keys
          • "Flissingen / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Flissingen / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Genoa"
          • "mt"
          • ""
        • {} 3 keys
          • "Genoa / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Genoa / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "New Orleans"
          • "mt"
          • ""
        • {} 3 keys
          • "New Orleans / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "New Orleans / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Long Beach"
          • "mt"
          • ""
        • {} 3 keys
          • "Long Beach / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Long Beach / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Los Angeles"
          • "mt"
          • ""
        • {} 3 keys
          • "Los Angeles / Warehouse warrants"
          • "mt"
          • ""
        • 46 ... 69
        • {} 3 keys
          • "Asia | Kaohsiung / Cancelled warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Moerdijk"
          • "mt"
          • ""
        • {} 3 keys
          • "Moerdijk / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Moerdijk / Cancelled warrants"
          • "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
Totalintegermt
Changesintegermt
Warehouse warrantsintegermt
Cancelled warrantsintegermt
Asia Totalintegermt
Europe Totalintegermt
Americas Totalintegermt
Dubaiintegermt
Dubai / Warehouse warrantsintegermt
Dubai / Cancelled warrantsintegermt
Johorintegermt
Johor / Warehouse warrantsintegermt
Johor / Cancelled warrantsintegermt
Singaporeintegermt
Singapore / Warehouse warrantsintegermt
Singapore / Cancelled warrantsintegermt
Liverpoolintegermt
Liverpool / Warehouse warrantsintegermt
Liverpool / Cancelled warrantsintegermt
Diliasteintegermt
Diliaste / Warehouse warrantsintegermt
Diliaste / Cancelled warrantsintegermt
Flissingenintegermt
Flissingen / Warehouse warrantsintegermt
Flissingen / Cancelled warrantsintegermt
Rotterdamintegermt
Rotterdam / Warehouse warrantsintegermt
Rotterdam / Cancelled warrantsintegermt
Bilbaointegermt
Bilbao / Warehouse warrantsintegermt
Bilbao / Cancelled warrantsintegermt
Genoaintegermt
Genoa / Warehouse warrantsintegermt
Genoa / Cancelled warrantsintegermt
Antwerpintegermt
Antwerp / Warehouse warrantsintegermt
Antwerp / Cancelled warrantsintegermt
New Orleansintegermt
New Orleans / Warehouse warrantsintegermt
New Orleans / Cancelled warrantsintegermt
Long Beachintegermt
Long Beach / Warehouse warrantsintegermt
Long Beach / Cancelled warrantsintegermt
Los Angelesintegermt
Los Angeles / Warehouse warrantsintegermt
Los Angeles / Cancelled warrantsintegermt
Chicagointegermt
Chicago / Warehouse warrantsintegermt
Chicago / Cancelled warrantsintegermt
Detroitintegermt
Detroit / Warehouse warrantsintegermt
Detroit / Cancelled warrantsintegermt
St. Louisintegermt
St. Louis / Warehouse warrantsintegermt
St. Louis / Cancelled warrantsintegermt
Baltimoreintegermt
Baltimore / Warehouse warrantsintegermt
Baltimore / Cancelled warrantsintegermt
Hullintegermt
Hull / Warehouse warrantsintegermt
Hull / Cancelled warrantsintegermt
Malaysia (Port Kelang)integermt
Malaysia (Port Kelang) / Warehouse warrantsintegermt
Malaysia (Port Kelang) / Cancelled warrantsintegermt
Toledointegermt
Toledo / Warehouse warrantsintegermt
Toledo / Cancelled warrantsintegermt
Asia | Kaohsiungintegermt
Asia | Kaohsiung / Warehouse warrantsintegermt
Asia | Kaohsiung / Cancelled warrantsintegermt
Moerdijkintegermt
Moerdijk / Warehouse warrantsintegermt
Moerdijk / Cancelled warrantsintegermt
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
LME inventory
DailyDATAAPI
Catagory
Zinc > Refined Zinc > Inventory
Service
Data & API
Starting Date
Feb 01, 2011