Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

how to query choice sets/option sets/global sets values

Posted on by 45

I need to run a one time export of 40 tables from Dataverse and using Azure Data Factory. In this export need to include the choice sets/option sets/global sets from these tables but there is no point in turning on change tracking just for this, therefore cannot create link to synapse and get the json files (so Access Dataverse choice labels directly from Azure Synapse Link for Dataverse - Power Apps | Microsoft Docs  DOES NOT work for me). I need another solution. 
Since ADF is using FetchXML, would help to be able to get these values in fetchXML, but not able to. Ex below: for account table the response does not return any values below (just the accountid)

<fetch mapping="logical" count="10" version="1.0" >
<entity name="account" >
<attribute name="accountclassificationcodename" />
<attribute name="accountratingcodename" />
<attribute name="address1_addresstypecodename" />
<attribute name="address1_freighttermscodename" />
<attribute name="address1_shippingmethodcodename" />
<attribute name="address2_addresstypecodename" />
<attribute name="address2_freighttermscodename" />
<attribute name="address2_shippingmethodcodename" />
</entity>
</fetch>

How else can I query the values for the  choice sets/option sets/global sets from all these tables that I need to get in this one time 40 tables data export?

Many thanks,

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: how to query choice sets/option sets/global sets values

    Hi,

    Please check below article on how to retrieve optionset text .

    docs.microsoft.com/.../get-dynamics-365-optionset-labels-in-copy-activity.html

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans