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

Visible inventory(LME)
DailyDATAAPI
Service
Data & API
Starting Date
Dec 30, 2004
Catagory
Copper > Copper Cathode > Visible Inventory
URL
https://dataapi.smm.cn/GetDataEn/cu_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
      • [] 83 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "Total"
          • "mt"
          • ""
        • {} 3 keys
          • "+/-"
          • "mt"
          • ""
        • {} 3 keys
          • "Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Asia"
          • "mt"
          • ""
        • {} 3 keys
          • "Europe"
          • "mt"
          • ""
        • {} 3 keys
          • "North America"
          • "mt"
          • ""
        • {} 3 keys
          • "Busan"
          • "mt"
          • ""
        • {} 3 keys
          • "Busan / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Busan / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Gwangyang"
          • "mt"
          • ""
        • {} 3 keys
          • "Gwangyang / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Gwangyang / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Hamburg"
          • "mt"
          • ""
        • {} 3 keys
          • "Hamburg / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Hamburg / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Hull"
          • "mt"
          • ""
        • {} 3 keys
          • "Hull / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Hull / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Leghorn"
          • "mt"
          • ""
        • {} 3 keys
          • "Leghorn / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Leghorn / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "New Orleans"
          • "mt"
          • ""
        • {} 3 keys
          • "New Orleans / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "New Orleans / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Vlissingen"
          • "mt"
          • ""
        • {} 3 keys
          • "Vlissingen / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Vlissingen / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor / Warehouse warrants"
          • "mt"
          • ""
        • 46 ... 78
        • {} 3 keys
          • "Panama / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Moerdijk"
          • "mt"
          • ""
        • {} 3 keys
          • "Moerdijk / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Moerdijk / Cancelled warrant"
          • "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
+/-integermt
Warehouse warrantsintegermt
Cancelled warrantintegermt
Asiaintegermt
Europeintegermt
North Americaintegermt
Busanintegermt
Busan / Warehouse warrantsintegermt
Busan / Cancelled warrantintegermt
Singaporeintegermt
Singapore / Warehouse warrantsintegermt
Singapore / Cancelled warrantintegermt
Gwangyangintegermt
Gwangyang / Warehouse warrantsintegermt
Gwangyang / Cancelled warrantintegermt
Bilbaointegermt
Bilbao / Warehouse warrantsintegermt
Bilbao / Cancelled warrantintegermt
Triesteintegermt
Trieste / Warehouse warrantsintegermt
Trieste / Cancelled warrantintegermt
Hamburgintegermt
Hamburg / Warehouse warrantsintegermt
Hamburg / Cancelled warrantintegermt
Rotterdamintegermt
Rotterdam / Warehouse warrantsintegermt
Rotterdam / Cancelled warrantintegermt
Hullintegermt
Hull / Warehouse warrantsintegermt
Hull / Cancelled warrantintegermt
Leghornintegermt
Leghorn / Warehouse warrantsintegermt
Leghorn / Cancelled warrantintegermt
New Orleansintegermt
New Orleans / Warehouse warrantsintegermt
New Orleans / Cancelled warrantintegermt
Vlissingenintegermt
Vlissingen / Warehouse warrantsintegermt
Vlissingen / Cancelled warrantintegermt
Baltimoreintegermt
Baltimore / Warehouse warrantsintegermt
Baltimore / Cancelled warrantintegermt
Johorintegermt
Johor / Warehouse warrantsintegermt
Johor / Cancelled warrantintegermt
Dubaiintegermt
Dubai / Warehouse warrantsintegermt
Dubai / Cancelled warrantintegermt
St Louisintegermt
St Louis / Warehouse warrantsintegermt
St Louis / Cancelled warrantintegermt
Antwerpintegermt
Antwerp / Warehouse warrantsintegermt
Antwerp / Cancelled warrantintegermt
Liverpoolintegermt
Liverpool / Warehouse warrantsintegermt
Liverpool / Cancelled warrantintegermt
Barcelonaintegermt
Barcelona / Warehouse warrantsintegermt
Barcelona / Cancelled warrantintegermt
Incheon Port,S.Koreaintegermt
Incheon Port,S.Korea / Warehouse warrantsintegermt
Incheon Port,S.Korea / Cancelled warrantintegermt
Mobile, Alabamaintegermt
Mobile, Alabama / Warehouse warrantsintegermt
Mobile, Alabama / Cancelled warrantintegermt
Chicagointegermt
Chicago / Warehouse warrantsintegermt
Chicago / Cancelled warrantintegermt
Port Klang, Malaysiaintegermt
Port Klang, Malaysia / Warehouse warrantsintegermt
Port Klang, Malaysia / Cancelled warrantintegermt
Gaoxiongintegermt
Gaoxiong / Warehouse warrantsintegermt
Gaoxiong / Cancelled warrantintegermt
Panamaintegermt
Panama / Warehouse warrantsintegermt
Panama / Cancelled warrantintegermt
Moerdijkintegermt
Moerdijk / Warehouse warrantsintegermt
Moerdijk / Cancelled warrantintegermt
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
Copper > Copper Cathode > Visible Inventory
Service
Data & API
Starting Date
Dec 30, 2004