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>Aluminum>Terminal consumption>Enduser Data>Aluminium wire and cable tender invitation by State Grid>
Aluminium wire and cable tender invitation by State Grid
MonthlyDATAAPI
Service
Data & API
Starting Date
Mar 01, 2015
Catagory
Aluminum > Terminal consumption > Enduser Data
URL
https://dataapi.smm.cn/GetDataEn/al_aluminium_wire_and_cable_tender_invitation_by_state_grid
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
      • [] 21 items
        • {} 3 keys
          • "Date"
          • ""
          • ""
        • {} 3 keys
          • "Power transmission lines of State Grid|Total"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power transmission lines of State Grid|Steel-core high conductivity aluminium strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power transmission lines of State Grid|Steel-core aluminium strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power transmission lines of State Grid|Aluminium-clad steel strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power transmission lines of State Grid|Aluminium-clad steel-core aluminium strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power transmission lines of State Grid|Aluminium alloy strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power transmission lines of State Grid|Aluminium alloy aluminium-core strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Ultra-high voltage projects of State Grid|Steel-core aluminium strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Ultra-high voltage projects of State Grid|Aluminium alloy aluminium-core strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "steel-core heat resistant aluminium alloy stranded wire"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Steel-core aluminium alloy strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power distribution lines|Steel clad aluminium strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power distribution lines|Steel-core aluminium strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power distribution lines|Steel clad aluminium strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power distribution lines|Aluminium strands"
          • "10,000 mt"
          • ""
        • {} 3 keys
          • "Power distribution lines|Overhead insulated conductor"
          • "10,000 km"
          • ""
        • {} 3 keys
          • "Power distribution lines|Cluster insulated conductor"
          • "10,000 km"
          • ""
        • {} 3 keys
          • "Power cable"
          • "10,000 km"
          • ""
        • {} 3 keys
          • "Low-voltage power cable"
          • "10,000 km"
          • ""
        • {} 3 keys
          • "steel-core heat resistant aluminium alloy stranded wire"
          • "10,000 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
Power transmission lines of State Grid|Totalfloat10,000 mt
Power transmission lines of State Grid|Steel-core high conductivity aluminium strandsfloat10,000 mt
Power transmission lines of State Grid|Steel-core aluminium strandsfloat10,000 mt
Power transmission lines of State Grid|Aluminium-clad steel strandsfloat10,000 mt
Power transmission lines of State Grid|Aluminium-clad steel-core aluminium strandsfloat10,000 mt
Power transmission lines of State Grid|Aluminium alloy strandsfloat10,000 mt
Power transmission lines of State Grid|Aluminium alloy aluminium-core strandsfloat10,000 mt
Ultra-high voltage projects of State Grid|Steel-core aluminium strandsfloat10,000 mt
Ultra-high voltage projects of State Grid|Aluminium alloy aluminium-core strandsfloat10,000 mt
steel-core heat resistant aluminium alloy stranded wirefloat10,000 mt
Steel-core aluminium alloy strandsfloat10,000 mt
Power distribution lines|Steel clad aluminium strandsfloat10,000 mt
Power distribution lines|Steel-core aluminium strandsfloat10,000 mt
Power distribution lines|Steel clad aluminium strandsfloat10,000 mt
Power distribution lines|Aluminium strandsfloat10,000 mt
Power distribution lines|Overhead insulated conductorfloat10,000 km
Power distribution lines|Cluster insulated conductorfloat10,000 km
Power cablefloat10,000 km
Low-voltage power cablefloat10,000 km
steel-core heat resistant aluminium alloy stranded wirefloat10,000 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
Aluminium wire and cable tender invitation by State Grid
MonthlyDATAAPI
Catagory
Aluminum > Terminal consumption > Enduser Data
Service
Data & API
Starting Date
Mar 01, 2015