web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Display External DB da...
Microsoft Dynamics CRM (Archived)

Display External DB data onclick of a button in Contact.

(0) ShareShare
ReportReport
Posted on by Community Member

I had a Requirement. I need to display data from external SQL DB on-click of a button in Contact's Main form in Web Resource. I had an Stored Procedure, wrote an API to call that SP. I've placed an Button in HTML webresource. The challenging is on-clicking of the button, it should call SP and display data of particular contact id number. Each contact has unique id number in DB, and in CRM also. the issue is it is not querying and fetching the data dynamically. if i give static ID of a contact, it is working.but it is not working dynamically.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: Display External DB data onclick of a button in Contact.

    hi..

    when you are passing contact id dynamically.. try removing brackets ({ } ) from contact id guid..

    also post your code to provide correct answer.

  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at
    RE: Display External DB data onclick of a button in Contact.

    Try to debug your JavaScript code and using browser F12 window try do add watch to get the API url which you are calling from  dynamics crm. Now compare with static API , see what you are missing.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
UllrSki Profile Picture

UllrSki 2

#1
Community Member Profile Picture

Community Member 2

#3
SC-08081331-0 Profile Picture

SC-08081331-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans