Basically, automation. Right now the API only allows the refresh from one Microsoft Dynamics 365 for Finance and Operations environment to another, so the idea is having fresh data from production in our UAT environments daily. I don’t know which new operations the API will support in the future but another idea could be adding the DB export operation (creating a bacpac) to the pipeline and having a copy of prod ready to be restored in a Dev environment.
Since last October we’ve been able to try the preview of Microsoft Dynamics 365 for Finance and Operations Database Movement API which allows us to list and download DB backups and start DB refreshes using a REST API.
If you want to join the preview you first need to be part of the MSDyn365FO Insider Program where you can join the “Dynamics 365 for Finance and Operations Insider Community“. Once invited to the Yammer organization you can ask to join the “Self-Service Database Movement / DataALM” group where you’ll get the information to add yourself to the preview and enable it on LCS.
If you ever need to consume a SOAP web service from Dynamics 365 for Finance and Operations, the first step you should take is asking the people responsible for that web service to create a REST version. If that’s not possible this post is for you.
I’ll use this SOAP web service I found online at http://www.dneonline.com/calculator.asmx for the example, it’s a simple service-calculator with four methods to add, substract, multiply or divide two integers.
Consuming a SOAP service in .NET
Let’s start with the basics. How do we consume a SOAP web service in Visual Studio? Easy peasy. Just add a service reference to your project:
And point it to the web service of your choice:
This will add the reference to the project:
With that done we can create an instance of the web service’s client and call one of it’s methods:
3 + 6 = 9, it looks like it’s working.
Consuming a SOAP service in Dynamics 365 for Finance and Operations
To consume the web service on FnO create a new project in Visual Studio, right click on References and add the service reference:
Hmmm… nope, it can’t be done, no service reference option.
Consuming a SOAP service in Dynamics 365 for Finance and Operations (I hope…)
The problem is that we cannot add a service reference in Visual Studio on 365 dev boxes.
What do the docs say about this? Well, like in AX2012 we need to create a .NET class library that will consume that web service, then add the reference to our DLL on 365 and call the service methods from a client object. All right!
There it is. A reference to our class library and a runnable class that will do the job:
Let’s run it!
An exception of type ‘System.InvalidOperationException’ occurred in System.ServiceModel.dll but was not handled in user code
Additional information: Could not find default endpoint element that references contract ‘AASSOAPCalculatorService.CalculatorSoap’ in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element.
Contract? What contract? I know nothing about a contract. Nobody told me about any contract! What does the Wikipedia say about SOAP?
Soap is the term for a salt of a fatty acid or for a variety of cleansing and lubricating products produced from such a substance.
Oops wrong soap…
SOAP provides the Messaging Protocol layer of a web services protocol stack for web services. It is an XML-based protocol consisting of three parts:
an envelope, which defines the message structure and how to process it
a set of encoding rules for expressing instances of application-defined datatypes
a convention for representing procedure calls and responses
The envelope is the contract. A data contract is an agreement between a service and a client that abstractly describes the data to be exchanged. That contract.
Consuming a SOAP service in Dynamics 365 for Finance and Operations (I promise this is the good one)
If we check the class library there’s a file called app.config:
In this file we can see the endpoint the DLL is using. This is fixed (hardcoded) and in case there’s a test endpoint and a production endpoint we should change the address accordingly and have two different DLLs, one for each endpoint. We can also see the data contract being used by the service, the one called AASSOAPCalculatorService.CalculatorSoap. Because#MSDyn365FO is a web-based ERP we could solve this by adding the system.serviceModel node in the web.config file of the server, right? (app.config for desktop apps, web.config for web apps). Yes, but this would be useless as we have no access to the production environment to do this, and it will be impossible to do in the sandbox Tier-2+ environments when the self-service environments start to roll out.
So, what do we do? Easy, ChannelFactory<T> to the rescue! The ChannelFactory<T> allows us to create an instance of the factory for our service contract and then creates a channel between the client and the service. The client being our class in D365and the service the endpoint (obviously).
Then we do the following:
The BasicHttpBinding object can be a BasicHttpsBinding if the web service is running on HTTPS. The endpoint is the URL of the web service. Then we instantiate a service contract from our class with the binding and enpoint and create the channel. Now we can call the web service methods and…
It’s working! And it’s even better, if there’s different endpoints for a test and prod web service we just have to parametrize them!
But really, don’t use SOAP services, go with the REST.
One of the options to integrate MSDyn365FO with external systems is using the data entities with REST services and OData. To use OData the entity must have its IsPublic property set to Yes:
Otherwise, if it´s an standard entity, we´ll need to duplicate it because it´s not possible to change the property value in an extension.
If we´re doing an integration with an external system using OData to create new records in the ERP, we can have an issue when the record has a mandatory ID, as we can see in the Customers V3 entity. If we check the Mandatory property of the CustomerAccount field it´s set to Auto, getting the value from the CustTable where it´s set to Yes.
In this case, if we try to create a customer without an account number the service will fail as it can be seen in the Postman capture below:
Crystal clear error, the customer account field cannot be empty.
This isn´t happening with the Vendors entity. “Hey! But the vendor account is mandatory in the VendTable!” someone may think. Correct, it is, but not in the entity where it´s been overriden:
To see how the standard solves this we need to check the entity initValue method:
The skipNumberSequenceCheck is one of the data methods from the Common class, and it´s a relative of skipDataMethods, skipDataSourceValidateWrite, skipAosValidation, etc… It will always return false unless we tell it not to do so by passing true earlier in the code through the parameter.
The NumberSeqRecordFieldHandler class enableNumberSequenceControlForField will initialize the value of the field we pass in the parameters with the next value from the sequence we select. In this case it´s filling the vendor account field with the sequence set in the vendor parameters (obviously)
So, doing the same as the standard does, we’re going to extend the entity and the initValue method:
Having done this we’ll try again in Postman, this time deleting the CustomerAccount parameter from the body, and…
Success! We’ve got a new customer! Created from an external system and using the number sequence from Dynamics 365.
This is no mistery, it just mimicks what the standard does. As MSDyn365FO developers we must try to do that, always. Always… as long as we can, of course 🙂 Because even though partners always try to apply the standard as much as possible, we all know that in the end, there´ll be some customization done (hopefully, we´re developers!).