Im trying to get a file downloaded from the website posted below after completing some fields. https://www.siogranos.com.ar/Consulta_publica/operaciones_informadas_exportar.aspx
the fields i would like to complete are:
- the dates in "Fecha Declaración en SioGranos:" "01/08/2018" to "31/01/2018"
- product name in "Producto:" that should be equal to "SOJA"
Adding here what I did so far but couldn´t even construct the url in the correct form.
library(rvest)
txtFechaOperacionDesde<- "01-08-2018"
txtFechaOperacionHasta<- "31-08-2018"
ddlProducto<- "SOJA"
uid <- 4
csv<-sprintf("https://www.siogranos.com.ar/Consulta_publica/operaciones_informadas_exportar.aspx?csv=1&txtFechaOperacionDesde=%s&txtFechaOperacionHasta=%s&ddlProducto=%s&uid=%s",txtFechaOperacionDesde,txtFechaOperacionHasta,ddlProducto,uid)
res <- read.csv(url(csv))
url<-url(csv)
Created on 2018-08-06 by the reprex package (v0.2.0).
tried with rvest but i could set a few parameters only.
any help is appreciated.