Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

View file
nameSection Properies - DB,User_JSON.xlsx

...

Expand
titleSECT
Code Block
GET POST PUT {Base URL}db/sect

    "SECT": {
        "SECTTYPE": {
            "__DESC__": "Type",
            "__TYPE__": "String"
        },
        "SECT_NAME": {
            "__DESC__": "Sect Name",
            "__TYPE__": "String"
        },
        "SECT_BEFORE": {
            "__DESC__": "Sect Before",
            "__TYPE__": {
                "SHAPE": {
                    "__DESC__": "Shape",
                    "__TYPE__": "String"
                },
                "DATATYPE": {
                    "__DESC__": "DataType",
                    "__TYPE__": "Integer"
                },

                "OFFSET_PT": {
                    "__DESC__": "Cardinal Point",
                    "__TYPE__": "String"
                },
                "OFFSET_CENTER": {
                    "__DESC__": "Offset Center",
                    "__TYPE__": "Integer"
                },
                "USER_OFFSET_REF": {
                    "__DESC__": "User Offset Ref",
                    "__TYPE__": "Integer"
                },
                "HORZ_OFFSET_OPT": {
                    "__DESC__": "Horizon offset Option",
                    "__TYPE__": "Integer"
                },
                "USERDEF_OFFSET_YI": {
                    "__DESC__": "User Offset YI",
                    "__TYPE__": "Real"
                },
                "VERT_OFFSET_OPT": {
                    "__DESC__": "Vertical Offset Option",
                    "__TYPE__": "Integer"
                },
                "USERDEF_OFFSET_ZI": {
                    "__DESC__": "User Offset ZI",
                    "__TYPE__": "Real"
                },

                "USE_SHEAR_DEFORM": {
                    "__DESC__": "Use Consider Shear Deform",
                    "__TYPE__": "Bool"
                },
                "USE_WARPING_EFFECT": {
                    "__DESC__": "Use Consider Warping Effect",
                    "__TYPE__": "Bool"
                },

                "SECT_I": {
                    "__DESC__": "Sect I",
                    "__TYPE__": {
                        "DB_NAME": {
                            "__DESC__": "DB Name",
                            "__TYPE__": "String"
                        },                                                
                        "vSIZE": {
                            "__DESC__": "Size",
                            "__TYPE__": []
                        }
                    }
                  } 
             }
          }
   }

  • Introduce Input Data Symbols

...

NO.

Name

API - Key

API - Value Type

DB/User

1

Section Number

“KEY”

🇮

🔴

2

Section Name

“SECT_NAME”

🇸

🔴

3

Section Data Type

“SECTTYPE”

🇸

🔴

Section Properties

4

"SECT_BEFORE"

🔴

Standard

  • DB Type only

“DB_NAME”

🇸

5

  • DB : 1

  • User : 2

"DATATYPE"

🇮

🔴

6

Section Shape

“SHAPE”

🇸

🔴

7

"SECT_I"

🔴

8

Section Dimension

“vSIZE”

🇷

🔴

Offset

9

Offset Direction

(default = Center-Center)

“OFFSET_PT”

🇸

🔺

10

Center Location

“OFFSET_CENTER”

🇮

🔺

11

Horizontal Offset Option

“HORZ_OFFSET_OPT”

🇮

🔺

12

Horizontal Offset Value

“USERDEF_OFFSET_YI”

🇷

🔺

13

Vertical Offset Option

“VERT_OFFSET_OPT”

🇮

🔺

14

Vertical Offset Value

“USERDEF_OFFSET_ZI”

🇷

🔺

15

User Type Offset Reference Position

“USER_OFFSET_REF”

🇮

🔺

Additional Option

16

Consider Shear Deformation

“USE_SHEAR_DEFORM”

🇧

🔺

17

Consider Warping Effect

“USE_WARPING_EFFECT”

🇧

🔺

...

Expand
titleSection Shape (“SHAPE”)

No.

Section Type

Abbreviation

1

Angle

L

2

Channel

C

3

I-Section / H-Section

H

4

T-Section

T

5

Box

B

6

Pipe

P

7

Double Angle

2L

8

Double Channel

2C

9

Solid Rectangle

SB

10

Soild Round

SR

11

Octagon

OCT

12

Solid Octagon

SOCT

13

R-Octagon

ROCT

14

Track

TRK

15

Solid Track

STRK

16

Half Track

HTRK

17

Cold Formed Channel

CC

18

Upright

UP

19

U-RIB

URIB

20

Box with Stiffener

BSTF

21

Pipe with Stiffener

PSTF

22

Inverted T-section

UDT

...

Expand
titleAPI EXAMPLE - Section (DB/User- I Section / H Section w/ Offset)
Code Block
{
 "SECT   "Assign": {
        "1100":{
            "SECT_NAME":"DB-H",
            "SECTTYPE":"DBUSER",
            "SECT_BEFORE":{
                            "DATATYPE":2,
                            "SHAPE":"H",
                            "SECT_I":{
                                      "vSIZE":[
                                              1,
                                              1,
                                              0.1,
                                              0.1,
                                              2,
                                              0.1,
                                              0.1,
                                              0.1
                                              ]
                                    },
                            "USE_SHEAR_DEFORM":false,
                            "USE_WARPING_EFFECT":false,
                            "OFFSET_PT":"LB",
                            "HORZ_OFFSET_OPT":1,
                            "USERDEF_OFFSET_YI":1.75,
                            "VERT_OFFSET_OPT":1,
                            "USERDEF_OFFSET_ZI":2.43,
                            "OFFSET_CENTER":0
                          }
            }
        }
}
Expand
titleAPI EXAMPLE - Section (DB/User - Solid Rectangle w/o Offset)
Code Block
{
    "Assign": {
        "200": {
            "SECTTYPE": "DBUSER",
            "SECT_NAME": "DB-SB",
            "SECT_BEFORE": {
                "SHAPE": "SB",
                "DATATYPE": 2,
                "SECT_I": {
                    "vSIZE": [
                        1,
                        1
                    ]
                }
            }
        }
    }
}