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]

InitializeForPost

procedure InitializeForPost(ConnectionString: Text)

Enables log posting to Application Insights.using the given connection string.

Parameters / Return Value

ConnectionString Text[]
The connection string to use.

Initialize

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

Initializes the client with the given service configuration.

Parameters / Return Value

ServiceConfig Record "EOS004 Service Config."
The service configuration.

PostMessage

procedure PostMessage(jo: JsonObject): Boolean

Post a message to Application Insights. Use ‘CreateMessage’ to create a message to be posted.

Parameters / Return Value

jo JsonObject
The message to post.
Returns Boolean
True if the message was posted successfully.

PostMessage

procedure PostMessage(ja: JsonArray): Boolean

Post multiple messages to Application Insights. Use ‘CreateMessage’ to create a message to be posted.

Parameters / Return Value

ja JsonArray
The messages to post.
Returns Boolean
True if the message was posted successfully.

CreateMessage

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

Create a message to be posted to Application Insights.

Parameters / Return Value

Timestamp DateTime
The timestamp of the message.
Message Text[]
The message to post.
Verbosity Verbosity
The verbosity of the message.
Properties Dictionary[Text,Text]
Additional properties to include in the message.
Returns JsonObject
The message as a JsonObject.

RunQuery

procedure RunQuery(QueryString: Text)

Executes the given query against Application Insights. This is a TryFunction.

Parameters / Return Value

QueryString Text[]
The query to execute.

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")

Returns the list of columns that the current table has.

Parameters / Return Value

TempField Record "Name/Value Buffer"
The list of columns.

GetValueAsText

procedure GetValueAsText(ColumnName: Text): Text

Returns the value of the given column as Text.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
Returns Text[]
The value.

GetValueAsText

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

Returns the value of the given column as Text.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
WithError Boolean
Specifies whether to throw an error if the column does not exist.
Returns Text[]
The value.

IsValueGuid

procedure IsValueGuid(ColumnName: Text)

Checks if a column value is a valid GUID.

Parameters / Return Value

ColumnName Text[]
The name of the column to check.

GetValueAsGuid

procedure GetValueAsGuid(ColumnName: Text): Guid

Returns the value of the given column as Guid.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
Returns Guid
The value.

GetValueAsGuid

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

Returns the value of the given column as Guid.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
WithError Boolean
Specifies whether to throw an error if the column does not exist.
Returns Guid
The value.

IsValueInt

procedure IsValueInt(ColumnName: Text)

Checks if a column value is a valid Integer.

Parameters / Return Value

ColumnName Text[]
The name of the column to check.

GetValueAsInt

procedure GetValueAsInt(ColumnName: Text): Integer

Returns the value of the given column as Integer.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
Returns Integer
The value.

GetValueAsInt

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

Returns the value of the given column as Integer.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
WithError Boolean
Specifies whether to throw an error if the column does not exist.
Returns Integer
The value.

IsValueDecimal

procedure IsValueDecimal(ColumnName: Text)

Checks if a column value is a valid Decimal.

Parameters / Return Value

ColumnName Text[]
The name of the column to check.

GetValueAsDecimal

procedure GetValueAsDecimal(ColumnName: Text): Decimal

Returns the value of the given column as Decimal.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
Returns Decimal
The value.

GetValueAsDecimal

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

Returns the value of the given column as Decimal.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
WithError Boolean
Specifies whether to throw an error if the column does not exist.
Returns Decimal
The value.

IsValueDateTime

procedure IsValueDateTime(ColumnName: Text)

Checks if a column value is a valid DateTime.

Parameters / Return Value

ColumnName Text[]
The name of the column to check.

GetValueAsDateTime

procedure GetValueAsDateTime(ColumnName: Text): DateTime

Returns the value of the given column as DateTime.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
Returns DateTime
The value.

GetValueAsDateTime

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

Returns the value of the given column as DateTime.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
WithError Boolean
Specifies whether to throw an error if the column does not exist.
Returns DateTime
The value.

IsValueDateOnly

procedure IsValueDateOnly(ColumnName: Text)

Checks if a column value is a valid Date.

Parameters / Return Value

ColumnName Text[]
The name of the column to check.

GetValueAsDateOnly

procedure GetValueAsDateOnly(ColumnName: Text): Date

Returns the value of the given column as Date.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
Returns Date
The value.

GetValueAsDateOnly

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

Returns the value of the given column as Date.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
WithError Boolean
Specifies whether to throw an error if the column does not exist.
Returns Date
The value.

IsValueBool

procedure IsValueBool(ColumnName: Text)

Checks if a column value is a valid Boolean.

Parameters / Return Value

ColumnName Text[]
The name of the column to check.

GetValueAsBool

procedure GetValueAsBool(ColumnName: Text): Boolean

Returns the value of the given column as Boolean.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
Returns Boolean
The value.

GetValueAsBool

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

Returns the value of the given column as Boolean.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
WithError Boolean
Specifies whether to throw an error if the column does not exist.
Returns Boolean
The value.

IsValueTime

procedure IsValueTime(ColumnName: Text)

Checks if a column value is a valid Time.

Parameters / Return Value

ColumnName Text[]
The name of the column to check.

GetValueAsTime

procedure GetValueAsTime(ColumnName: Text): Time

Returns the value of the given column as Time.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
Returns Time
The value.

GetValueAsTime

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

Returns the value of the given column as Time.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
WithError Boolean
Specifies whether to throw an error if the column does not exist.
Returns Time
The value.

GetValueAsObject

procedure GetValueAsObject(ColumnName: Text): JsonObject

Returns the value of the given column as JsonObject.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
Returns JsonObject
The value.

GetValueAsObject

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

Returns the value of the given column as JsonObject.

Parameters / Return Value

ColumnName Text[]
The name of the column to get.
WithError Boolean
Specifies whether to throw an error if the column does not exist.
Returns JsonObject
The value.

RowCount

procedure RowCount(): Integer

Returns the number of rows in the current result set.

Parameters / Return Value

Returns Integer
The number of rows.

GetRow

procedure GetRow(NewRowIndex: Integer): Boolean

Loads the row with the given index as the current row.

Parameters / Return Value

NewRowIndex Integer
The index of the row to load.
Returns Boolean
True if the row was loaded successfully.

GetNextRow

procedure GetNextRow(): Boolean

Loads the next row as the current row.

Parameters / Return Value

Returns Boolean
True if the row was loaded successfully.

FormatDateQuery

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

Formats a date query for the given date range.

Parameters / Return Value

FromDateTime DateTime
The start date and time.
ToDateTime DateTime
The end date and time.
Returns Text[]
The formatted date query.

FormatDateQuery

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

Formats a date query for the given date range (from 00:00 to 23:59).

Parameters / Return Value

FromDate Date
The start date and time.
ToDate Date
The end date and time.
Returns Text[]
The formatted date query.

ReaderDialogIsOpen

procedure ReaderDialogIsOpen(): Boolean

Returns true if the reader dialog is open.

Parameters / Return Value

Returns Boolean
True if the reader dialog is open, false otherwise.

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()

Opens a read status dialog.

StepReaderDialog

procedure StepReaderDialog()

Steps the read status dialog. This is called automatically when the dialog is open.

CloseReaderDialog

procedure CloseReaderDialog()

Closes the read status dialog.

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

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.

EOS Labs - 09.05.2025