CONNECTIONINFO

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

Syntax

CONNECTIONINFO(ConnectionName, ConnectionPart)

Parameters

The CONNECTIONINFO function uses the following parameters:

Parameter

Required/Optional

Description

Connection

Required

The name of the connection as configured in the Connection Manager

ConnectionPart

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

Note: If the ConnectionPart parameter 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

=CONNECTIONINFO("Acumatica")

Description

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

Result

Sage Intacct

=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

=CONNECTIONINFO("Acumatica","URL")

Description

Returns the base URL for the Acumatica connection

Result

Example 3 - Tenant or Company

Acumatica

=CONNECTIONINFO("Acumatica","Tenant")

Description

Returns the name of the Tenant for the Acumatica connection

Result

Sage Intacct

=CONNECTIONINFO("Sage","Company")

Description

Returns the Company ID for the Sage Intacct connection

Result

Example 4 - Full Acumatica URL

=CONNECTIONINFO("Acumatica","FullUrl")

Description

Returns the full URL for the Acumatica connection

Result