Customer experience | Sales, Customer Insights,...

TABLE ACCES CRM - INFORMATION Field jav_leaddepartementcode (POWERBI)

(0) Share

Report

Posted on by AA_1995

hello

For a Pbi connexion I need to find the source Table for : VALUE

Field : jav_leaddepartementcode

The information : value !!

Thank's for your help

Best regards

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

Francisco Murtinheira Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hello,

Since you seem to be using a global option set on your field, you can find it's definition in the following API, which contains a "options" attribute with all the details about the values and labels of the option set.For example in the image below I query an out of the box global option set for it's definition.

/api/data/v9.1/GlobalOptionSetDefinitions

Hope this helps.

Was this reply helpful? Yes No
AA_1995 35 on at

Like (0)

Report
Copy link

Link copied!

Hello

Thank's a lot

Best regards

Was this reply helpful? Yes No
AA_1995 35 on at

Like (0)

Report
Copy link

Link copied!

Hello i have everything i want with the following link: XXXX.api.crm4.dynamics.com/.../ but I can't find the info that is here Could you help me please cordially

Was this reply helpful? Yes No
Francisco Murtinheira Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello, seems like you are using an option set field but with a local option set this time.
For that you can find it with a more advanced query, see the example below. You will need to change the attribute id and logical name of the entity to fit your scenario.

/api/data/v9.1/EntityDefinitions(LogicalName='new_a')/Attributes(bbc0aae8-9a5c-eb11-a812-000d3ab1c99f)/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet

Was this reply helpful? Yes No
AA_1995 35 on at

Like (0)

Report
Copy link

Link copied!

Hello

it's perfect

Thank's a lot for your very quick answer

Best regards

Was this reply helpful? Yes No
AA_1995 35 on at

Like (0)

Report
Copy link

Link copied!

Hello

Thank's a lot for your very quick answer.

Best regards

Was this reply helpful? Yes No
AA_1995 35 on at

Like (0)

Report
Copy link

Link copied!

hello

https://xxxxx.api.crm4.dynamics.com/api/data/v9.1/EntityDefinitions(LogicalName='new_agence')/Attributes(9bc06e2b-727f-e811-a846-000d3a2900a9)/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet

logical name : new_agence

Attributes : 9bc06e2b-727f-e811-a846-000d3a2900a9

see pictures

But I have this error ??

New_Agence is not in the listing of LOGICAL NAME !!

XXXX.api.crm4.dynamics.com/.../EntityDefinitions() eq true

or

XXXX.api.crm4.dynamics.com/.../EntityDefinitions()

Do you have a idee please ?

Thank's

Best Regards

Was this reply helpful? Yes No
Francisco Murtinheira Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello,

new_agence is the name of the attribute. You need the logical name of the entity where the attribute is on for the query above to work.

The way the query works is you fill in the logical name of the entity and then the attribute id.

https://xxxxx.api.crm4.dynamics.com/api/data/v9.1/EntityDefinitions(LogicalName='new_agence')/Attributes(9bc06e2b-727f-e811-a846-000d3a2900a9)/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet

Was this reply helpful? Yes No
AA_1995 35 on at

Like (0)

Report
Copy link

Link copied!

hello thank's ..

the localname is 'account' :)

https://XXXX.api.crm4.dynamics.com/api/data/v9.1/EntityDefinitions(LogicalName='account')/Attributes(9bc06e2b-727f-e811-a846-000d3a2900a9)/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet

or

xxxx.api.crm4.dynamics.com/.../OptionSetOptions

But I have a error on Powerbi import Odata flux .. do you work with PBI ??

Best regards

Was this reply helpful? Yes No