Codeunit 18122337 EOS004 AppInsights Client

Codeunit 18122337 EOS004 AppInsights Client

Provides access to Application Insights data. This client supports executing queries and also emitting events.

Methods

GetConfigurationKeys

procedure GetConfigurationKeys(): List of [Text[250]]

Parameters / Return Value

  • Returns List[Text]

GetSecretConfigurationKeys

procedure GetSecretConfigurationKeys(): List of [Text[250]]

Parameters / Return Value

  • Returns List[Text]

Initialize

procedure Initialize(ServiceConfig: Record "EOS004 Service Config.")

Parameters / Return Value

  • ServiceConfig Record "EOS004 Service Config."

PostMessage

procedure PostMessage(jo: JsonObject): Boolean

Parameters / Return Value

  • jo JsonObject

  • Returns Boolean

PostMessage

procedure PostMessage(ja: JsonArray): Boolean

Parameters / Return Value

  • ja JsonArray

  • Returns Boolean

CreateMessage

procedure CreateMessage(Timestamp: DateTime;Message: Text;Verbosity: Verbosity;Properties: Dictionary of [Text, Text]) result: JsonObject

Parameters / Return Value

  • Timestamp DateTime

  • Message Text[]

  • Verbosity Verbosity

  • Properties Dictionary[Text,Text]

  • Returns JsonObject

RunQuery

procedure RunQuery(QueryString: Text)

Parameters / Return Value

  • QueryString Text[]

ListTables

procedure ListTables(): List of [Text]

Returns the list of tables that the last executed query has returned.

Parameters / Return Value

  • Returns List[Text]

    The tables in the current result set.

BeginTableRead

procedure BeginTableRead(TableName: Text): Boolean

Loads the given table as the current table.

Parameters / Return Value

  • TableName Text[]

    The name of the table to load.

  • Returns Boolean

    Specifies whether the load was successful.

GetFields

procedure GetFields(var TempField: Record "Name/Value Buffer")

Parameters / Return Value

  • TempField Record "Name/Value Buffer"

GetValueAsText

procedure GetValueAsText(ColumnName: Text): Text

Parameters / Return Value

  • ColumnName Text[]

  • Returns Text[]

GetValueAsText

procedure GetValueAsText(ColumnName: Text; WithError: Boolean): Text

Parameters / Return Value

  • ColumnName Text[]

  • WithError Boolean

  • Returns Text[]

IsValueGuid

procedure IsValueGuid(ColumnName: Text)

Parameters / Return Value

  • ColumnName Text[]

GetValueAsGuid

procedure GetValueAsGuid(ColumnName: Text): Guid

Parameters / Return Value

  • ColumnName Text[]

  • Returns Guid

GetValueAsGuid

procedure GetValueAsGuid(ColumnName: Text; WithError: Boolean): Guid

Parameters / Return Value

  • ColumnName Text[]

  • WithError Boolean

  • Returns Guid

IsValueInt

procedure IsValueInt(ColumnName: Text)

Parameters / Return Value

  • ColumnName Text[]

GetValueAsInt

procedure GetValueAsInt(ColumnName: Text): Integer

Parameters / Return Value

  • ColumnName Text[]

  • Returns Integer

GetValueAsInt

procedure GetValueAsInt(ColumnName: Text; WithError: Boolean): Integer

Parameters / Return Value

  • ColumnName Text[]

  • WithError Boolean

  • Returns Integer

IsValueDecimal

procedure IsValueDecimal(ColumnName: Text)

Parameters / Return Value

  • ColumnName Text[]

GetValueAsDecimal

procedure GetValueAsDecimal(ColumnName: Text): Decimal

Parameters / Return Value

  • ColumnName Text[]

  • Returns Decimal

GetValueAsDecimal

procedure GetValueAsDecimal(ColumnName: Text; WithError: Boolean): Decimal

Parameters / Return Value

  • ColumnName Text[]

  • WithError Boolean

  • Returns Decimal

IsValueDateTime

procedure IsValueDateTime(ColumnName: Text)

Parameters / Return Value

  • ColumnName Text[]

GetValueAsDateTime

procedure GetValueAsDateTime(ColumnName: Text): DateTime

Parameters / Return Value

  • ColumnName Text[]

  • Returns DateTime

GetValueAsDateTime

procedure GetValueAsDateTime(ColumnName: Text; WithError: Boolean): DateTime

Parameters / Return Value

  • ColumnName Text[]

  • WithError Boolean

  • Returns DateTime

IsValueDateOnly

procedure IsValueDateOnly(ColumnName: Text)

Parameters / Return Value

  • ColumnName Text[]

GetValueAsDateOnly

procedure GetValueAsDateOnly(ColumnName: Text): Date

Parameters / Return Value

  • ColumnName Text[]

  • Returns Date

GetValueAsDateOnly

