Jump to

• Request
• Response

Update a Custom Event Field

put

/api/event/customEventFields/{id}

Updates the properties of the custom event field that matches the specified ID.

Request

Path Parameters

• id(required): integer
  The custom event field ID.

Supported Media Types

• application/json

Request Body - application/json ()

Root Schema : schema

Type: object

Show Source

• DefaultAsExpression: boolean
  Indicates if the default value is an expression (1) or literal (0). This field is required for all field types, but you can set it to an empty string ("") which will set its value as 0.

  Example: 1
• DefaultNull: boolean
  Indicates if the default value is null (1) or not (0). This field is required for all field types, but you can set it to an empty string ("") which will set its value as 0.

  Example: 0
• DefaultValue: string
  The custom event field default value. It can be a literal value based on the field type or an expression. This field is required for all field types, but you can set it to an empty string ("")

  Example: CURRENT_TIMESTAMP
• FieldName: string
  The custom event field name.

  Example: Example
• FieldType: string
  The custom event field data type.

  Example: TIMESTAMP
• FieldTypePrecision: string
  The maximum length of the field, in decimal precision notation. Only used for some number-type fields, such as DECIMAL. Use the format (<p>,<s>), where <p> is the total maximum number of digits, and <s> is the maximum number of that total that can appear after the decimal point.
  This field is required for all event types, but you can set it to an empty string ("") when it is not relevant.

  Example:
• FieldTypeSize: integer
  The maximum size of the field. This field is used only for some string-type fields. String-type fields such as CHAR have a maximum length that can be specified. If no value is provided, the database will determine the size.

  Example:
• IndexType: string
  The short code for the index type. For example, MUL for Standard or <None> for no index type.

  Example: MUL

{
    "type":"object",
    "properties":{
        "FieldName":{
            "type":"string",
            "description":"The custom event field name.",
            "example":"Example"
        },
        "FieldType":{
            "type":"string",
            "description":"The custom event field data type.",
            "example":"TIMESTAMP"
        },
        "FieldTypeSize":{
            "type":"integer",
            "description":"The maximum size of the field. This field is used only for some string-type fields. String-type fields such as CHAR have a maximum length that can be specified. If no value is provided, the database will determine the size.",
            "example":""
        },
        "FieldTypePrecision":{
            "type":"string",
            "description":"The maximum length of the field, in decimal precision notation. Only used for some number-type fields, such as DECIMAL. Use the format <b>(&lt;p>,&lt;s>)</b>, where <i>&lt;p></i> is the total maximum number of digits, and <i>&lt;s></i> is the maximum number of that total that can appear after the decimal point.<br>\nThis field is required for all event types, but you can set it to an empty string (<b>\"\"</b>) when it is not relevant.",
            "example":""
        },
        "IndexType":{
            "type":"string",
            "description":"The short code for the index type. For example, <b>MUL</b> for Standard or <b>&lt;None></b> for no index type.",
            "example":"MUL"
        },
        "DefaultNull":{
            "type":"boolean",
            "description":"Indicates if the default value is null (<b>1</b>) or not (<b>0</b>). This field is required for all field types, but you can set it to an empty string (<b>\"\"</b>) which will set its value as 0.",
            "example":"0"
        },
        "DefaultValue":{
            "type":"string",
            "description":"The custom event field default value. It can be a literal value based on the field type or an expression. This field is required for all field types, but you can set it to an empty string (<b>\"\"</b>)",
            "example":"CURRENT_TIMESTAMP"
        },
        "DefaultAsExpression":{
            "type":"boolean",
            "description":"Indicates if the default value is an expression (<b>1</b>) or literal (<b>0</b>). This field is required for all field types, but you can set it to an empty string (<b>\"\"</b>) which will set its value as 0.",
            "example":"1"
        }
    }
}

Back to Top

Response

Supported Media Types

• application/json

200 Response

Successful operation

Body ()

Root Schema : schema

Match All

Show Source

• object SuccessfulUpdateOperation
  The response body for a successful update operation.
• object type

{
    "allOf":[
        {
            "$ref":"#/components/schemas/SuccessfulUpdateOperation"
        },
        {
            "type":"object",
            "properties":{
                "total":{
                    "description":"The total number of results regardless of paging.",
                    "type":"integer",
                    "example":"1"
                },
                "data":{
                    "description":"The properties of the updated event.",
                    "type":"array",
                    "items":{
                        "$ref":"#/components/schemas/eventCustomEventFieldsReadByID"
                    }
                }
            }
        }
    ]
}

Nested Schema : SuccessfulUpdateOperation

Type: object

