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>Zinc>Refined Zinc>Price>Traded Prices for 0# Zinc in Tianjin (Huludao included)>
Traded Prices for 0# Zinc in Tianjin (Huludao included)
DailyDATAAPI
Service
Data & API
Starting Date
Jan 04, 2013
Catagory
Zinc > Refined Zinc > Price
URL
https://dataapi.smm.cn/GetDataEn/zn_traded_prices_for_number_0_zinc_in_tianjin_excluding_huludao_zinc
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
      • [] 32 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "1# low in Shanghai"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "1# high in Shanghai"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# low in Shanghai"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# high in Shanghai"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "1# low in Guangdong"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "1# high in Guangdong"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# low in Guangdong"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# high in Guangdong"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "1# low in Tianjin"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "1# high in Tianjin"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# low in Tianjin"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# high in Tianjin"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# Huludao(old) in Tianjin"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "1# average in Shanghai"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "1# average in Guangdong"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "1# average in Tianjin"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "1# Shanghai-Guangdong spread"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "1# Shanghai-Tianjin spread"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# average in Shanghai"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# average in Guangdong"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# average in Tianjin(Huludao included)"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# average in Tianjin"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# Shanghai-Guangdong spread"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# Shanghai-Tianjin spread (Huludao included)"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "0# Shanghai-Tianjin spread"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "Low spot premiums/discounts in Shanghai"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "High spot premiums/discounts in Shanghai"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "Low spot premiums/discounts in Guangdong"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "High spot premiums/discounts in Guangdong"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "Low spot premiums/discounts in Tianjin"
          • "RMB/mt"
          • ""
        • {} 3 keys
          • "High spot premiums/discounts in Tianjin"
          • "RMB/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
1# low in ShanghaiintegerRMB/mt
1# high in ShanghaiintegerRMB/mt
0# low in ShanghaiintegerRMB/mt
0# high in ShanghaiintegerRMB/mt
1# low in GuangdongintegerRMB/mt
1# high in GuangdongintegerRMB/mt
0# low in GuangdongintegerRMB/mt
0# high in GuangdongintegerRMB/mt
1# low in TianjinintegerRMB/mt
1# high in TianjinintegerRMB/mt
0# low in TianjinintegerRMB/mt
0# high in TianjinintegerRMB/mt
0# Huludao(old) in TianjinintegerRMB/mt
1# average in ShanghaiintegerRMB/mt
1# average in GuangdongintegerRMB/mt
1# average in TianjinintegerRMB/mt
1# Shanghai-Guangdong spreadintegerRMB/mt
1# Shanghai-Tianjin spreadintegerRMB/mt
0# average in ShanghaiintegerRMB/mt
0# average in GuangdongintegerRMB/mt
0# average in Tianjin(Huludao included)integerRMB/mt
0# average in TianjinintegerRMB/mt
0# Shanghai-Guangdong spreadintegerRMB/mt
0# Shanghai-Tianjin spread (Huludao included)integerRMB/mt
0# Shanghai-Tianjin spreadintegerRMB/mt
Low spot premiums/discounts in ShanghaiintegerRMB/mt
High spot premiums/discounts in ShanghaiintegerRMB/mt
Low spot premiums/discounts in GuangdongintegerRMB/mt
High spot premiums/discounts in GuangdongintegerRMB/mt
Low spot premiums/discounts in TianjinintegerRMB/mt
High spot premiums/discounts in TianjinintegerRMB/mt
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
Traded Prices for 0# Zinc in Tianjin (Huludao included)
DailyDATAAPI
Catagory
Zinc > Refined Zinc > Price
Service
Data & API
Starting Date
Jan 04, 2013