# ConnectedApplicationsByBearerToken List of all the connected applications for the logon user __Activity name:__ GetConnectedApplicationsByBearerToken List of all the connected applications for the logon user. The difference between integrations and connected applications is as follows * integrations = from lokets point of view an incomming connection where a different application connects with the loket API * connected applications = from lokets point of view an outgoing connection where a loket connects with the API of a different application This is a read-only table. The Loket.nl REST API may not support changing the data, or the Invantive UniversalSQL driver for Loket.nl REST does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Loket.nl REST API. - Catalog: `LoketNlRest` - Schema: `ConnectedApplications` ## Table Columns The columns of the table `ConnectedApplicationsByBearerToken` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `applicationProvider_description` | `string(100)` | | ☐ | | | `applicationProvider_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `createdOn` | `datetime` | Created On | ☐ | The time the integration was succesfully initiated | | `description` | `string` | Description | ☐ | Descrition of the connection | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `key` | `int32` | Key | ☐ | because users tend te use the same description for multiple connected applications we added this field as an extra unique identifier | | `lastUsedOn` | `datetime` | | ☐ | The time the integration was last active |