Storing configuration data in dynamics 365

(0) Share

Report

Posted on by Community Member

I need to store an external api's url in dynamic 365. Recommended ways I have found are storing it in a Key Value Pair entity or configuration entity.But I dont know how to implement/use them. I need some guidance about their implementation.Any help would be much appreciated.

Categories:

Other Functionality

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

T.I.A 1,760 on at

Like (0)

Report

If you create a new entity (name is up to you) you can use a text field for your API URL. So the entity has:

Name: name of external API

URL: string field to hold the URL of your choice.

Now whenever you are developing etc you can query that entity by name and bring back the URL value for whatever you need to do. Let me know if this helps

Was this reply helpful? Yes No
Verified answer

Priyesh 7,396 User Group Leader on at

Like (0)

Report

Hi,

Usually, it's a good idea to create an entity just for Configuration. You can have a field in the same in which you can store this key in a string field. And then also make this field as Field-level security enabled for only System Administrators to be accessible/readable.

Supposedly, you will have a user's credentials that will access this api key, that user should be added to the access as well.

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks T.I.A and Priyesh Wagh. I have created a custom entity and stored configuration data n its fields. Can you please help me in writing the query for fetching data from this custom entity in javascript.

Was this reply helpful? Yes No
Verified answer

T.I.A 1,760 on at

Like (0)

Report

docs.microsoft.com/.../retrieverecord this article should get you going.

Was this reply helpful? Yes No
Suggested answer

Priyesh 7,396 User Group Leader on at

Like (0)

Report

If you want to write a FetchXML in your query, you can simply query using Advanced Find and then download the FetchXML.

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I'm still unable to fetch data. the queries I have tried are
1)window.parent.Xrm.WebApi.retrieveRecord("cml_configuration", "c82fbee3-6b97-e911-a995-00224800cc7a", "?$select=name").then(
2)window.parent.Xrm.WebApi.retrieveMultipleRecords("cml_configuration", "?$select=name&$top=3").then(
but none has worked. Although I dont want to hard code the record id but in an attempt to make it work I even hard coded it in the first query.This is the screenshot of my entity record

Was this reply helpful? Yes No
T.I.A 1,760 on at

Like (0)

Report

do you get any errors?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Error details are

code: 2147951872

errorCode: 2147951872

innerror: undefined

message: ""

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks T.I.A. It worked. I was passing wrong select parameters.

Was this reply helpful? Yes No
Suggested answer

Dharanidharan 638 Super User 2025 Season 2 on at

Like (0)

Report

You can fetch the records from that custom entity using query expression or fetch XML by passing the configuration key name

Was this reply helpful? Yes No