I'm trying to get an Expand query working that will pull back values for two columns on a child table that are both linked to the same Lookup Table and I can't get the query to return values for BOTH lookup cols - I can only get one back.
The tables look like this:
- Sessions: Appointments for a meeting in a specific Office. There is a Client Office Lookup column that links to the Client Office table.
- Client Office: Table with details about each office. There are two Lookup columns (Scheduling Contact and Local Contact) that link to the Client Contacts table.
- Client Contacts: Table with details (including email address) for Contacts in each Client Office.
When retrieving a Session, I need to get the email addresses for Scheduling Contact and Local Contacts for the Client Office the Session is scheduled in. I'm using an Expand Query that looks like this:
crd69_ClientOffice($select=_crd69_localschedulingcontact_value,_crd69_localcontact_value;$expand=crd69_LocalContact($select=crd69_emailaddress);$expand=crd69_LocalSchedulingContact($select=crd69_emailaddress))
This query does runs without an error, but I ONLY get the email address for the Local Scheduling Contact. Is it possible to structure the Expand query so I get the email back for both linked Client Contact records?
18
Share
Report
All responses (
Answers (
