Hi!
I spent 2-3 hours yesterday scratching my head and wondering why this API query would not work.
http://....dynamics.com/api/data/v9.1/st_intakes?$filter=st_name eq 'IN00000009'&$select=st_name&$top=3&$expand=st_nameofthechildyouth
This field is clearly listed as a related entity. I checked the field definition in Settings/customization and the spelling was correct.

I also tried the same query but replacing the expanded field with &$expand=_st_nameofthechildyouth_value
no luck either.
Then I used the XRM toolbox 'Attribute Manager' module and discovered the field is actually spelled 'st_NameoftheChildYouth'. So I tried the query again and long and behold...
http://....dynamics.com/api/data/v9.1/st_intakes?$filter=st_name eq 'IN00000009'&$select=st_name&$top=3&$expand=st_NameoftheChildYouth
worked! Alright. I figured out the field is case sensitive. But my question is: Where....in CRM 'Settings/customization', looking at the field list for my Entity, can I see the exact case spelling of this field? Currently when I look at it, it is spelled in lowercase.
*This post is locked for comments
I have the same question (0)