procedure GetValueAsDateOnly(ColumnName: Text; WithError: Boolean): Date

Parameters / Return Value

  • ColumnName Text[]

  • WithError Boolean

  • Returns Date

IsValueBool

procedure IsValueBool(ColumnName: Text)

Parameters / Return Value

  • ColumnName Text[]

GetValueAsBool

procedure GetValueAsBool(ColumnName: Text): Boolean

Parameters / Return Value

  • ColumnName Text[]

  • Returns Boolean

GetValueAsBool

procedure GetValueAsBool(ColumnName: Text; WithError: Boolean): Boolean

Parameters / Return Value

  • ColumnName Text[]

  • WithError Boolean

  • Returns Boolean

IsValueTime

procedure IsValueTime(ColumnName: Text)

Parameters / Return Value

  • ColumnName Text[]

GetValueAsTime

procedure GetValueAsTime(ColumnName: Text): Time

Parameters / Return Value

  • ColumnName Text[]

  • Returns Time

GetValueAsTime

procedure GetValueAsTime(ColumnName: Text; WithError: Boolean): Time

Parameters / Return Value

  • ColumnName Text[]

  • WithError Boolean

  • Returns Time

GetValueAsObject

procedure GetValueAsObject(ColumnName: Text): JsonObject

Parameters / Return Value

  • ColumnName Text[]

  • Returns JsonObject

GetValueAsObject

procedure GetValueAsObject(ColumnName: Text; WithError: Boolean): JsonObject

Parameters / Return Value

  • ColumnName Text[]

  • WithError Boolean

  • Returns JsonObject

RowCount

procedure RowCount(): Integer

Parameters / Return Value

  • Returns Integer

GetRow

procedure GetRow(NewRowIndex: Integer): Boolean

Parameters / Return Value

  • NewRowIndex Integer

  • Returns Boolean

GetNextRow

procedure GetNextRow(): Boolean

Parameters / Return Value

  • Returns Boolean

FormatDateQuery

procedure FormatDateQuery(FromDateTime: DateTime; ToDateTime: DateTime): Text

Parameters / Return Value

  • FromDateTime DateTime

  • ToDateTime DateTime

  • Returns Text[]

FormatDateQuery

procedure FormatDateQuery(FromDate: Date; ToDate: Date): Text

Parameters / Return Value

  • FromDate Date

  • ToDate Date

  • Returns Text[]

ReaderDialogIsOpen

procedure ReaderDialogIsOpen(): Boolean

Parameters / Return Value

  • Returns Boolean

DeserializeToRecordRef

procedure DeserializeToRecordRef(var RecRef: Recordref)

Deserializes the current row to the given RecordRef by trying to find a field with the same name for each column. Obsolete fields are excluded. BLOB fields will be found, but by default no deserialization will happen. You must subscribe to OnDeserializeToRecordRefSetBlobValue and handled BLOB fields explicitly. There are DeserializeToRecordRef[xxx] events available to customize deserialization.

Parameters / Return Value

  • RecRef Recordref

    The target RecordRef where field values will be written to.

OpenReaderDialog

procedure OpenReaderDialog()

StepReaderDialog

procedure StepReaderDialog()

CloseReaderDialog

procedure CloseReaderDialog()

Events

OnDeserializeToRecordRefBeforeFindFieldNo

local procedure OnDeserializeToRecordRefBeforeFindFieldNo(ColumnName: Text[250]; var RecRef: RecordRef; var FoundFieldNo: Integer)

Parameters / Return Value

  • ColumnName Text[250]

  • RecRef RecordRef

  • FoundFieldNo Integer

OnDeserializeToRecordRefBeforeSetFieldValue

local procedure OnDeserializeToRecordRefBeforeSetFieldValue(ColumnName: Text[250]; var RecRef: RecordRef; var FldRef: FieldRef; TextValue: Text; var Handled: Boolean)

Parameters / Return Value

  • ColumnName Text[250]

  • RecRef RecordRef

  • FldRef FieldRef

  • TextValue Text[]

  • Handled Boolean

OnDeserializeToRecordRefAfterSetFieldValue

local procedure OnDeserializeToRecordRefAfterSetFieldValue(ColumnName: Text[250]; var RecRef: RecordRef; var FldRef: FieldRef; TextValue: Text)

Parameters / Return Value

  • ColumnName Text[250]

  • RecRef RecordRef

  • FldRef FieldRef

  • TextValue Text[]

OnDeserializeToRecordRefSetBlobValue

local procedure OnDeserializeToRecordRefSetBlobValue(ColumnName: Text[250]; var RecRef: RecordRef; var FldRef: FieldRef; TextValue: Text; var Handled: Boolean)

Parameters / Return Value

  • ColumnName Text[250]

  • RecRef RecordRef

  • FldRef FieldRef

  • TextValue Text[]

  • Handled Boolean


EOS Labs -