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>old>zn>Visible Inventories (LME)>
Visible Inventories (LME)
DailyDATAAPI
Service
Data & API
Starting Date
Jan 31, 2011
Catagory
old > zn
URL
https://dataapi.smm.cn/GetDataEn/zn_refined_inventory_lme
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
      • [] 76 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "Total"
          • "mt"
          • ""
        • {} 3 keys
          • "Changes"
          • "mt"
          • ""
        • {} 3 keys
          • "Asia Total"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor"
          • "mt"
          • ""
        • {} 3 keys
          • "Dubai"
          • "mt"
          • ""
        • {} 3 keys
          • "Malaysia (Port Kelang)"
          • "mt"
          • ""
        • {} 3 keys
          • "Europe Total"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao"
          • "mt"
          • ""
        • {} 3 keys
          • "Diliaste"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam"
          • "mt"
          • ""
        • {} 3 keys
          • "Hull"
          • "mt"
          • ""
        • {} 3 keys
          • "Flissingen"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp"
          • "mt"
          • ""
        • {} 3 keys
          • "Liverpool"
          • "mt"
          • ""
        • {} 3 keys
          • "Genoa"
          • "mt"
          • ""
        • {} 3 keys
          • "Americas Total"
          • "mt"
          • ""
        • {} 3 keys
          • "New Orleans"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore"
          • "mt"
          • ""
        • {} 3 keys
          • "St. Louis"
          • "mt"
          • ""
        • {} 3 keys
          • "Chicago"
          • "mt"
          • ""
        • {} 3 keys
          • "Detroit"
          • "mt"
          • ""
        • {} 3 keys
          • "Long Beach"
          • "mt"
          • ""
        • {} 3 keys
          • "Los Angeles"
          • "mt"
          • ""
        • {} 3 keys
          • "Toledo"
          • "mt"
          • ""
        • {} 3 keys
          • "Asia | Kaohsiung"
          • "mt"
          • ""
        • {} 3 keys
          • "Moerdijk"
          • "吨"
          • ""
        • {} 3 keys
          • "Warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Dubai / Warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Dubai / Cancelled warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Johor / Warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Johor / Cancelled warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Singapore / Warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Singapore / Cancelled warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Liverpool / Warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Liverpool / Cancelled warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Diliaste / Warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Diliaste / Cancelled warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Flissingen / Warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Flissingen / Cancelled warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Rotterdam / Warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Rotterdam / Cancelled warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Bilbao / Warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Bilbao / Cancelled warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Genoa / Warehouse warrants"
          • "吨"
          • ""
        • 46 ... 71
        • {} 3 keys
          • "Moerdijk / Cancelled warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Hamburg"
          • "吨"
          • ""
        • {} 3 keys
          • "Hamburg / Warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Hamburg / Cancelled warrant"
          • "吨"
          • ""
      • [] 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
Asia Totalintegermt
Singaporeintegermt
Johorintegermt
Dubaiintegermt
Malaysia (Port Kelang)integermt
Europe Totalintegermt
Bilbaointegermt
Diliasteintegermt
Rotterdamintegermt
Hullintegermt
Flissingenintegermt
Antwerpintegermt
Liverpoolintegermt
Genoaintegermt
Americas Totalintegermt
New Orleansintegermt
Baltimoreintegermt
St. Louisintegermt
Chicagointegermt
Detroitintegermt
Long Beachintegermt
Los Angelesintegermt
Toledointegermt
Asia | Kaohsiungintegermt
Moerdijkinteger
Warehouse warrantsinteger
Dubai / Warehouse warrantsinteger
Dubai / Cancelled warrantsinteger
Johor / Warehouse warrantsinteger
Johor / Cancelled warrantsinteger
Singapore / Warehouse warrantsinteger
Singapore / Cancelled warrantsinteger
Liverpool / Warehouse warrantsinteger
Liverpool / Cancelled warrantsinteger
Diliaste / Warehouse warrantsinteger
Diliaste / Cancelled warrantsinteger
Flissingen / Warehouse warrantsinteger
Flissingen / Cancelled warrantsinteger
Rotterdam / Warehouse warrantsinteger
Rotterdam / Cancelled warrantsinteger
Bilbao / Warehouse warrantsinteger
Bilbao / Cancelled warrantsinteger
Genoa / Warehouse warrantsinteger
Genoa / Cancelled warrantsinteger
Antwerp / Warehouse warrantsinteger
Antwerp / Cancelled warrantsinteger
New Orleans / Warehouse warrantsinteger
New Orleans / Cancelled warrantsinteger
Long Beach / Warehouse warrantsinteger
Long Beach / Cancelled warrantsinteger
Los Angeles / Warehouse warrantsinteger
Los Angeles / Cancelled warrantsinteger
Chicago / Warehouse warrantsinteger
Chicago / Cancelled warrantsinteger
Detroit / Warehouse warrantsinteger
Detroit / Cancelled warrantsinteger
St. Louis / Warehouse warrantsinteger
St. Louis / Cancelled warrantsinteger
Baltimore / Warehouse warrantsinteger
Baltimore / Cancelled warrantsinteger
Hull / Warehouse warrantsinteger
Hull / Cancelled warrantsinteger
Malaysia (Port Kelang) / Warehouse warrantsinteger
Malaysia (Port Kelang) / Cancelled warrantsinteger
Toledo / Warehouse warrantsinteger
Toledo / Cancelled warrantsinteger
Asia | Kaohsiung / Warehouse warrantsinteger
Asia | Kaohsiung / Cancelled warrantsinteger
Moerdijk / Warehouse warrantsinteger
Moerdijk / Cancelled warrantsinteger
Hamburginteger
Hamburg / Warehouse warrantsinteger
Hamburg / Cancelled warrantinteger
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
Visible Inventories (LME)
DailyDATAAPI
Catagory
old > zn
Service
Data & API
Starting Date
Jan 31, 2011