-5

I am new to golang and trying this for the first time. I have to call yahoo finance api(YQL) to get the stock price of the symbol in json format. Here is the api:

http://query.yahooapis.com/v1/public/yql?q=select%20LastTradePriceOnly%20from%20yahoo.finance.quote%20where%20symbol%20in%20(%22AAPL%22,%22FB%22,%22GOOG%22)&format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys

For now i have hard coded the symbol(AAPL,FB, GOOG) in the above select query but these symbols will be coming from the user, it should be dynamic. How should i add the input(symbol) to the above query in golang?

Thanks for the help in advance.

peterh
  • 11,875
  • 18
  • 85
  • 108
Vrushank Doshi
  • 2,428
  • 5
  • 20
  • 34

1 Answers1

0

If you have the symbols (provided by the users) as a string array parameter (like: "symbols", being string["\"AAPL\"", "\"FB\"", "\"GOOG\""]), you can use strings/#Join to produce the right string:

s := strings.Joins(symbols, ",")

Then (as detailed in "Encode / decode URLs"), use net/url/#QueryEscape to get the final url string for symbols:

url := "http://query.yahooapis.com/v1/public/yql?q=select%20LastTradePriceOnly%20from%20yahoo.finance.quote%20where%20symbol%20in%20(" + 
url.QueryEscape(s) + 
")&format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys"
Community
  • 1
  • 1
VonC
  • 1,262,500
  • 529
  • 4,410
  • 5,250
  • Alternatively you could put all the query parts into a [`url.Values`](https://golang.org/pkg/net/url/#Values) and then use [`Values.Encode`](https://golang.org/pkg/net/url/#Values.Encode) to get the entire URL part after the `?`. – Dave C Sep 27 '15 at 15:42