Query Data in Data Cloud

Learn how to programmatically query your data in Data Cloud using various REST APIs.

  1. Get Started with Querying Data Cloud Data

    • Learn about apps, APIs, libraries, and SQL for querying data
    • Understand the basics of data extraction

  2. Salesforce Help: API Guidelines and Limits

  3. Query Services Status Codes

    • Reference status codes for Query API
    • Troubleshoot common issues

  • Query API

    • Supports Data Cloud SQL
    • Available through the Data Cloud Connect REST API and Apex
    • Optimized for all Data Cloud use cases
    • Supports data streams, profile, engagement, and unified data model objects

  • Profile API

    • Search customer profile information
    • Access profile data model objects

  • Metadata API

    • Retrieve metadata about all entities
    • Access information about Calculated Insights, Engagement, Profile, and other entities
    • View relationships between objects and key qualifier fields

  • Calculated Insights API

    • Query Calculated Insights with SQL dimensions and measures
    • Extract insights from your data

  • Universal ID Lookup

    • Retrieve all individual records associated with a unified record
    • Query across different data sources

  • Data Graph API

    • Retrieve data about the connections between objects in a data graph
    • Understand data graph concepts and usage