CONNECTIONINFO

Overview

The CONNECTIONINFO function returns information about the connection being used to access the ERP.

Syntax

CODE

=CONNECTIONINFO(
    ConnectionName, 
    ConnectionProperty
)

Arguments

The CONNECTIONINFO function uses the following arguments:

Argument

Required/Optional

Description

Connection

Required

The name of the connection as configured in the Connection Manager

ConnectionProperty

Optional

The particular connection information to be returned.

Valid Options for Acumatica style connections:

URL or URI	returns the base URL of an Acumatica-type connection
Tenant or Company	returns the Tenant name of an Acumatica-type connection
FullURL or FullURI	returns the full URL for of an Acumatica-type connection

Valid Options for Sage Intacct connection:

Company or CompanyID

returns the Company ID of a Sage Intacct connection

If the ConnectionPart argument is left blank, the CONNECTIONINFO function will return all applicable connection parts and their values

Examples

Given these connections as defined within Velixo:

Example 1 - All connection parts

Acumatica

CODE

=CONNECTIONINFO(
    "Acumatica"
)

Description

Returns and Excel array containing all connection part titles and their values for the Acumatica connection

Result

Sage Intacct

CODE

=CONNECTIONINFO(
    "Sage"
)

Description

Returns an Excel array containing the CompanyID title and the company ID for the Sage Intacct connection

Result

Example 2 - Acumatica base URL

CODE

=CONNECTIONINFO(
    "Acumatica",
    "URL"
)

Description

Returns the base URL for the Acumatica connection

Result

Example 3 - Tenant or Company

Acumatica

CODE

=CONNECTIONINFO(
    "Acumatica",
    "Tenant"
)

Description

Returns the name of the Tenant for the Acumatica connection

Result

Sage Intacct

CODE

=CONNECTIONINFO(
    "Sage",
    "Company"
)

Description

Returns the Company ID for the Sage Intacct connection

Result

Example 4 - Full Acumatica URL

CODE

=CONNECTIONINFO(
    "Acumatica",
    "FullUrl"
)

Description

Returns the full URL for the Acumatica connection

Result