WebhookDataSourceColumnInput

The fields for specifying a column in an Webhook Data Source's table.

fields

• name required String

  The column name. It has to be unique within a Table.

• jsonProperty required String

  The JSON property that the column will be derived from. For example, if you POST a JSON event like this:

  { "greeting": { "message": "hello, world" } }
  

  Then you can use the JSON property "greeting.message" to extract "hello, world" to a column.

• type required ColumnType

  The column type.

  The Propel data types.

  • BOOLEAN

    True or false.

  • STRING

    A variable-length string.

  • FLOAT

    A 32-bit signed double-precision floating point number.

  • DOUBLE

    A 64-bit signed double-precision floating point number.

  • INT8

    An 8-bit signed integer, with a minimum value of -2⁷ and a maximum value of 2⁷-1.

  • INT16

    A 16-bit signed integer, with a minimum value of -2¹⁵ and a maximum value of 2¹⁵-1.

  • INT32

    A 32-bit signed integer, with a minimum value of -2³¹ and a maximum value of 2³¹-1.

  • INT64

    A 64-bit signed integer, with a minimum value of -2⁶³ and a maximum value of 2⁶³-1.

  • DATE

    A date without a timestamp. For example, "YYYY-MM-DD".

  • TIMESTAMP

    A date with a timestamp. For example, "yyy-MM-dd HH:mm:ss".

  • JSON

    A JavaScript Object Notation (JSON) document.

• nullable required Boolean

  Whether the column's type is nullable or not.