Default Authorization Required response (401) - taskscheduleR

Question

Default Authorization Required response (401) - taskscheduleR

282 Views Asked by NBE At 15 June 2020 at 22:43

I'm trying to run a daily taskscheduleR script that pulls data into R from an API. It works when I run it as a one time task but for some reason it won't work as a daily task. I keep getting the following error in the log file:

<HEAD><TITLE>Authorization Required</TITLE></HEAD>
<BODY BGCOLOR=white FGCOLOR=black>
    <H1>Authorization Required</H1><HR>
    <FONT FACE=Helvetica,Arial>
        <B>Description: Authorization is required for access to this proxy</B>
    </FONT>
    <HR>
    <!-- default Authorization Required response (401) -->

Here's the code:

library(httr)
library(jsonlite)
library(tidyverse)
library(taskscheduleR)

# Url to feed into GET function
url<-"https://urldefense.com/v3/__http://files.airnowtech.org/airnow/yesterday/daily_data_v2.dat__;!!J30X0ZrnC1oQtbA!Yh5wIss-mzbpMRXugALJoWEKLKcg1-7VmERQwcx2ESK0PZpM5NWNml5s9MVgwHr5LD1i5w$ "
# Sends request to AirNow API to get access to data
my_raw_result<-httr::GET(url)
# Retrieve contents of a request
my_content<-httr::content(my_raw_result,as="text")
# Parse content into a dataframe 
my_content_from_delim <- my_content %>% textConnection %>% readLines %>% read.delim(text = ., sep = "|",header = FALSE)
head(my_content_from_delim)

I have been using the Rstudio add-in to create the task.

Original Q&A

There are 2 best solutions below

**Anna Nevison** · Answer 1 · 2020-06-21T21:54:20.767000

Anna Nevison On 21 June 2020 at 21:54

If you are trying to access this on a work computer, you may need to allow downloads from the url link. Open a browser, paste that url, click 'allow downloads', run the script.

**mustafaakben** · Answer 2 · 2020-06-25T04:02:06.207000

I am not sure whether the solution I will offer will work for you, but it won't harm to try. If the problem related to the task scheduler, the following solution might work. However, if the problem of authorization issues, you may need to get some IT help from your workplace.

For the task scheduler issue, you can directly send your script to the windows task scheduler with a batch file and create a schedule for it.

To make it easy, you can use the following code. First, open a new folder and copy-paste your R script there. To run the following code, you should call you R script as My Script.r.

Then, in the same folder, create a batch file with the following codes. To create a batch file, you should copy the following code into a Notepad and save it as Run R Script.bat in the same folder.

cd %~dp0
"C:\PROGRA~1\R\R-40~1.0\bin\R.exe" -e "setwd(%~dp0)" CMD BATCH --vanilla --slave "%~dp0My Script.r" Log.txt

Here, cd %~dp0 will set the directory for the windows batch to the folder you run this batch. "C:\PROGRA~1\R\R-40~1.0\bin\R.exe" will specify your R.exe. You may need to change the path based on your system files.

-e "setwd(%~dp0)" will set the directory of R to the same folder in which the batch and script will be run.

"%~dp0My Script.r" Log.txt will define R script pathname and the log file for the batch.

Second, to create a daily schedule, we are going to create another batch file. To do so, copy and paste the following codes into a notepad and save as Daily Schedule.bat. When you click the Daily Schedule.bat, it will create a daily task and run for the first time in one minute, and every day it will repeat itself at the same time when you first run this batch.

@echo off

for /F "tokens=1*" %%A in ('
  powershell -NoP -C "(Get-Date).AddMinutes(1).ToString('MM/dd/yyyy HH:mm:ss')"
') do (
  Set "MyDate=%%A"
  set "MyTime=%%B"
)

::Execute path to bat path
cd %~dp0

::Create Task
SchTasks /Create /SC DAILY /TN "MY R TASK" /TR "%~dp0Run R Script.bat" /sd %MyDate% /st %MyTime%

This code will create a task called as "MY R TASK". To see whether it is scheduled, you can run the following codes on the windows prompt: taskschd.msc. This will open your task scheduler, and you can find your task there. If you want to modify or delete, you can use this task scheduler program; it has a nice GUI and easy to navigate.

For more details about the Task scheduler syntax, see the following link

If you have any questions, let me know.

Default Authorization Required response (401) - taskscheduleR

There are 2 best solutions below

Related Questions in R

Related Questions in R-TASKSCHEDULER

Trending Questions

Popular # Hahtags

Popular Questions