0

YQL to fetch currency exchange rates not returning results reliably

Hello, I am trying to implement RSS feeds for USD exchange rates on SharePoint 2010. I need exchange rates for 6 different currencies, namely EUR, GBP, CNY, BRL, INR & MXN. I have used the following REST query:

http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDEUR%22%2C%20%22USDGBP%22%2C%20%22USDCNY%22%2C%20%22USDBRL%22%2C%20%22USDINR%22%2C%20%22USDMXN%22)&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys

However, the query itself returns random number of results ranging from zero values to all 6 values. Kindly provide suitable solution for the same.

Thanks in advance.

by
0 Replies

Recent Posts

in YQL