Query Unified Record ID

The Universal ID Lookup API provides a powerful way to retrieve all individual records associated with a unified record across different data sources. This API allows you to find all the individual IDs for a person across various systems, such as retail sales, loyalty programs, and mobile identity platforms.

Key Features 

• Cross-System ID Lookup: Retrieve all individual records linked to a unified record
• Data Source Integration: Query across different data sources using a single ID
• Identity Resolution: Link customer records from multiple systems
• Unified Profile Access: Access complete customer profiles across platforms

Prerequisites 

• Data Cloud licenses must be provisioned for your org
• Users must have appropriate roles and permissions assigned
• Authentication requires a valid access token
• External Client App must be properly configured

API Limits 

• Maximum of 50 fields can be retrieved per request
• Default return limit is 49,999 rows
• Only AND logical operator and equality comparator are supported
• No limit on the number of filters in a query
• Date/time fields must use the format: YYYY-MM-DD HH:MM:SS

Available Endpoints 

• GET /api/v1/universalIdLookup/{entity_name}/{DataSourceIdc}/{DataSourceObjectIdc}/{SourceRecordId__c}

  Retrieve all individual records associated with a unified record across all data sources.

Use Cases 

1. Customer Profile Consolidation

   • Find all customer records across different systems
   • Link customer data from multiple sources
   • Create a unified view of customer information

2. Data Integration

   • Connect customer data from various platforms
   • Maintain consistent customer identification
   • Enable cross-system data analysis

3. Identity Resolution

   • Resolve customer identities across systems
   • Link anonymous and known customer profiles
   • Create a single source of truth for customer data

Notes 

• The API follows REST standards for consistency and ease of use
• All responses are in JSON format
• Error responses include detailed error messages
• The API supports both primary and secondary key lookups
• You must explicitly specify fields to retrieve more than 10 fields

Additional Resources 

• User Roles and Permission Sets in Data 360
• Set Up an External Client App
• Getting Started with Data Cloud API
• API Limits for Profile, Query, and Calculated Insights