Connection Editor

Use to Add or Edit connection.

Name: Connection's friendly name. It needs to be a unique name. You will use this name later when building formulas to refer to it.

Url: ERP website url. This need to be the full url, including protocol (http or https) and sub folder (if applicable). ex.: https://mycompany.com/erp

Tenant: The tenant you want to connect to.

Username/Password: ERP's username and password with sufficient access rights.

Save Password: Whether or not to save password. If you decide to save the password for a connection, please be aware that it is not actually saved inside the spreadsheet, but instead inside your user profile, encrypted with the Windows Data Protection API (DPAPI).

Connect: Attempt to connect and saves the connection if successful. Hold SHIFT and click Connect to attempt connecting to all configured connection with same username/password combination. 

Work Offline: Let's you work on previously cached data. Workbook can't be refreshed when working in offline mode.