CONNECTIONINFO function

Created by Harry Lewis, Modified on Wed, 18 Sep at 3:39 PM by Harry Lewis

Applies to:

Velixo NX
Sage Intacct
ERP: Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Acumatica

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

TABLE OF CONTENTS

Syntax
Parameters
Examples

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