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>Yttrium>Yttrium oxide>Import & Export>Yttrium oxide import data by country>
Yttrium oxide import data by country
MonthlyDATAAPI
Service
Data & API
Starting Date
Jan 01, 2017
Catagory
Yttrium > Yttrium oxide > Import & Export
URL
https://dataapi.smm.cn/GetDataEn/y_yttrium_oxide_import_data_by_country
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
      • [] 45 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "Total丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Total丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "Total丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Australia丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Australia丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "Australia丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Austria丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Austria丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "Austria丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Germany丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Germany丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "Germany丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Russian Federation丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Russian Federation丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "Russian Federation丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "France丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "France丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "France丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "South Korea丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "South Korea丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "South Korea丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "The Czech Republic丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "The Czech Republic丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "The Czech Republic丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "The US丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "The US丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "The US丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Japan丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Japan丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "Japan丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Swiss丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Swiss丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "Swiss丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "The UK丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "The UK丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "The UK丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "China丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "China丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "China丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Taiwan (China)丨Import volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Taiwan (China)丨Import value"
          • "US$"
          • ""
        • {} 3 keys
          • "Taiwan (China)丨Import price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Note"
          • ""
          • ""
        • {} 3 keys
          • "Note"
          • ""
          • ""
      • [] 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
Total丨Import volumeintegermt
Total丨Import valueintegerUS$
Total丨Import priceintegerUS$/mt
Australia丨Import volumeintegermt
Australia丨Import valueintegerUS$
Australia丨Import priceintegerUS$/mt
Austria丨Import volumeintegermt
Austria丨Import valueintegerUS$
Austria丨Import priceintegerUS$/mt
Germany丨Import volumeintegermt
Germany丨Import valueintegerUS$
Germany丨Import priceintegerUS$/mt
Russian Federation丨Import volumeintegermt
Russian Federation丨Import valueintegerUS$
Russian Federation丨Import priceintegerUS$/mt
France丨Import volumeintegermt
France丨Import valueintegerUS$
France丨Import priceintegerUS$/mt
South Korea丨Import volumeintegermt
South Korea丨Import valueintegerUS$
South Korea丨Import priceintegerUS$/mt
The Czech Republic丨Import volumeintegermt
The Czech Republic丨Import valueintegerUS$
The Czech Republic丨Import priceintegerUS$/mt
The US丨Import volumeintegermt
The US丨Import valueintegerUS$
The US丨Import priceintegerUS$/mt
Japan丨Import volumeintegermt
Japan丨Import valueintegerUS$
Japan丨Import priceintegerUS$/mt
Swiss丨Import volumeintegermt
Swiss丨Import valueintegerUS$
Swiss丨Import priceintegerUS$/mt
The UK丨Import volumeintegermt
The UK丨Import valueintegerUS$
The UK丨Import priceintegerUS$/mt
China丨Import volumeintegermt
China丨Import valueintegerUS$
China丨Import priceintegerUS$/mt
Taiwan (China)丨Import volumeintegermt
Taiwan (China)丨Import valueintegerUS$
Taiwan (China)丨Import priceintegerUS$/mt
Notestring
Notestring
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
Yttrium oxide import data by country
MonthlyDATAAPI
Catagory
Yttrium > Yttrium oxide > Import & Export
Service
Data & API
Starting Date
Jan 01, 2017