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

DATAAPI
Service
Data & API
Starting Date
-
Catagory
undefinedundefinedundefined
URL
https://dataapi.smm.cn/GetDataEn/pb-lme
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
      • [] 0 items
        • [] 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

    No Data

    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
    DATAAPI
    Catagory
    undefinedundefinedundefined
    Service
    Data & API
    Starting Date
    -