Getting option set text from expanded entity using Web API

(0) Share

Report

Posted on by NeilN

I know I use the Prefer: odata.include-annotations="OData.Community.Display.V1.FormattedValue" to get labels from entity option sets. How do I do this for expanded entities?

Example:

10.150.150.122/.../jobopportunities$select=name,positiontitle,account_value,list_value,reportto,startdate&$filter=statecode eq 0&$expand=account($select=sector)

How do I get the sector label instead of or as well as getting the sector value?

*This post is locked for comments

All responses (4)

Answers (1)

NeilN 40 on at

Like (0)

Report

RE: Getting option set text from expanded entity using Web API

Thanks for the answer and the link. Wanted to make sure it wasn't anything that would change with different CRM deployments.
Suggested answer

Arun Vinoth 11,615 on at

Like (1)

Report

RE: Getting option set text from expanded entity using Web API

x002e is hexadecimal equivalent of . (dot)

It’s equivalent of aa_sector. The prefix & attribute name is separated like that. Or alias.attributename.

[View:https://stackoverflow.com/q/45206677/7920473]
NeilN 40 on at

Like (1)

Report

RE: Getting option set text from expanded entity using Web API

Thank you, Andrew. One question. I get key names starting with "aa_x002e_sector". I get that "aa" is an alias but where is "x002e" coming from?
Verified answer

a33ik 84,325 Most Valuable Professional on at

Like (2)

Report

RE: Getting option set text from expanded entity using Web API

Hello Neil,

You should try fetchxml approach instead - www.powerobjects.com/.../using-fetchxml-with-the-new-dynamics-web-api

In this case all labels should be returned properly.