getting-datacloud-schema

A workflow for retrieving Data Lake Object (DLO) and Data Model Object (DMO) schema information from Salesforce Data Cloud using the SSOT REST API. It can list all DLOs or DMOs in an org or retrieve the detailed schema for a specific object, and it is appropriate when a user wants to see available DLOs or DMOs, inspect field definitions and data types, explore Data Cloud structures, or understand field metadata. It takes an org alias and an optional DLO or DMO name as parameters.

Prerequisites are the SF CLI installed and authenticated to the target org, Data Cloud enabled, and appropriate Data Cloud permissions. Execution proceeds in steps: discover the connected org with sf org list and extract its alias, validate authentication with sf org display targeting the org as JSON and prompt for sf org login web if needed, then run bundled Python scripts. The scripts live in a scripts subdirectory of the skill directory and must be invoked by absolute path; get_dlo_schema.py lists DLOs or fetches one DLO schema, and get_dmo_schema.py does the same for DMOs. Results are presented in a friendly format showing names, labels, categories, IDs, and per-field details such as data type, primary-key indicator, and nullable status, highlighting custom fields and record counts where available.

The documentation lists the REST endpoints used against API version v64.0, including the data-lake-objects and data-model-objects collection and item endpoints, with example JSON response structures. Error handling covers an org not being connected, a DLO or DMO not being found, HTTP 403 permission issues, and API version mismatches, each with a suggested resolution. Worked examples show listing objects, fetching a single object schema, and exploring then drilling into a named object, and a final step suggests follow-up actions such as querying data, creating calculated insights, building segments, setting up data streams, or creating DMO mappings.