XML Web Integration Question

  • XML Web Integration Question

    Posted by genns@technicalprospects.com on February 8, 2018 at 5:44 pm
    • Greg Enns

      Member

      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
      ——————————

    • Joe Draeger

      Member

      February 9, 2018 at 9:26 AM

      ?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
      ——————————
      ——————————————-

    • Greg Enns

      Member

      February 9, 2018 at 9:36 AM

      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

      Member

      February 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

      Member

      February 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

      Member

      February 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

      https://stackoverflow.com/questions/18320916/how-to-send-xml-through-an-http-request-and-receive-it-using-asp-net-mvc

      Ā 

      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
      ——————————
      ——————————————-

    • Greg Enns

      Member

      February 13, 2018 at 9:11 AM

      Thanks Tony! This looks very promising!

      ——————————
      Greg Enns
      ERP Coordinator
      Technical Prospects
      Kaukauna WI
      ——————————
      ——————————————-

    • Suresh Kulla

      Member

      February 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 generate xmlĀ and then post that to thier service.Ā  Please check codeunit 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
      ——————————
      ——————————————-

    • Greg Enns

      Member

      February 21, 2018 at 1:53 PM

      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.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!