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

Copper cathode exports
MonthlyDATAAPI
Service
Data & API
Starting Date
Jan 01, 2001
Catagory
Copper > Copper Cathode > Import & Export
URL
https://dataapi.smm.cn/GetDataEn/cu_copper_cathode_exports
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
      • [] 31 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "Refined Copper"
          • "mt"
          • ""
        • {} 3 keys
          • "Refined Copper MoM"
          • "%"
          • ""
        • {} 3 keys
          • "Refined Copper YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Refined Copper YTD"
          • "mt"
          • ""
        • {} 3 keys
          • "Refined Copper YTD YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Copper Concentrate"
          • "mt"
          • ""
        • {} 3 keys
          • "Copper Concentrate YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Copper Concentrate YTD"
          • "mt"
          • ""
        • {} 3 keys
          • "Copper Concentrate YTD YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Anode Copper"
          • "mt"
          • ""
        • {} 3 keys
          • "Anode Copper YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Anode Copper YTD"
          • "mt"
          • ""
        • {} 3 keys
          • "Anode Copper YTD YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Scrap Copper"
          • "mt"
          • ""
        • {} 3 keys
          • "Scrap Copper MoM"
          • "%"
          • ""
        • {} 3 keys
          • "Scrap Copper YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Scrap Copper YTD"
          • "mt"
          • ""
        • {} 3 keys
          • "Scrap Copper YTD YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Copper Material"
          • "mt"
          • ""
        • {} 3 keys
          • "Copper Material MoM"
          • "%"
          • ""
        • {} 3 keys
          • "Copper Material YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Copper Material YTD"
          • "mt"
          • ""
        • {} 3 keys
          • "Copper Material YTD YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Copper Alloy"
          • "mt"
          • ""
        • {} 3 keys
          • "Copper Alloy MoM"
          • "%"
          • ""
        • {} 3 keys
          • "Copper Alloy YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Copper Alloy YTD"
          • "mt"
          • ""
        • {} 3 keys
          • "Copper Alloy YTD YoY"
          • "%"
          • ""
        • {} 3 keys
          • "Year"
          • ""
          • ""
        • {} 3 keys
          • "Month"
          • ""
          • ""
      • [] 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
Refined Copperintegermt
Refined Copper MoMfloat%
Refined Copper YoYfloat%
Refined Copper YTDintegermt
Refined Copper YTD YoYfloat%
Copper Concentratefloatmt
Copper Concentrate YoYfloat%
Copper Concentrate YTDfloatmt
Copper Concentrate YTD YoYfloat%
Anode Copperfloatmt
Anode Copper YoYfloat%
Anode Copper YTDfloatmt
Anode Copper YTD YoYfloat%
Scrap Copperfloatmt
Scrap Copper MoMfloat%
Scrap Copper YoYfloat%
Scrap Copper YTDfloatmt
Scrap Copper YTD YoYfloat%
Copper Materialfloatmt
Copper Material MoMfloat%
Copper Material YoYfloat%
Copper Material YTDfloatmt
Copper Material YTD YoYfloat%
Copper Alloyintegermt
Copper Alloy MoMfloat%
Copper Alloy YoYfloat%
Copper Alloy YTDintegermt
Copper Alloy YTD YoYfloat%
Yeardatetime
Monthinteger
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
Copper cathode exports
MonthlyDATAAPI
Catagory
Copper > Copper Cathode > Import & Export
Service
Data & API
Starting Date
Jan 01, 2001