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
Nickel > Refined Nickel > Inventory
URL
https://dataapi.smm.cn/GetDataEn/ni_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
      • [] 82 items
        • {} 3 keys
          • "Data"
          • ""
          • ""
        • {} 3 keys
          • "Total"
          • ""
          • ""
        • {} 3 keys
          • "+/-"
          • ""
          • ""
        • {} 3 keys
          • "Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Asia"
          • ""
          • ""
        • {} 3 keys
          • "Europe"
          • ""
          • ""
        • {} 3 keys
          • "North America"
          • ""
          • ""
        • {} 3 keys
          • "Baltimore"
          • ""
          • ""
        • {} 3 keys
          • "Baltimore / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Baltimore / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Chicago"
          • ""
          • ""
        • {} 3 keys
          • "Chicago / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Chicago / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Busan"
          • ""
          • ""
        • {} 3 keys
          • "Busan / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Busan / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Incheon Port,S.Korea"
          • ""
          • ""
        • {} 3 keys
          • "Incheon Port,S.Korea / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Incheon Port,S.Korea / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Singapore"
          • ""
          • ""
        • {} 3 keys
          • "Singapore / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Singapore / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Rotterdam"
          • ""
          • ""
        • {} 3 keys
          • "Rotterdam / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Rotterdam / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Genoa"
          • ""
          • ""
        • {} 3 keys
          • "Genoa / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Genoa / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Goteborg"
          • ""
          • ""
        • {} 3 keys
          • "Goteborg / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Goteborg / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Tyne And Wear"
          • ""
          • ""
        • {} 3 keys
          • "Tyne And Wear / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Tyne And Wear / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Helsingborg"
          • ""
          • ""
        • {} 3 keys
          • "Helsingborg / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Helsingborg / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Liverpool"
          • ""
          • ""
        • {} 3 keys
          • "Liverpool / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Liverpool / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Hamburg"
          • ""
          • ""
        • {} 3 keys
          • "Hamburg / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "Hamburg / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Antwerp"
          • ""
          • ""
        • {} 3 keys
          • "Antwerp / Warehouse warrants"
          • ""
          • ""
        • 46 ... 77
        • {} 3 keys
          • "New Orleans / Warehouse warrants"
          • ""
          • ""
        • {} 3 keys
          • "New Orleans / Cancelled warrant"
          • ""
          • ""
        • {} 3 keys
          • "Leghorn"
          • ""
          • ""
        • {} 3 keys
          • "Leghorn / Warehouse warrants"
          • ""
          • ""
      • [] 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
Datadatetime
Totalinteger
+/-integer
Warehouse warrantsinteger
Cancelled warrantinteger
Asiainteger
Europeinteger
North Americainteger
Baltimoreinteger
Baltimore / Warehouse warrantsinteger
Baltimore / Cancelled warrantinteger
Chicagointeger
Chicago / Warehouse warrantsinteger
Chicago / Cancelled warrantinteger
Busaninteger
Busan / Warehouse warrantsinteger
Busan / Cancelled warrantinteger
Incheon Port,S.Koreainteger
Incheon Port,S.Korea / Warehouse warrantsinteger
Incheon Port,S.Korea / Cancelled warrantinteger
Singaporeinteger
Singapore / Warehouse warrantsinteger
Singapore / Cancelled warrantinteger
Rotterdaminteger
Rotterdam / Warehouse warrantsinteger
Rotterdam / Cancelled warrantinteger
Genoainteger
Genoa / Warehouse warrantsinteger
Genoa / Cancelled warrantinteger
Goteborginteger
Goteborg / Warehouse warrantsinteger
Goteborg / Cancelled warrantinteger
Tyne And Wearinteger
Tyne And Wear / Warehouse warrantsinteger
Tyne And Wear / Cancelled warrantinteger
Helsingborginteger
Helsingborg / Warehouse warrantsinteger
Helsingborg / Cancelled warrantinteger
Liverpoolinteger
Liverpool / Warehouse warrantsinteger
Liverpool / Cancelled warrantinteger
Hamburginteger
Hamburg / Warehouse warrantsinteger
Hamburg / Cancelled warrantinteger
Antwerpinteger
Antwerp / Warehouse warrantsinteger
Antwerp / Cancelled warrantinteger
Gwangyanginteger
Gwangyang / Warehouse warrantsinteger
Gwangyang / Cancelled warrantinteger
Hullinteger
Hull / Warehouse warrantsinteger
Hull / Cancelled warrantinteger
Dubaiinteger
Dubai / Warehouse warrantsinteger
Dubai / Cancelled warrantinteger
Johorinteger
Johor / Warehouse warrantsinteger
Johor / Cancelled warrantinteger
Vlissingeninteger
Vlissingen / Warehouse warrantsinteger
Vlissingen / Cancelled warrantinteger
Detroitinteger
Detroit / Warehouse warrantsinteger
Detroit / Cancelled warrantinteger
Gaoxionginteger
Gaoxiong / Warehouse warrantsinteger
Gaoxiong / Cancelled warrantinteger
Mobile, Alabamainteger
Mobile, Alabama / Warehouse warrantsinteger
Mobile, Alabama / Cancelled warrantinteger
Moerdijkinteger
Moerdijk / Warehouse warrantsinteger
Moerdijk / Cancelled warrantinteger
Port Klang, Malaysiainteger
Port Klang, Malaysia / Warehouse warrantsinteger
Port Klang, Malaysia / Cancelled warrantinteger
New Orleansinteger
New Orleans / Warehouse warrantsinteger
New Orleans / Cancelled warrantinteger
Leghorninteger
Leghorn / Warehouse warrantsinteger
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
Nickel > Refined Nickel > Inventory
Service
Data & API
Starting Date
Feb 01, 2011