Complete a form in R and download Excel
I know that some of you have done similar questions but I am not able to solve my particular issue and I really need help with my code.
What I need to do is enter some data into this form:
https://sedeaplicaciones.minetur.gob.es/shpCarburantes
For try to make it work we just need to put 3 values in the form.
For example: Fecha Inicial = 01/12/2018, Fecha Final 31/12/2018 and Comunidad autónoma = "Comunidad Valenciana".
Then what I need is "click" the "Aceptar" button. and then in the next page, "click" in this button to download and Excel file.
https://imgur.com/a/TjGNqjH
Thank you a lot in advance!
library(httr)
url <- "https://sedeaplicaciones.minetur.gob.es/shpCarburantes/"
fd <- list(
submit = "Aceptar",
"ctl00$cph_Contenido$ddlTipoConsulta" = "1",
"ctl00$cph_Contenido$ddlTipoTemp" = "0",
"ctl00$cph_Contenido$txtFechaInicial" = "01/12/2018",
"ctl00$cph_Contenido$txtFechaFinal" = "30/12/2018",
"ctl00$cph_Contenido$ddlTipo" = "0",
"ctl00$cph_Contenido$ddlCCAA" = "10",
"ctl00$cph_Contenido$ddlProvincia" = "0",
"ctl00$cph_Contenido$ddlMunicipio" = "0",
"ctl00$cph_Contenido$ddlLocalidad" = "0",
"ctl00$cph_Contenido$ddlGasolinera" = "0",
"ctl00$cph_Contenido$ddlCarburante" = "GPR",
"ctl00$cph_Contenido$ddlTipoGrafico" = "0"
)
resp <- POST(url, body = fd, encode = "form")
r forms httr
asked Jan 1 at 21:48
LuxpbiLuxpbi
133
add a comment |
I know that some of you have done similar questions but I am not able to solve my particular issue and I really need help with my code.
What I need to do is enter some data into this form:
https://sedeaplicaciones.minetur.gob.es/shpCarburantes
For try to make it work we just need to put 3 values in the form.
For example: Fecha Inicial = 01/12/2018, Fecha Final 31/12/2018 and Comunidad autónoma = "Comunidad Valenciana".
Then what I need is "click" the "Aceptar" button. and then in the next page, "click" in this button to download and Excel file.
https://imgur.com/a/TjGNqjH
Thank you a lot in advance!
library(httr)
url <- "https://sedeaplicaciones.minetur.gob.es/shpCarburantes/"
fd <- list(
submit = "Aceptar",
"ctl00$cph_Contenido$ddlTipoConsulta" = "1",
"ctl00$cph_Contenido$ddlTipoTemp" = "0",
"ctl00$cph_Contenido$txtFechaInicial" = "01/12/2018",
"ctl00$cph_Contenido$txtFechaFinal" = "30/12/2018",
"ctl00$cph_Contenido$ddlTipo" = "0",
"ctl00$cph_Contenido$ddlCCAA" = "10",
"ctl00$cph_Contenido$ddlProvincia" = "0",
"ctl00$cph_Contenido$ddlMunicipio" = "0",
"ctl00$cph_Contenido$ddlLocalidad" = "0",
"ctl00$cph_Contenido$ddlGasolinera" = "0",
"ctl00$cph_Contenido$ddlCarburante" = "GPR",
"ctl00$cph_Contenido$ddlTipoGrafico" = "0"
)
resp <- POST(url, body = fd, encode = "form")
r forms httr
asked Jan 1 at 21:48
LuxpbiLuxpbi
133
add a comment |
I know that some of you have done similar questions but I am not able to solve my particular issue and I really need help with my code.
What I need to do is enter some data into this form:
https://sedeaplicaciones.minetur.gob.es/shpCarburantes
For try to make it work we just need to put 3 values in the form.
For example: Fecha Inicial = 01/12/2018, Fecha Final 31/12/2018 and Comunidad autónoma = "Comunidad Valenciana".
Then what I need is "click" the "Aceptar" button. and then in the next page, "click" in this button to download and Excel file.
https://imgur.com/a/TjGNqjH
Thank you a lot in advance!
library(httr)
url <- "https://sedeaplicaciones.minetur.gob.es/shpCarburantes/"
fd <- list(
submit = "Aceptar",
"ctl00$cph_Contenido$ddlTipoConsulta" = "1",
"ctl00$cph_Contenido$ddlTipoTemp" = "0",
"ctl00$cph_Contenido$txtFechaInicial" = "01/12/2018",
"ctl00$cph_Contenido$txtFechaFinal" = "30/12/2018",
"ctl00$cph_Contenido$ddlTipo" = "0",
"ctl00$cph_Contenido$ddlCCAA" = "10",
"ctl00$cph_Contenido$ddlProvincia" = "0",
"ctl00$cph_Contenido$ddlMunicipio" = "0",
"ctl00$cph_Contenido$ddlLocalidad" = "0",
"ctl00$cph_Contenido$ddlGasolinera" = "0",
"ctl00$cph_Contenido$ddlCarburante" = "GPR",
"ctl00$cph_Contenido$ddlTipoGrafico" = "0"
)
resp <- POST(url, body = fd, encode = "form")
r forms httr
asked Jan 1 at 21:48
LuxpbiLuxpbi
133
I know that some of you have done similar questions but I am not able to solve my particular issue and I really need help with my code.
What I need to do is enter some data into this form:
https://sedeaplicaciones.minetur.gob.es/shpCarburantes
For try to make it work we just need to put 3 values in the form.
For example: Fecha Inicial = 01/12/2018, Fecha Final 31/12/2018 and Comunidad autónoma = "Comunidad Valenciana".
Then what I need is "click" the "Aceptar" button. and then in the next page, "click" in this button to download and Excel file.
https://imgur.com/a/TjGNqjH
Thank you a lot in advance!
library(httr)
url <- "https://sedeaplicaciones.minetur.gob.es/shpCarburantes/"
fd <- list(
submit = "Aceptar",
"ctl00$cph_Contenido$ddlTipoConsulta" = "1",
"ctl00$cph_Contenido$ddlTipoTemp" = "0",
"ctl00$cph_Contenido$txtFechaInicial" = "01/12/2018",
"ctl00$cph_Contenido$txtFechaFinal" = "30/12/2018",
"ctl00$cph_Contenido$ddlTipo" = "0",
"ctl00$cph_Contenido$ddlCCAA" = "10",
"ctl00$cph_Contenido$ddlProvincia" = "0",
"ctl00$cph_Contenido$ddlMunicipio" = "0",
"ctl00$cph_Contenido$ddlLocalidad" = "0",
"ctl00$cph_Contenido$ddlGasolinera" = "0",
"ctl00$cph_Contenido$ddlCarburante" = "GPR",
"ctl00$cph_Contenido$ddlTipoGrafico" = "0"
)
resp <- POST(url, body = fd, encode = "form")
r forms httr
r forms httr
asked Jan 1 at 21:48
LuxpbiLuxpbi
133
asked Jan 1 at 21:48
LuxpbiLuxpbi
133
asked Jan 1 at 21:48
LuxpbiLuxpbi
133
asked Jan 1 at 21:48
LuxpbiLuxpbi
133
asked Jan 1 at 21:48
LuxpbiLuxpbi
133
133
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53999206%2fcomplete-a-form-in-r-and-download-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53999206%2fcomplete-a-form-in-r-and-download-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
