Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / Query external data fr...
Sales forum
Answered

Query external data from Dynamics 365 form

Posted on by 20
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
Categories:
  • AW-08051523-0 Profile Picture
    AW-08051523-0 7 on at
    Query external data from Dynamics 365 form
    Thank you, I'll try that approach.
     
    I'm also looking at the possibility to use a virtual table.
  • Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Query external data from Dynamics 365 form
    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?
     
  • Verified answer
    Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Query external data from Dynamics 365 form
    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.

    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
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans