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 export data by country>
Yttrium oxide export 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_export_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
      • [] 87 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "Total丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Total丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Total丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Estonia丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Estonia丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Estonia丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Austria丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Austria丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Austria丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Pakistan丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Pakistan丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Pakistan丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Brazil丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Brazil丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Brazil丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Germany丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Germany丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Germany丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Russian Federation丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Russian Federation丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Russian Federation丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "France丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "France丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "France丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "South Korea丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "South Korea丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "South Korea丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Holland丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Holland丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Holland丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Canada丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Canada丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Canada丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Latvia丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Latvia丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Latvia丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "Malaysia丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "Malaysia丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Malaysia丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "The US丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "The US丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "The US丨Export price"
          • "US$/mt"
          • ""
        • {} 3 keys
          • "South Africa丨Export volume"
          • "mt"
          • ""
        • {} 3 keys
          • "South Africa丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "South Africa丨Export price"
          • "US$/mt"
          • ""
        • 46 ... 82
        • {} 3 keys
          • "Hong Kong (China)丨Export value"
          • "US$"
          • ""
        • {} 3 keys
          • "Hong Kong (China)丨Export 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丨Export volumeintegermt
Total丨Export valueintegerUS$
Total丨Export priceintegerUS$/mt
Estonia丨Export volumeintegermt
Estonia丨Export valueintegerUS$
Estonia丨Export priceintegerUS$/mt
Austria丨Export volumeintegermt
Austria丨Export valueintegerUS$
Austria丨Export priceintegerUS$/mt
Pakistan丨Export volumeintegermt
Pakistan丨Export valueintegerUS$
Pakistan丨Export priceintegerUS$/mt
Brazil丨Export volumeintegermt
Brazil丨Export valueintegerUS$
Brazil丨Export priceintegerUS$/mt
Germany丨Export volumeintegermt
Germany丨Export valueintegerUS$
Germany丨Export priceintegerUS$/mt
Russian Federation丨Export volumeintegermt
Russian Federation丨Export valueintegerUS$
Russian Federation丨Export priceintegerUS$/mt
France丨Export volumeintegermt
France丨Export valueintegerUS$
France丨Export priceintegerUS$/mt
South Korea丨Export volumeintegermt
South Korea丨Export valueintegerUS$
South Korea丨Export priceintegerUS$/mt
Holland丨Export volumeintegermt
Holland丨Export valueintegerUS$
Holland丨Export priceintegerUS$/mt
Canada丨Export volumeintegermt
Canada丨Export valueintegerUS$
Canada丨Export priceintegerUS$/mt
Latvia丨Export volumeintegermt
Latvia丨Export valueintegerUS$
Latvia丨Export priceintegerUS$/mt
Malaysia丨Export volumeintegermt
Malaysia丨Export valueintegerUS$
Malaysia丨Export priceintegerUS$/mt
The US丨Export volumeintegermt
The US丨Export valueintegerUS$
The US丨Export priceintegerUS$/mt
South Africa丨Export volumeintegermt
South Africa丨Export valueintegerUS$
South Africa丨Export priceintegerUS$/mt
Norway丨Export volumeintegermt
Norway丨Export valueintegerUS$
Norway丨Export priceintegerUS$/mt
Japan丨Export volumeintegermt
Japan丨Export valueintegerUS$
Japan丨Export priceintegerUS$/mt
Thailand丨Export volumeintegermt
Thailand丨Export valueintegerUS$
Thailand丨Export priceintegerUS$/mt
Turkey丨Export volumeintegermt
Turkey丨Export valueintegerUS$
Turkey丨Export priceintegerUS$/mt
Ukraine丨Export volumeintegermt
Ukraine丨Export valueintegerUS$
Ukraine丨Export priceintegerUS$/mt
Singapore丨Export volumeintegermt
Singapore丨Export valueintegerUS$
Singapore丨Export priceintegerUS$/mt
Armenia丨Export volumeintegermt
Armenia丨Export valueintegerUS$
Armenia丨Export priceintegerUS$/mt
Iran丨Export volumeintegermt
Iran丨Export valueintegerUS$
Iran丨Export priceintegerUS$/mt
Italy丨Export volumeintegermt
Italy丨Export valueintegerUS$
Italy丨Export priceintegerUS$/mt
India丨Export volumeintegermt
India丨Export valueintegerUS$
India丨Export priceintegerUS$/mt
The UK丨Export volumeintegermt
The UK丨Export valueintegerUS$
The UK丨Export priceintegerUS$/mt
Taiwan (China)丨Export volumeintegermt
Taiwan (China)丨Export valueintegerUS$
Taiwan (China)丨Export priceintegerUS$/mt
Hong Kong (China)丨Export volumeintegermt
Hong Kong (China)丨Export valueintegerUS$
Hong Kong (China)丨Export 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 export data by country
MonthlyDATAAPI
Catagory
Yttrium > Yttrium oxide > Import & Export
Service
Data & API
Starting Date
Jan 01, 2017