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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Best way to have a wor...
Microsoft Dynamics CRM (Archived)

Best way to have a workflow(field change) trigger an AWS Lambda function?

(0) ShareShare
ReportReport
Posted on by bpr_admin

We want to move data that is modified data in CRM 2016 into a database we have living in an AWS RDS instance. CRM is of course backed by SQL server. Our RDS instance in question is a Postgres database.

My thought is to have a CRM workflow kick off when certain fields are changed, then to send a notification to AWS SNS, which would then tell a lambda function to grab 3 fields direct from the SQL server or from one of our REST interfaces to the data, and insert it into the Postgres database. Keying off of the contact ID we created and not the GUID.

I'm not a programmer (yet... Just starting my journey in python), so I get hung up on how to have the workflow notify SNS or lambda.

Does anyone have insight to how to deliver a notification to AWS with workflow?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    JohnAnonymous Profile Picture
    JohnAnonymous 5,241 on at

    Assuming you can call a AWS lambda function with a http (post) message, I would create a custom workflow activity that sends a http post request to the lambda with a json string.

    For such a workflow activity I have a sample on my blog: www.oak3.org/.../creating-sharepoint-site-dynamics-crm-azure-functions under CRM Plugin.

    By the way, if you start programming and want to do work with CRM, I would recommend using C#. Microsoft has a lot of Libraries to make your life a lot easier. Not saying it can't be done with other languages, but it might not be te best starting point.

  • bpr_admin Profile Picture
    bpr_admin on at

    Thanks, I'm looking into this.

    I'm primarily learning to program for machine automation, infrastructure deployment, and automating/scripting the datacenter, and AWS. For that my main tools are Powershell and python.

  • bpr_admin Profile Picture
    bpr_admin on at

    So, it looks like with your solution, it is not possible with "out of the box" workflow to be able to send data to a REST API. Am I correct in that?

  • Suggested answer
    JohnAnonymous Profile Picture
    JohnAnonymous 5,241 on at

    No, it's not possible out of the box.

    With CRM Online you could look at flow, that does enable that. But from your opening post I read that you are running an onpremises versions in the AWS cloud.

  • bpr_admin Profile Picture
    bpr_admin on at

    We are running on-premises D365 in our own network, and we use AWS for all of our public stuff.

    Due to a highly locked down RDS database, only AWS systems (ec2 and lambda) have access to it, so that is why I want to have lambda doing the heavy lifting in this case.

  • Ben T Profile Picture
    Ben T 803 on at

    Bpr Admin,

    Did you end up finding a solution to this? What worked for you? We are trying to send data from CRM to and AWS database. Basically, we just need to pass a string from one field in CRM and have that string saved in AWS database.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans