Skip to content

select-and-expand.md

Latest commit

 

History

History
31 lines (19 loc) · 954 Bytes

select-and-expand.md

File metadata and controls

31 lines (19 loc) · 954 Bytes

Select and Expand

Use $select to reduce payload size and $expand to retrieve related data.

Select Specific Columns

GET /api/data/v9.2/contacts?$select=fullname,emailaddress1,mobilephone

Expand Related Record

GET /api/data/v9.2/contacts?$select=fullname&$expand=parentcustomerid_account($select=name,accountnumber)

Combined Example

GET /api/data/v9.2/accounts?$select=name,accountnumber&$expand=primarycontactid($select=fullname,emailaddress1)

Practical Advice

  • avoid expanding too much data
  • use only the columns you need
  • test performance with realistic records
  • confirm relationship names carefully

Language Examples

For practical $select and $expand examples in code, see: