Retreiving urls within Navision

fweeeefweeee Member Posts: 14
edited 2005-10-28 in Navision Attain
Hello,

I have a client who needs to retreive data from their credit card processor for reconcilation. This data comes in xml format, and can be retreived by entering in a certain url - if I enter the url (something like https://creditcardwebsite.com/creditcar ... d=password), and it displays the xml. I can then "save as" if I like.

Now I know this is intended to be automated - but I cant for the life of me work out how to automate this within Navision. There doesnt seem to be a dos command that can do this (unless I download a dos port of wget, which I am trying to avoid, as I want to use standard windows stuff only), and my playing with the internet automations has brought no joy yet.

Can someone help me please?

Comments

  • DenSterDenSter Member Posts: 8,304
    HYPERLINK('https://creditcardwebsite.com/creditcardreport?username=client&password=password');
    
    Put this code snippet in the OnPush trigger of a button for instance.
  • fweeeefweeee Member Posts: 14
    DenSter,

    Thanks for your reply, but I'm after something which is completely transparent to the user. I beleive the code you suggested will pop up internet explorer (or whatever their default web browser is), and the user will have to select "save as", etc etc.

    I'm after something which automatically saves the page, without anything poping up.
  • DenSterDenSter Member Posts: 8,304
    Sorry mate, can't help you out there :oops: . For that you'll probably have to use the MSIE object model, although I am not sure to what extent that is exposed within Navision.
  • fbfb Member Posts: 246
    XmlHTTP is your friend. Here's an example that grabs the 'Recent Discussions' rss feed from mibuso and displays the title of the first item.

    'xmlHTTP' is 'Microsoft XML, v4.0'.XMLHTTP40
    'domDoc' is 'Microsoft XML, v4.0'.DOMDocument40
    'domNode' is 'Microsoft XML, v4.0'.IXMLDOMNode
    CREATE(xmlHTTP);
    xmlHTTP.open('GET','http://www.mibuso.com/rss/?feed=2',FALSE);
    xmlHTTP.send;
    
    domDoc := xmlHTTP.responseXML;
    domNode := domDoc.selectSingleNode('//rss/channel/item/title');
    MESSAGE(domNode.text);
    
    CLEAR(domNode);
    CLEAR(domDoc);
    CLEAR(xmlHTTP);
    
  • DenSterDenSter Member Posts: 8,304
    Cool. And then you can use domDoc.Save('c:\somefolder\somename.xml'); to save it somewhere.
  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Nice. Who will be the first to create a Navision object that displays the mibuso.com Discussions, while one is working with Navision ;-)
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • DenSterDenSter Member Posts: 8,304
    LOL, the MBS - NaviRSS add-on =D>
  • sabatosabato Member Posts: 15
    Hey guys, I was following your discussion and tried it myself.
    It works perfectly fine with pure xml data. But is there a possibility to read just normal html-formated websites into navision ? I cant figure out how to read the complete website.

    Thanks in advance for your help.

    sabato

    P.S. In fact it is nor a real html website, but i dont know if you guys are familiar with the wddc format ?
    But one i have read the website into navision, i should be able to play around with it =)
  • rozemarozema Member Posts: 15
    I have the same issue: but different...

    Anybody knows how to retrieve jpg's in navision.
    I have the url available eg http://site.com/12345.jpg.
    Now I need to import the pic into a blob.

    Anyone?
Sign In or Register to comment.