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 connect to all configured connections in the current workbook using the same username/password combination.
Work Offline: Lets you work on previously cached data. Workbook can't be refreshed when working in offline mode.
Comments
0 comments
Please sign in to leave a comment.