Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Display data from an external API on a form

(0) ShareShare
ReportReport
Posted on by 5

Hi, we are using Dynamics v9 on-prem and i have a requirement to display some external data (table of data) in a custom entity form, so when the user opens an object form there will be some part on the form where the table of data for that object will be displayed.

The data is coming from an API and will be a list of items that are related to that entity object.  My initial research suggests an iFrame embedded in the form that passes the entity ID over to a webapp via URL parameter that i will have to create in C#

However I am also seeing Power Automate might be a solution, however i am unsure if its possible, I am trying to understand how i send back a list of data (power automate to Dynamics) and display that on dynamics form in some table format.  

Any assistance to point me in right direction would be greatly appreciated. 

  • Suggested answer
    RE: Display data from an external API on a form

    How about using virtual entities?

    learn.microsoft.com/.../create-edit-virtual-entities

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Display data from an external API on a form

    Hi,

    You need to show the data on your form in whatever way you want based on the response from the api call from plugin.

    You can still register your plugin on Onpremise. Dataverse is the new name given to Microsoft SQL server + features available in CRM like security, automation, integration

  • senna Profile Picture
    senna 5 on at
    RE: Display data from an external API on a form

    Thank you,when you say "get data" does it get it and then display it back into CRM in some way?

    Also, just briefly reading this part;

    Run the Plug-in Registration tool and register the assembly in Microsoft Dataverse server's sandbox and database.

    I thought dataverse was online and not on-prem?

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Display data from an external API on a form

    Hi,

    Power automate is only available for CRM online not for CRM Onpremise.

    You can look at below plugin sample code which calls external api and get data

    github.com/.../WebAccessPlugin

    You can implement something similar in your instance on post create plugin

    Make sure you make this plugin asynchronous so that record created even if there is an error in web access plugin

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans