Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Display external data on Account form

Posted on by Microsoft Employee

Hi,

I've been asked to investigate whether we can display external data on the Account form.  I am extremely new to Dynamics CRM and I am just hoping someone can point me in the right direction on what I should be researching/investigating.   Here is what we are looking to accomplish:

When a user views an Account, we need to make a REST API call to retrieve a list of attachments that are associated with the Account.  These attachments are stored in a separate system that exposes an API.

  • API uses OAUTH 2
  • I need to pass some Account information to the API (e.g. Account ID) in order to get attachments specific to the selected Account.
  • API responds with JSON

I would like to display the list of attachments (e.g. File Names) as hyperlink in a grid/table on the Account screen - possibly on a new Tab or something.  Clicking the hyperlink will call the API to download/open the actual attachment file.

I've tried searching online but haven't had any success.  I've seen options about Plugins, Virtual-Entities, HTML pages, etc. - but I have no idea whether any of these would work.  So I'm hoping someone can just point me in the right direction.

Thanks,

Joe

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Display external data on Account form

    You could do HTML page on the Account form, make a table in the HTML.  Then have a javascript function onload/onready that calls out to the other site via HTTP request, then parse the return for each line to display the url.  I am assuming the URL would be returned, if not you could put the calculation of it into the Javascript function.

    www.freecodecamp.org/.../

    I say JavaScript to try and make it quicker and temporary, if you want to generate a child record for each one then you could use a plugin and make it real time.

    I cant speak to the security needs of clicking the link and forcing a download.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans