Salesforce Connect: Can't Sync the Schema Metadata for Your External System – Check That the Schema Metadata Is Valid. Error Code: Null

Salesforce Connect: Can't Sync the Schema Metadata for Your External System – Check That the Schema Metadata Is Valid. Error Code: Null

This error occurs because the object used in your endpoint does not have a primary key column. Salesforce requires a primary key for external objects, which is why you encounter an error when validating and syncing your External Data Source in Salesforce. At this stage, External Objects are being created.
  • If the object is a table (rather than a database view), add a primary key column to the table in the database and then re-add it to the endpoint model.
  • If the object is a database view, or if adding a primary key column is not possible, you can manually designate any column as the Entity Key directly in the endpoint model.

    • Related Articles

    • Salesforce Audit Fields: Quick Insertion Guide

      To use audit fields for the INSERT operation in Skyvia, please enable the 'Create Audit Fields' permission in your Salesforce instance. More details can be found here. Below are the steps to enable the permission: Go to Setup → User Interface. Enable ...

    • Salesforce Report exports only 2000 records

      Skyvia integrates with Salesforce via its API, inheriting both its features and limitations. One key limitation is the Run Report restriction, which limits data extraction to the first 2,000 rows of a report. For more details on this limitation, we ...

    • Connect: Plan Does Not Support Secure Endpoints

      Secure endpoints (private endpoints with IP restrictions and user accounts) are available only in the Standard pricing plan. Public endpoints are the only option available in the Free and Basic pricing plans. If your endpoint is invalid or uses ...

    • MySQL: Resolving "Lost connection to MySQL server during query" Error

      To resolve the "Lost connection to MySQL server during query" error, please follow the steps below: Increase the "Command Timeout" value for your MySQL connection: Go to the Connections page and select your MySQL connection. Click Edit. In the ...

    • Understanding Records in Skyvia Data Integration

      1.1 Understanding Records in Skyvia Data Integration A record in Data Integration represents a single row in a database table. Every integration process—Import, Replication, Export, Synchronization, etc —handles individual records. Records also serve ...