GlobalOptionSets - filtered

(1) Share

Report

Posted on by SteRe

254

Hi all,

I would like to generate some technical documentation for a CRM system. For this I've created 2 flows. The first does some API Call to retrieve Entity Metadata and the second one calls the first as a child flow with parameters about the specific entity and prepares my output format.

What I'm missing right now is an option to do the same for used global optionsets.

It's possible to get a list of

https://<environment url>/api/data/v9.2/GlobalOptionSetDefinitions

including all options. But this gives a list of > 300 OptionSets which I clearly do not use / need in my documentation. So I thought of some filters but did not found some matching one. So I hoped there is a possibility to filter the list by those options contained in a specific solution. So I am looking for some API call providing a list of all global optionset inside a specific solution containing also the option values.

Do you have any idea / hint how to achieve this?

Best Regards

Stefan

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (1)

Report

there are several tools inside XrmToolBox to generate documentation (and limit the results to a specific solution) I suggest to use that tools instead building flows

Was this reply helpful? Yes No
SteRe 254 on at

Like (1)

Report

Sure there are some tools but they won't provide the result in a format I can directly use. Idea is to reduce manual effort as much as possible by defining all this as part of the flow.

Was this reply helpful? Yes No
SteRe 254 on at

Like (1)

Report

Hi all,

as this problem is still open and I hope to find time next week to work on this again, I would like to check if there is someone in here having a hint how to solve the issue.

To get further ideas, let me raise question again from a different point of view. Is there an option to get the content of a specific solution via API call?

Something like https://<environment url>/api/data/v9.2/solutions(<solutionid>)

Was this reply helpful? Yes No
Verified answer

SteRe 254 on at

Like (1)

Report

Dear community,

I'd like to keep you informed about my finding in case anyone else has a similar request in the future. I've solved the problem meanwhile. Here is what I did

1. Get the option sets within a specific solution

https://<org url>.dynamics.com/api/data/v9.2/solutioncomponents?$filter=_solutionid_value eq '<solution id>' and componenttype eq 9 &$select=objectid

=> replace <solution id> with GUID of the solution you would like to check for

=> componenttype eq 9 filters for option sets only

=> $select=objectid reduced the json output to minimum. The objectid is needed next step

2. Query for option set details

https://<org url>.dynamics.com/api/data/v9.2/GlobalOptionSetDefinitions(<objectid>)

=> replace <objectid> by any of the object ids found with first query

Now, in the flow / plugin you can build a loop to run the second query over all objectids found in the first to get details from the optionsets within a specific solution.

Was this reply helpful? Yes No