XML Web Integration Question
-
XML Web Integration Question
Posted by genns@technicalprospects.com on February 8, 2018 at 5:44 pm-
Can I integrate NAV with a vendor who says:Ā “We do not support SOAP in our API, we do support XML over HTTPS because the typically XML over https transaction is lighter weight and supports higher throughput.”
I’m very new to .NET, so I’m not sure if this is even possible with NAV…
I’m thinking I might do something like this???1. Create xml file using xmlport.2. Use .Net to send xml file to “[PROTOCOL]://[EXTERNAL_HOST]/[APPLICTION_CONTEXT]/SyncXMLIntegration”3. Use .Net to handle the xml response from vendor??Any thoughts/suggestions?
Thanks in advance!——————————
Greg Enns
ERP Coordinator
Technical Prospects
Kaukauna WI
—————————— -
?Hey Greg,
SOAP is just a form of XML with an envelope structure.Ā You can use https with SOAP, and you are in essance sending XML over https.Ā I believe you just need to Enable SSL under SOAP Services on your Service Tier.Ā I there would likely be some work with Security Certificates as well.
——————————
Joe Draeger
Ortho Molecular Products, Inc
Woodstock IL
——————————
——————————————- -
Hi Joe,
Being on NAV2016, I can use OData as well. Being that they said no to SOAP, I’m thinking I’ll need to use that. I did a test of the OData connection yesterday following this WalkThrough, and it worked locally. I understand the SSL will be required for external connections. I just don’t know what .NET and NAV pieces I need to put together to make it all work.
——————————
Greg Enns
ERP Coordinator
Technical Prospects
Kaukauna WI
——————————
——————————————- -
Val Gameiro
MemberFebruary 9, 2018 at 11:03 AM
I don’t have experience with this, but found this post on Mibuso. Hope it helps.Connect Navision with external web service
mibuso.com remove preview Connect Navision with external web service hello, I’m trying to make a call to a webservice from Navision 2009 R2 but I’m having many difficulties. View this on mibuso.com > ——————————
Val Gameiro
Senior NAV Analyst
BPL Plasma Inc.
Austin, Texas
NAVUG Austin Chapter Leader
——————————
——————————————- -
Naveen Jain
MemberFebruary 9, 2018 at 12:36 PM
Hi Greg,I think your solution should work.Ā
Depending on how much volume you are taking about, If you vendor is open to simple work with e-mails, you can simply produce XML from XMLPort and send XML file as attachment via SMTP e-mail. If you have too many files back and forth, then it seems like a EDI transaction.
Naveen Jain
——————————
Naveen Jain
Director of IT
Symbex Companies
Santa Fe Springs CA
——————————
——————————————- -
Anthony Darden
MemberFebruary 12, 2018 at 9:39 AM
Our NAV developer hasn’t done it before, but provided the following:
Ā
Create this in a codeunit in Nav:
http://dynamicslancer.blogspot.com/2016/09/how-to-create-xml-file-using-net.html?_tr_=true?_cdosy1_
Ā
Create a web service with the codeunit created above. The above link writes the xml to a file but you should be able to manipulate it a little to write it to a string and send it via the webservice.
Ā
Then use this .net code to send/receive the XML to the vendor
Ā
Once you have the response you can create another function in the codeunit above to accept the data and do whatever in Nav.
Ā Ā
There also may be a way to do it all in Nav. There are a lot of links in this thread that may help.
https://community.dynamics.com/nav/f/34/t/205295
——————————
Anthony Darden
Director of IT
Protective Industries, Inc.
Buffalo NY
——————————
——————————————- -
Thanks Tony! This looks very promising!
——————————
Greg Enns
ERP Coordinator
Technical Prospects
Kaukauna WI
——————————
——————————————- -
Suresh Kulla
MemberFebruary 13, 2018 at 10:03 AM
Greg,If they don’t want to integrate with SOAP services, then as you mentioned you can create
a XMLPort to generatexml Ā and then post that tothier service.Ā Please checkcodeunit 1290,1297. There are several functions over there which you can use to send the file to the service.——————————
Thanks
Suresh Kulla
NAV Technical Architect
ArcherPoint Inc.
Atlanta GA
——————————
——————————————- -
Thanks for this suggestion, . This was exactly what I was looking for. ?
——————————
Greg Enns
ERP Coordinator
Technical Prospects
Kaukauna WI
——————————
——————————————-
genns@technicalprospects.com replied 7 years, 6 months ago 1 Member · 0 Replies -
-
0 Replies
Sorry, there were no replies found.
The discussion ‘XML Web Integration Question’ is closed to new replies.