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>Aluminum>Aluminum>Inventory>LME aluminium ingot inventory by Country>
LME aluminium ingot inventory by Country
DailyDATAAPI
Service
Data & API
Starting Date
Feb 01, 2011
Catagory
Aluminum > Aluminum > Inventory
URL
https://dataapi.smm.cn/GetDataEn/al_lme_aluminium_ingot_inventory_by_continent
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
      • [] 101 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "LME total inventory"
          • "mt"
          • ""
        • {} 3 keys
          • "Up/down"
          • "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
          • "Johor"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Johor / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Gwangyang"
          • "mt"
          • ""
        • {} 3 keys
          • "Gwangyang / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Gwangyang / Cancelled warrant"
          • "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
          • "Rotterdam"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Rotterdam / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Antwerp / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Hamburg"
          • "mt"
          • ""
        • {} 3 keys
          • "Hamburg / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Hamburg / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste"
          • "mt"
          • ""
        • {} 3 keys
          • "Trieste / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Bilbao / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Goteborg"
          • "mt"
          • ""
        • {} 3 keys
          • "Goteborg / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Goteborg / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Helsingborg"
          • "mt"
          • ""
        • {} 3 keys
          • "Helsingborg / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Helsingborg / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Tyne And Wear"
          • "mt"
          • ""
        • {} 3 keys
          • "Tyne And Wear / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Tyne And Wear / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore"
          • "mt"
          • ""
        • {} 3 keys
          • "Baltimore / Warehouse warrants"
          • "mt"
          • ""
        • 46 ... 95
          96 ... 96
        • {} 3 keys
          • "Moerdijk / Cancelled warrant"
          • "mt"
          • ""
        • {} 3 keys
          • "Owensboro, Kentucky"
          • "mt"
          • ""
        • {} 3 keys
          • "Owensboro, Kentucky / Warehouse warrants"
          • "mt"
          • ""
        • {} 3 keys
          • "Owensboro, Kentucky / 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
LME total inventoryintegermt
Up/downintegermt
Warehouse warrantsintegermt
Cancelled warrantintegermt
Asiaintegermt
Europeintegermt
North Americaintegermt
Johorintegermt
Johor / Warehouse warrantsintegermt
Johor / Cancelled warrantintegermt
Gwangyangintegermt
Gwangyang / Warehouse warrantsintegermt
Gwangyang / Cancelled warrantintegermt
Busanintegermt
Busan / Warehouse warrantsintegermt
Busan / Cancelled warrantintegermt
Singaporeintegermt
Singapore / Warehouse warrantsintegermt
Singapore / Cancelled warrantintegermt
Rotterdamintegermt
Rotterdam / Warehouse warrantsintegermt
Rotterdam / Cancelled warrantintegermt
Antwerpintegermt
Antwerp / Warehouse warrantsintegermt
Antwerp / Cancelled warrantintegermt
Hamburgintegermt
Hamburg / Warehouse warrantsintegermt
Hamburg / Cancelled warrantintegermt
Trieste / Warehouse warrantsintegermt
Triesteintegermt
Trieste / Cancelled warrantintegermt
Bilbaointegermt
Bilbao / Warehouse warrantsintegermt
Bilbao / Cancelled warrantintegermt
Goteborgintegermt
Goteborg / Warehouse warrantsintegermt
Goteborg / Cancelled warrantintegermt
Helsingborgintegermt
Helsingborg / Warehouse warrantsintegermt
Helsingborg / Cancelled warrantintegermt
Tyne And Wearintegermt
Tyne And Wear / Warehouse warrantsintegermt
Tyne And Wear / Cancelled warrantintegermt
Baltimoreintegermt
Baltimore / Warehouse warrantsintegermt
Baltimore / Cancelled warrantintegermt
Chicagointegermt
Chicago / Warehouse warrantsintegermt
Chicago / Cancelled warrantintegermt
Detroitintegermt
Detroit / Warehouse warrantsintegermt
Detroit / Cancelled warrantintegermt
Vlissingenintegermt
Vlissingen / Warehouse warrantsintegermt
Vlissingen / Cancelled warrantintegermt
Long Beachintegermt
Long Beach / Warehouse warrantsintegermt
Long Beach / Cancelled warrantintegermt
St. Louisintegermt
St. Louis / Warehouse warrantsintegermt
St. Louis / Cancelled warrantintegermt
New Orleansintegermt
New Orleans / Warehouse warrantsintegermt
New Orleans / Cancelled warrantintegermt
Liverpoolintegermt
Liverpool / Warehouse warrantsintegermt
Liverpool / Cancelled warrantintegermt
Hullintegermt
Hull / Warehouse warrantsintegermt
Hull / Cancelled warrantintegermt
Incheonintegermt
Incheon / Warehouse warrantsintegermt
Incheon / Cancelled warrantintegermt
Mobileintegermt
Mobile / Warehouse warrantsintegermt
Mobile / Cancelled warrantintegermt
Genoaintegermt
Genoa / Warehouse warrantsintegermt
Genoa / Cancelled warrantintegermt
Leghornintegermt
Leghorn / Warehouse warrantsintegermt
Leghorn / Cancelled warrantintegermt
Los Angelesintegermt
Los Angeles / Warehouse warrantsintegermt
Los Angeles / Cancelled warrantintegermt
Toledointegermt
Toledo / Warehouse warrantsintegermt
Toledo / Cancelled warrantintegermt
Port Klang, Malaysiaintegermt
Port Klang, Malaysia / Warehouse warrantsintegermt
Port Klang, Malaysia / Cancelled warrantintegermt
Gaoxiongintegermt
Gaoxiong / Warehouse warrantsintegermt
Gaoxiong / Cancelled warrantintegermt
Moerdijkintegermt
Moerdijk / Warehouse warrantsintegermt
Moerdijk / Cancelled warrantintegermt
Owensboro, Kentuckyintegermt
Owensboro, Kentucky / Warehouse warrantsintegermt
Owensboro, Kentucky / 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 aluminium ingot inventory by Country
DailyDATAAPI
Catagory
Aluminum > Aluminum > Inventory
Service
Data & API
Starting Date
Feb 01, 2011