> Portal Navigation: > > - Append `.md` to any URL under `https://dev.wix.com/docs/` to get its markdown version. > - Pages are either content pages (article or reference text) or menu pages (a list of links to child pages). > - To get a menu page, truncate any URL to a parent path and append `.md` (e.g. `https://dev.wix.com/docs/sdk.md`, `https://dev.wix.com/docs/sdk/core-modules.md`). > - Top-level index of all portals: https://dev.wix.com/docs/llms.txt > - Full concatenated docs: https://dev.wix.com/docs/llms-full.txt # UpdateExternalDatabaseConnection # Package: externalDatabases # Namespace: ExternalDatabaseConnectionService # Method link: https://dev.wix.com/docs/api-reference/business-solutions/cms/external-databases/external-database-connection/update-external-database-connection.md ## Permission Scopes: Manage External Database Connections: SCOPE.DC-DATA.EXTERNAL-DATABASE-CONNECTIONS-MANAGE ## Introduction Updates an external database connection. > **Note:** After an external database connection is updated, it only contains the values provided in the request. All previous values are lost. --- ## REST API ### Schema ``` Method: updateExternalDatabaseConnection Description: Updates an external database connection. > **Note:** After an external database connection is updated, it only contains the values provided in the request. All previous values are lost. URL: https://www.wixapis.com/wix-data/v1/external-database-connections/{externalDatabaseConnection.name=**} Method: PUT # Note: If the parameter `a.b` is listed under required parameters, `b` is only required if `a` is also present. Required parameters: externalDatabaseConnection, externalDatabaseConnection.name Method parameters: param name: externalDatabaseConnection | type: ExternalDatabaseConnection | description: An external database connection defines a connection between an external database and a Wix site. | required: true - name: name | type: string | description: Name of the external database connection. An external database connection can connect to one or more external data collections or tables. These appear as `connectionName/dataCollectionId`. | required: true - name: endpoint | type: string | description: Base URL for accessing and managing data in the external database. For example: `https://example.com/my-external-database`. Required for STANDALONE connection type. - name: configuration | type: object | description: Settings specified to the external database connection as part of each request. These settings can relate to authentication, tenancy, or provide any other information necessary for processing a request. Their content and structure depend on the specific requirements of the external database's API. Return type: UpdateExternalDatabaseConnectionResponse - name: externalDatabaseConnection | type: ExternalDatabaseConnection | description: Details of the updated external database connection. - name: name | type: string | description: Name of the external database connection. An external database connection can connect to one or more external data collections or tables. These appear as `connectionName/dataCollectionId`. - name: endpoint | type: string | description: Base URL for accessing and managing data in the external database. For example: `https://example.com/my-external-database`. Required for STANDALONE connection type. - name: configuration | type: object | description: Settings specified to the external database connection as part of each request. These settings can relate to authentication, tenancy, or provide any other information necessary for processing a request. Their content and structure depend on the specific requirements of the external database's API. - name: connectionStatus | type: ConnectionStatus | description: Status of the external database connection. Includes whether the connection was established successfully, and if not, the reason for the failure. - name: successful | type: boolean | description: Whether the connection was established successfully. - name: causeOfFailure | type: CauseOfFailure | description: Whether and why the connection attempt failed. - enum: - NONE: No connection failure. - COMMUNICATION_FAILURE: General communication failure. - DESTINATION_HOST_UNREACHABLE: External database host is unreachable. - UNAUTHORIZED: Unauthorized to access the external database. - DESTINATION_ENDPOINT_NOT_DEFINED: `endpoint` is not set. - name: hasCollections | type: CollectionsFound | description: Whether the external database has collections. - enum: - UNKNOWN: Attempt to connect to the external database failed, so status is unknown. - YES: External database has collections. - NO: External database does not have any collections. - name: publicKey | type: string | description: Public key used to validate requests to the external database. - name: capabilities | type: Capabilities | description: Capabilities of the external database. - name: collectionModificationsSupported | type: boolean | description: Whether the external database supports creating new collections, updating the structure of existing collections, or deleting them. - name: fieldTypes | type: array | description: Field types the external database supports. Applies only when `collectionModificationsSupported` is set to `true`. - enum: TEXT, NUMBER, DATE, DATETIME, IMAGE, BOOLEAN, DOCUMENT, URL, RICH_TEXT, VIDEO, ANY, ARRAY_STRING, ARRAY_DOCUMENT, AUDIO, TIME, LANGUAGE, RICH_CONTENT, MEDIA_GALLERY, ADDRESS, PAGE_LINK, REFERENCE, MULTI_REFERENCE, OBJECT, ARRAY, LEGACY_TIME, LEGACY_BOOK, LEGACY_EXTERNAL_URL, LEGACY_BROKEN_REFERENCE, LEGACY_IMAGE, LEGACY_COLOR, LEGACY_EXTERNAL_VIDEO ``` ### Examples ### Update an external database connection ```curl curl -X PUT \ 'https://www.wixapis.com/wix-data/v1/external-database-connections/MyExternalDatabase' \ -H 'Content-Type: application/json' \ -H 'Authorization: ' \ -d '{ "externalDatabaseConnection": { "endpoint":"https://example.com/my-external-database", "configuration":{ "secretKey":"2b723306-4d74-42a2-8438-2ff40da3e6b6", "tenantId":"my-wix-site-updated", "environment":"PRODUCTION", "collections":[ "products", "categories" ] } } }' ``` --- ## JavaScript SDK ### Schema ``` Method: wixClientAdmin.externalDatabases.ExternalDatabaseConnectionService.updateExternalDatabaseConnection(name, externalDatabaseConnection) Description: Updates an external database connection. > **Note:** After an external database connection is updated, it only contains the values provided in the request. All previous values are lost. # Note: If the parameter `a.b` is listed under required parameters, `b` is only required if `a` is also present. Required parameters: externalDatabaseConnection, name Method parameters: param name: externalDatabaseConnection | type: ExternalDatabaseConnection | description: An external database connection defines a connection between an external database and a Wix site. | required: true - name: name | type: string | description: Name of the external database connection. An external database connection can connect to one or more external data collections or tables. These appear as `connectionName/dataCollectionId`. - name: endpoint | type: string | description: Base URL for accessing and managing data in the external database. For example: `https://example.com/my-external-database`. Required for STANDALONE connection type. - name: configuration | type: object | description: Settings specified to the external database connection as part of each request. These settings can relate to authentication, tenancy, or provide any other information necessary for processing a request. Their content and structure depend on the specific requirements of the external database's API. param name: name | type: string | description: Name of the external database connection. An external database connection can connect to one or more external data collections or tables. These appear as `connectionName/dataCollectionId`. | required: true Return type: PROMISE - name: name | type: string | description: Name of the external database connection. An external database connection can connect to one or more external data collections or tables. These appear as `connectionName/dataCollectionId`. - name: endpoint | type: string | description: Base URL for accessing and managing data in the external database. For example: `https://example.com/my-external-database`. Required for STANDALONE connection type. - name: configuration | type: object | description: Settings specified to the external database connection as part of each request. These settings can relate to authentication, tenancy, or provide any other information necessary for processing a request. Their content and structure depend on the specific requirements of the external database's API. - name: connectionStatus | type: ConnectionStatus | description: Status of the external database connection. Includes whether the connection was established successfully, and if not, the reason for the failure. - name: successful | type: boolean | description: Whether the connection was established successfully. - name: causeOfFailure | type: CauseOfFailure | description: Whether and why the connection attempt failed. - enum: - NONE: No connection failure. - COMMUNICATION_FAILURE: General communication failure. - DESTINATION_HOST_UNREACHABLE: External database host is unreachable. - UNAUTHORIZED: Unauthorized to access the external database. - DESTINATION_ENDPOINT_NOT_DEFINED: `endpoint` is not set. - name: hasCollections | type: CollectionsFound | description: Whether the external database has collections. - enum: - UNKNOWN: Attempt to connect to the external database failed, so status is unknown. - YES: External database has collections. - NO: External database does not have any collections. - name: publicKey | type: string | description: Public key used to validate requests to the external database. - name: capabilities | type: Capabilities | description: Capabilities of the external database. - name: collectionModificationsSupported | type: boolean | description: Whether the external database supports creating new collections, updating the structure of existing collections, or deleting them. - name: fieldTypes | type: array | description: Field types the external database supports. Applies only when `collectionModificationsSupported` is set to `true`. - enum: TEXT, NUMBER, DATE, DATETIME, IMAGE, BOOLEAN, DOCUMENT, URL, RICH_TEXT, VIDEO, ANY, ARRAY_STRING, ARRAY_DOCUMENT, AUDIO, TIME, LANGUAGE, RICH_CONTENT, MEDIA_GALLERY, ADDRESS, PAGE_LINK, REFERENCE, MULTI_REFERENCE, OBJECT, ARRAY, LEGACY_TIME, LEGACY_BOOK, LEGACY_EXTERNAL_URL, LEGACY_BROKEN_REFERENCE, LEGACY_IMAGE, LEGACY_COLOR, LEGACY_EXTERNAL_VIDEO ``` ### Examples ### updateExternalDatabaseConnection ```javascript import { externalDatabaseConnections } from '@wix/data'; async function updateExternalDatabaseConnection(name,externalDatabaseConnection) { const response = await externalDatabaseConnections.updateExternalDatabaseConnection(name,externalDatabaseConnection); }; ``` ### updateExternalDatabaseConnection (with elevated permissions) ```javascript import { externalDatabaseConnections } from '@wix/data'; import { auth } from '@wix/essentials'; async function myUpdateExternalDatabaseConnectionMethod(name,externalDatabaseConnection) { const elevatedUpdateExternalDatabaseConnection = auth.elevate(externalDatabaseConnections.updateExternalDatabaseConnection); const response = await elevatedUpdateExternalDatabaseConnection(name,externalDatabaseConnection); } ``` ### updateExternalDatabaseConnection (self-hosted) Self-hosted SDK calls require you to [create a client](https://dev.wix.com/docs/sdk/articles/work-with-the-sdk/about-the-wix-client.md). ```javascript import { createClient } from '@wix/sdk'; import { externalDatabaseConnections } from '@wix/data'; // Import the auth strategy for the relevant access type // Import the relevant host module if needed const myWixClient = createClient ({ modules: { externalDatabaseConnections }, // Include the auth strategy and host as relevant }); async function updateExternalDatabaseConnection(name,externalDatabaseConnection) { const response = await myWixClient.externalDatabaseConnections.updateExternalDatabaseConnection(name,externalDatabaseConnection); }; ``` ---