Class ExtraTableHelper

Utility class for ExtraTable helper methods.

Inheritance

object

ExtraTableHelper

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.CRM

Assembly: SoDataBase.dll

Syntax

public static class ExtraTableHelper

Fields

_disallowedReturnTypes

List of field data types that are excluded from being returned by webhooks or extra table field extraction methods. Fields with these data types are considered unsupported or potentially sensitive for external exposure, and will be filtered out when collecting extra table data for webhook payloads or API responses.

Declaration

public static readonly IReadOnlyList<FieldDataType> _disallowedReturnTypes

Field Value

Type	Description
IReadOnlyList<FieldDataType>

Remarks

The excluded types are:

dbString - Standard string fields, possibly containing large or sensitive text.
dbShort - Short string fields, often used for internal or system data.
dbStringBlob - Large binary string fields, such as file contents or blobs.

Methods

GetExtraTableFieldsFromDatabase(string, int)

Retrieves all allowed field values from a specified extra table row in the database. Only fields with data types not listed in _disallowedReturnTypes are included.

Declaration

public static Dictionary<string, object> GetExtraTableFieldsFromDatabase(string tableName, int rowId)

Parameters

Type	Name	Description
string	tableName	The name of the extra table to query.
int	rowId	The primary key of the row to retrieve from the table.

Returns

Type	Description
Dictionary<string, object>	A dictionary mapping field names to their corresponding values (as objects) for the specified row. Disallowed field types are excluded from the result.

GetExtraTableFieldsFromTableRowBase(TableRowBase)

Extracts all allowed field values from the given TableRowBase instance. Only fields whose data types are not listed in _disallowedReturnTypes are included.

Declaration

public static Dictionary<string, object> GetExtraTableFieldsFromTableRowBase(TableRowBase trb)

Parameters

Type	Name	Description
TableRowBase	trb	The TableRowBase object representing a row from an extra table.

Returns

Type	Description
Dictionary<string, object>	A dictionary mapping field names to their corresponding values (as objects) from the provided table row. Fields with disallowed data types are excluded from the result.

GetExtraTables()

Retrieves all extra tables defined in the current database dictionary that are classified as Customer Service ExtraTables.

Declaration

public static List<SoTable> GetExtraTables()

Returns

Type	Description
List<SoTable>	A list of SoTable objects representing all extra tables of kind `CSExtraTable` available in the database dictionary.