Currency exchange rate service error.

Ooko

I am trying to setup currency exchange rate service for a company with Kenyan shillings as the LCY using the yahoo services in NAV.How do I set this up since the yahoo url provided by NAV has a different LCY and when I try to preview I get the attached error
And which url can I use to demonstrate how the service works in converting the KES to the other currencies.

Yury

Hi
Try this one, it works, you can check such lines in IE, just copy/paste:

http://query.yahooapis.com/v1/public/yql?q=select * from yahoo.finance.xchange where pair in ("KESCAD","KESEUR","KESGBP","KESUSD","KESZAR")&env=store://datatables.org/alltableswithkeys

And make sure, that your service has an access to this url.

Yury

Hi
Try this one, it works, you can check such lines in IE, just copy/paste:

http://query.yahooapis.com/v1/public/yql?q=select * from yahoo.finance.xchange where pair in ("KESCAD","KESEUR","KESGBP","KESUSD","KESZAR")&env=store://datatables.org/alltableswithkeys

And make sure, that your service has an access to this url.

Ooko

Thank you Yury ,this worked ok for me