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
Lead > Primary Lead > Inventory
URL
https://dataapi.smm.cn/GetDataEn/pb_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
      • [] 86 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
          • "Long Beach"
          • "mt"
          • ""
        • {} 3 keys
          • "Long Beach / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Long Beach / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Detroit"
          • "mt"
          • ""
        • {} 3 keys
          • "Detroit / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Detroit / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "New Orleans"
          • "mt"
          • ""
        • {} 3 keys
          • "New Orleans / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "New Orleans / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Singapore / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Genoa"
          • "mt"
          • ""
        • {} 3 keys
          • "Genoa / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Genoa / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Chicago"
          • "mt"
          • ""
        • {} 3 keys
          • "Chicago / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Chicago / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Hamburg"
          • "mt"
          • ""
        • {} 3 keys
          • "Hamburg / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Hamburg / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Leghorn"
          • "mt"
          • ""
        • {} 3 keys
          • "Leghorn / Warehouse warrants"
          • "mt"
          • ""
        • 46 ... 81
        • {} 3 keys
          • "Incheon / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Gwangyang"
          • "mt"
          • ""
        • {} 3 keys
          • "Gwangyang/ Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Gwangyang/ 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
Long Beachintegermt
Long Beach / Warehouse warrantsintegermt
Long Beach / Cancelled warrantintegermt
Detroitintegermt
Detroit / Warehouse warrantsintegermt
Detroit / Cancelled warrantintegermt
New Orleansintegermt
New Orleans / Warehouse warrantsintegermt
New Orleans / Cancelled warrantintegermt
Singaporeintegermt
Singapore / Warehouse warrantsintegermt
Singapore / Cancelled warrantintegermt
Triesteintegermt
Trieste / Warehouse warrantsintegermt
Trieste / Cancelled warrantintegermt
Genoaintegermt
Genoa / Warehouse warrantsintegermt
Genoa / Cancelled warrantintegermt
Bilbaointegermt
Bilbao / Warehouse warrantsintegermt
Bilbao / Cancelled warrantintegermt
Baltimoreintegermt
Baltimore / Warehouse warrantsintegermt
Baltimore / Cancelled warrantintegermt
Chicagointegermt
Chicago / Warehouse warrantsintegermt
Chicago / Cancelled warrantintegermt
Hamburgintegermt
Hamburg / Warehouse warrantsintegermt
Hamburg / Cancelled warrantintegermt
Antwerpintegermt
Antwerp / Warehouse warrantsintegermt
Antwerp / Cancelled warrantintegermt
Johorintegermt
Johor / Warehouse warrantsintegermt
Johor / Cancelled warrantintegermt
Leghornintegermt
Leghorn / Warehouse warrantsintegermt
Leghorn / Cancelled warrantintegermt
Vlissingenintegermt
Vlissingen / Warehouse warrantsintegermt
Vlissingen / Cancelled warrantintegermt
Rotterdamintegermt
Rotterdam / Warehouse warrantsintegermt
Rotterdam / Cancelled warrantintegermt
Liverpoolintegermt
Liverpool / Warehouse warrantsintegermt
Liverpool / Cancelled warrantintegermt
Barcelonaintegermt
Barcelona / Warehouse warrantsintegermt
Barcelona / Cancelled warrantintegermt
Mobileintegermt
Mobile / Warehouse warrantsintegermt
Mobile / Cancelled warrantintegermt
Los Angelesintegermt
Los Angeles / Warehouse warrantsintegermt
Los Angeles / Cancelled warrantintegermt
Port Klang, Malaysiaintegermt
Port Klang, Malaysia / Warehouse warrantsintegermt
Port Klang, Malaysia / Cancelled warrantintegermt
Hullintegermt
Hull / Warehouse warrantsintegermt
Hull / Cancelled warrantintegermt
Gaoxiongintegermt
Gaoxiong / Warehouse warrantsintegermt
Gaoxiong / Cancelled warrantintegermt
Moerdijkintegermt
Moerdijk / Warehouse warrantsintegermt
Moerdijk / Cancelled warrantintegermt
Busanintegermt
Busan / Warehouse warrantsintegermt
Busan / Cancelled warrantintegermt
Incheonintegermt
Incheon / Warehouse warrantsintegermt
Incheon / Cancelled warrantintegermt
Gwangyangintegermt
Gwangyang/ Warehouse warrantsintegermt
Gwangyang/ 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
LME inventory
DailyDATAAPI
Catagory
Lead > Primary Lead > Inventory
Service
Data & API
Starting Date
Feb 01, 2011