0

i am getting weather feeds from yahoo API ,but at a single request i able to get single place only .i want to get multiple cities feeds at a time in single request . please help me to get multiple cities feeds.

pasham srinivasarao
  • 67
  • 1
  • 7

1 Answers1

1

Using the web test platform they offer here you can test different YQL queries.

YQL is a SQL-like language and it supports operators like OR and IN.

My test concerning your question was this:

select * from weather.forecast where woeid in (select woeid from geo.places(1) where text in ("nome, ak", "chicago, il", "dallas, tx"))

This brings weather forecast for 3 cities.

sanastasiadis
  • 1,182
  • 1
  • 15
  • 23
  • How to get weather data for multipl lat longs, as I am trying with query but not able to get result "select * from weather.forecast where woeid in (SELECT woeid FROM geo.places WHERE text="(28.7041, 77.1025),(28.0229, 73.3119)")" – Anand Suthar Jun 11 '18 at 12:27
  • @AnandSuthar I guess you need an "or" in your query for the text. This for example works: `select * from weather.forecast where woeid in (SELECT woeid FROM geo.places WHERE text="(28.7041, 77.1025)" or text="(28.0229, 73.3119)")` – sanastasiadis Jun 11 '18 at 14:42