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>Steel>Import & Export>Export>Steel Exports by Product>
Steel Exports by Product
MonthlyDATAAPI
Service
Data & API
Starting Date
Jan 01, 2004
Catagory
Steel > Import & Export > Export
URL
https://dataapi.smm.cn/GetDataEn/steel_import_and_export_steel_exports_by_product
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
      • [] 23 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "Bar"
          • "10kt"
          • ""
        • {} 3 keys
          • "Rod, wire"
          • "10kt"
          • ""
        • {} 3 keys
          • "Rebar"
          • "10kt"
          • ""
        • {} 3 keys
          • "Seamless tube/pipe "
          • "10kt"
          • ""
        • {} 3 keys
          • "Welded tube/pipe "
          • "10kt"
          • ""
        • {} 3 keys
          • "Cast iron tube/pipe"
          • "10kt"
          • ""
        • {} 3 keys
          • "Large section"
          • "10kt"
          • ""
        • {} 3 keys
          • "Small, medium-sized section"
          • "10kt"
          • ""
        • {} 3 keys
          • "Medium & heavy sheet/plate"
          • "10kt"
          • ""
        • {} 3 keys
          • "Medium & heavy wide strip"
          • "10kt"
          • ""
        • {} 3 keys
          • "Cold-rolled thin sheet/plate"
          • "10kt"
          • ""
        • {} 3 keys
          • "Hot-rolled narrow strip "
          • "10kt"
          • ""
        • {} 3 keys
          • "Cold-rolled narrow strip"
          • "10kt"
          • ""
        • {} 3 keys
          • "Plated sheet/plate, strip"
          • "10kt"
          • ""
        • {} 3 keys
          • "Color-coated sheet/plate, strip"
          • "10kt"
          • ""
        • {} 3 keys
          • "Angle welding section"
          • "10kt"
          • ""
        • {} 3 keys
          • "Common cold-bent section"
          • "10kt"
          • ""
        • {} 3 keys
          • "Pipe/tube fittings"
          • "10kt"
          • ""
        • {} 3 keys
          • "Wire "
          • "10kt"
          • ""
        • {} 3 keys
          • "Ultra-heavy sheet/plate"
          • "10kt"
          • ""
        • {} 3 keys
          • "Heavy sheet/plate"
          • "10kt"
          • ""
        • {} 3 keys
          • "Cold-rolled thin wide strip"
          • "10kt"
          • ""
      • [] 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
Barfloat10kt
Rod, wirefloat10kt
Rebarfloat10kt
Seamless tube/pipe float10kt
Welded tube/pipe float10kt
Cast iron tube/pipefloat10kt
Large sectionfloat10kt
Small, medium-sized sectionfloat10kt
Medium & heavy sheet/platefloat10kt
Medium & heavy wide stripfloat10kt
Cold-rolled thin sheet/platefloat10kt
Hot-rolled narrow strip float10kt
Cold-rolled narrow stripfloat10kt
Plated sheet/plate, stripfloat10kt
Color-coated sheet/plate, stripfloat10kt
Angle welding sectionfloat10kt
Common cold-bent sectionfloat10kt
Pipe/tube fittingsfloat10kt
Wire float10kt
Ultra-heavy sheet/platefloat10kt
Heavy sheet/platefloat10kt
Cold-rolled thin wide stripfloat10kt
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
Steel Exports by Product
MonthlyDATAAPI
Catagory
Steel > Import & Export > Export
Service
Data & API
Starting Date
Jan 01, 2004