Query external data from Dynamics 365 form

(1) Share

Report

Posted on by Sweden1968

Hi,

I'm trying to find a solution for the following scenario:

I have an external datasource (not dataverse) that holds millions of records.

On opening the Account form, I want to send a request to the external source to filter out related records and then display those records in an iFrame that I will place on the form.

Any suggestions or examples would be appreciated.

Thanks

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Dengliang Li Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi,

When a record is opened, the onload event is triggered.
You can register JavaScript in the onload event of the form.
Use ajax or fetch in JavaScript to send requests to external data sources.

Ajax - MDN Web Docs Glossary: Definitions of Web-related terms | MDN (mozilla.org)

Get the DOM object of the target Iframe in the browser top context (window.top).
For example: window.top.document.getElementById("<IframeId>").contentWindow.document;
Then, you can manipulate the elements in the Iframe.
Insert the returned data into a specific element in the Iframe.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li

Was this reply helpful? Yes No
Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Has the issue been solved?
Have there been any updates? Please feel free to ask me if you have any questions!
If it has been resolved, can you mark the response as an answer?

Was this reply helpful? Yes No
AW-08051523-0 31 on at

Like (0)

Report
Copy link

Link copied!

Thank you, I'll try that approach.

I'm also looking at the possibility to use a virtual table.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Query external data from Dynamics 365 form

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Query external data from Dynamics 365 form

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates