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>Tin>Refined Tin>Inventory>Visible inventory (LME)>
Visible inventory (LME)
DailyDATAAPI
Service
Data & API
Starting Date
Feb 01, 2011
Catagory
Tin > Refined Tin > Inventory
URL
https://dataapi.smm.cn/GetDataEn/tin_visible_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
      • [] 44 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "LME total inventory"
          • "mt"
          • ""
        • {} 3 keys
          • "Up/down"
          • "mt"
          • ""
        • {} 3 keys
          • "Total warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Total cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Asia丨Total"
          • "mt"
          • ""
        • {} 3 keys
          • "Europe丨Total"
          • "mt"
          • ""
        • {} 3 keys
          • "America丨Total"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Busan"
          • "mt"
          • ""
        • {} 3 keys
          • "Busan丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Busan丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Kwangyang"
          • "mt"
          • ""
        • {} 3 keys
          • "Kwangyang丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Kwangyang丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Genoa"
          • "mt"
          • ""
        • {} 3 keys
          • "Genoa丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Genoa丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Port Klang"
          • "mt"
          • ""
        • {} 3 keys
          • "Port Klang丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Port Klang丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Kaohsiung"
          • "mt"
          • ""
        • {} 3 keys
          • "Kaohsiung丨warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Kaohsiung丨cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Los Angeles"
          • "吨"
          • ""
        • {} 3 keys
          • "Los Angeles丨warehouse warrants"
          • "吨"
          • ""
        • {} 3 keys
          • "Los Angeles丨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
LME total inventoryintegermt
Up/downintegermt
Total warehouse warrantsintegermt
Total cancelled warrantintegermt
Asia丨Totalintegermt
Europe丨Totalintegermt
America丨Totalintegermt
Johorintegermt
Johor丨warehouse warrantsintegermt
Johor丨cancelled warrantintegermt
Busanintegermt
Busan丨warehouse warrantsintegermt
Busan丨cancelled warrantintegermt
Kwangyangintegermt
Kwangyang丨warehouse warrantsintegermt
Kwangyang丨cancelled warrantintegermt
Singaporeintegermt
Singapore丨warehouse warrantsintegermt
Singapore丨cancelled warrantintegermt
Rotterdamintegermt
Rotterdam丨warehouse warrantsintegermt
Rotterdam丨cancelled warrantintegermt
Genoaintegermt
Genoa丨warehouse warrantsintegermt
Genoa丨cancelled warrantintegermt
Baltimoreintegermt
Baltimore丨warehouse warrantsintegermt
Baltimore丨cancelled warrantintegermt
Antwerpintegermt
Antwerp丨warehouse warrantsintegermt
Antwerp丨cancelled warrantintegermt
Port Klangintegermt
Port Klang丨warehouse warrantsintegermt
Port Klang丨cancelled warrantintegermt
Triesteintegermt
Trieste丨warehouse warrantsintegermt
Trieste丨cancelled warrantintegermt
Kaohsiungintegermt
Kaohsiung丨warehouse warrantsintegermt
Kaohsiung丨cancelled warrantintegermt
Los Angelesinteger
Los Angeles丨warehouse warrantsinteger
Los Angeles丨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 inventory (LME)
DailyDATAAPI
Catagory
Tin > Refined Tin > Inventory
Service
Data & API
Starting Date
Feb 01, 2011