Retreiving urls within Navision

fweeee

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?

DenSter

HYPERLINK('https://creditcardwebsite.com/creditcardreport?username=client&password=password');

Put this code snippet in the OnPush trigger of a button for instance.

fweeee

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.

DenSter

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.

fb

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);

DenSter

Cool. And then you can use domDoc.Save('c:\somefolder\somename.xml'); to save it somewhere.

Luc_VanDyck

Nice. Who will be the first to create a Navision object that displays the mibuso.com Discussions, while one is working with Navision ;-)

DenSter

LOL, the MBS - NaviRSS add-on =D>

sabato

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

rozema

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?