The response body for a successful update operation.

Show Source

• message: string
  The response message.

  Example: Updated record
• success: boolean
  Whether the operation was a success (true) or a failure (false).

  Example: true

{
    "description":"The response body for a successful update operation.",
    "properties":{
        "success":{
            "description":"Whether the operation was a success (<b>true</b>) or a failure (<b>false</b>).",
            "type":"boolean",
            "example":"true"
        },
        "message":{
            "description":"The response message.",
            "type":"string",
            "example":"Updated record"
        }
    },
    "type":"object"
}

Nested Schema : type

Type: object

Show Source

• data: array data
  The properties of the updated event.
• total: integer
  The total number of results regardless of paging.

  Example: 1

{
    "type":"object",
    "properties":{
        "total":{
            "description":"The total number of results regardless of paging.",
            "type":"integer",
            "example":"1"
        },
        "data":{
            "description":"The properties of the updated event.",
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/eventCustomEventFieldsReadByID"
            }
        }
    }
}

Nested Schema : data

Type: array

The properties of the updated event.

Show Source

• Array of: object eventCustomEventFieldsReadByID

{
    "description":"The properties of the updated event.",
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/eventCustomEventFieldsReadByID"
    }
}

Nested Schema : eventCustomEventFieldsReadByID

Type: object

Show Source

• DefaultAsExpression: boolean
  Indicates if the default value is an expression (1) or literal (0).

  Example: 1
• DefaultNull: boolean
  Indicates if the default value is null (1) or not (0).

  Example: 0
• DefaultValue: string
  Default value for the field. It can be a literal value based on the field type or an expression.

  Example: CURRENT_TIMESTAMP
• EventSchemaID: integer
  The custom event field ID.

  Example: 2
• FieldName: string
  The custom event field name.

  Example: Example
• FieldType: string
  The custom event field data type.

  Example: TIMESTAMP
• IndexType: string
  The short code for the index type. For example, MUL for Standard or <None> for no index type.

  Example: MUL
• IndexTypeDisplayName: string
  Human-readable name for the index type. For example, Standard.

  Example: Standard

{
    "type":"object",
    "properties":{
        "EventSchemaID":{
            "type":"integer",
            "description":"The custom event field ID.",
            "example":"2"
        },
        "FieldName":{
            "type":"string",
            "description":"The custom event field name.",
            "example":"Example"
        },
        "FieldType":{
            "type":"string",
            "description":"The custom event field data type.",
            "example":"TIMESTAMP"
        },
        "IndexTypeDisplayName":{
            "type":"string",
            "description":"Human-readable name for the index type. For example, <b>Standard</b>.",
            "example":"Standard"
        },
        "IndexType":{
            "type":"string",
            "description":"The short code for the index type. For example, <b>MUL</b> for Standard or <b>&lt;None></b> for no index type.",
            "example":"MUL"
        },
        "DefaultNull":{
            "type":"boolean",
            "description":"Indicates if the default value is null (<b>1</b>) or not (<b>0</b>).",
            "example":"0"
        },
        "DefaultValue":{
            "type":"string",
            "description":"Default value for the field. It can be a literal value based on the field type or an expression.",
            "example":"CURRENT_TIMESTAMP"
        },
        "DefaultAsExpression":{
            "type":"boolean",
            "description":"Indicates if the default value is an expression (<b>1</b>) or literal (<b>0</b>).",
            "example":"1"
        }
    }
}

Default Response

Failed operation

Body ()

Root Schema : schema

Type: object

Show Source

• errors: array errors
  The list of errors reported. Validation errors will be keyed by record field.
• message: string
  The response message.

  Example: Exception thrown
• success: boolean
  Whether the operation was a success (true) or a failure (false).

  Example: false

{
    "properties":{
        "success":{
            "description":"Whether the operation was a success (<b>true</b>) or a failure (<b>false</b>).",
            "type":"boolean",
            "example":"false"
        },
        "message":{
            "description":"The response message.",
            "type":"string",
            "example":"Exception thrown"
        },
        "errors":{
            "description":"The list of errors reported. Validation errors will be keyed by record field.",
            "type":"array",
            "items":{
                "description":"An error.",
                "type":"object"
            }
        }
    },
    "type":"object"
}

Nested Schema : errors

Type: array

The list of errors reported. Validation errors will be keyed by record field.

Show Source

• Array of: object items
  An error.

{
    "description":"The list of errors reported. Validation errors will be keyed by record field.",
    "type":"array",
    "items":{
        "description":"An error.",
        "type":"object"
    }
}

Nested Schema : items

Type: object

An error.

Back to Top