Re: [Gretl-users] Download data using API's

On Sun, 12 Aug 2018, Henrique Andrade wrote: > Dear Gretl Community, > > I'm trying to download and open some Banco Central do Brasil (BCB) > data using its API and I don't know if there's a more "ellegant" way > to achieve that goal. Please take a look at the code I'm using now: > > <hansl> > string str_csv = > readfile("http://api.bcb.gov.br/dados/serie/bcdata.sgs.24363/dados?formato=csv") > # It is possible to download data using json format using this: > # "http://api.bcb.gov.br/dados/serie/bcdata.sgs.24363/dados?formato=json" > string str_csv = strsub(str_csv, "data", "") > string str_csv = regsub(str_csv, "\"", "") # <--- it doesn't work with > the strsub function. > > outfile "data.csv" --quiet > print str_csv > end outfile > > open "data.csv" > </hansl> The following works for me using current gretl: <hansl> URL = \ "http://api.bcb.gov.br/dados/serie/bcdata.sgs.24363/dados?formato=csv" string s = readfile(URL) s = strsub(s, "data", "") s = regsub(s, "\"", "") # or if you prefer: # quote = sprintf("\"") # s = strsub(s, quote, "") outfile bcdata.csv --quiet print s end outfile open bcdata.csv print -o </hansl> However, you may have an easier time accessing Banco Central do Brasil via gretl's new dbnomics interface, since BCB is one of their providers.