Query Data in Data Cloud

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

undefined

  • Query API V2

    • Supports ANSI standard SQL
    • Returns results as an array of records
    • Ideal for large volume data reads and external application integration
    • Supports data streams, profile, engagement, and unified data model objects

  • Query API V1

    • Synchronous API for data extraction
    • Supports pagination with limit and offset
    • Suitable for browser-based clients and interactive querying

  • Profile API

    • Look up and search customer profile information
    • Integrate with external web or mobile apps
    • 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
    • Apply optional filters
    • Extract insights from your data

  • Universal ID Lookup

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

  • DataGraph Overview

    • Learn about DataGraph APIs
    • Understand data graph concepts and usage

  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. API Limits

    • Review limits for Profile, Query, and Calculated Insights APIs
    • Understand rate limits and best practices

  3. Query Services Status Codes

    • Reference status codes for Query API V1 and V2
    • Troubleshoot common issues