China Copper Industry API: cu_planned_and_actual_investment_by_the_state_grid_and_china_southern_power_grid(Annually)

SMM DatabaseMy Data & API

Non-Ferrous Metals

Copper Aluminum Lead Zinc Nickel Tin earth-i

Minor Metals

Manganese Silicon Antimony Tungsten Indium Gallium Germanium Bismuth Selenium Tellurium Cadmium Chromium Arsenic Magnesium Calcium Potassium Sodium Beryllium Titanium Zirconium Niobium Vanadium Rhenium Molybdenum Tantalum

Precious Metals

Gold Silver Platinum Palladium Ruthenium Rhodium Iridium

Cobalt Lithium

Rare Earth

Lanthanum Cerium Praseodymium Neodymium Samarium Europium Gadolinium Terbium Dysprosium Erbium Yttrium Holmium Rare Earth

E-mail：service.en@smm.cn

Phone：+86 - (021)5155 0306

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

Planned and actual investment by the State Grid and China Southern Power Grid

AnnuallyDATAAPI

Service

Data & API

Starting Date

Jan 01, 2009

Catagory

Copper > Downstream > Power

Data API

Sample code

URL

https://dataapi.smm.cn/GetDataEn/cu_planned_and_actual_investment_by_the_state_grid_and_china_southern_power_grid

Supported Formats

JSON

HTTP Request Method

POST

Request Parameters

Names	Requires	Types of Range	Descriptions
token	True	String	This parameter is required when using OAuth.You will get the access_token after oauth authorization.token
sdatetime	False	String	Start Date,The default value is A Year ago, e.g.,2018-01-01
edatetime	False	String	End Date,The default value is Today, e.g.,2018-08-13

Response

- Code:200
- Msg:"OK"
- ▶
  Data:{} 3 keys
  - Status:0
  - ▶
    Field:[] 6 items
    - ▶
      0:{} 3 keys
      - Name:"Date"
      - Unit:""
      - Info:""
    - ▶
      1:{} 3 keys
      - Name:"State Grid’s planned investment (100 million yuan)"
      - Unit:""
      - Info:""
    - ▶
      2:{} 3 keys
      - Name:"State Grid’s actual investment (100 million yuan)"
      - Unit:""
      - Info:""
    - ▶
      3:{} 3 keys
      - Name:"Year-on-year growth of State Grid’s actual investment (%)"
      - Unit:""
      - Info:""
    - ▶
      4:{} 3 keys
      - Name:"CSG’s actual investment (100 million yuan)"
      - Unit:""
      - Info:""
    - ▶
      5:{} 3 keys
      - Name:"Year-on-year growth of CSG’s actual investment (%)"
      - Unit:""
      - Info:""
  - ▶
    Content:[] 2 items
    - ▶
      0:[] 4 items
      - 0:"2016-05-27"
      - 1:"97.5"
      - 2:"9.8"
      - 3:"……"
    - ▶
      1:[] 4 items
      - 0:"2016-05-27"
      - 1:"97.5"
      - 2:"9.8"
      - 3:"……"

Returned Parameters Description

Type	Status	Descriptions
Code	Request Status	“200” means normal, other status codes are shown in schedule 1
Msg	Return Description	“OK” indicates normal. Other states are shown in schedule 1
Data	Return Result	Return the corresponding data according to the requested parameters
Data.Status	Permission Status	“0” means no permission,” 1” means permission
Data.Field	1D Structure Array	Return data header description
Data.Field.Name	Name	Indicates the name corresponding to the column data
Data.Field.Unit	Unit	The unit corresponding to the column data
Data.Field.Info	Description	Description of the column data
Content	2D data	Return all eligible data

Returned Field Description

Field Name	Fied Type	Unit	Descriptions
Date	datetime
State Grid’s planned investment (100 million yuan)	integer
State Grid’s actual investment (100 million yuan)	float
Year-on-year growth of State Grid’s actual investment (%)	float
CSG’s actual investment (100 million yuan)	integer
Year-on-year growth of CSG’s actual investment (%)	float

How to get token

URL

https://platform.smm.cn/usercenter/auth