Downloading Xml link

saso_008 · January 2, 2021, 7:22pm

I have a link https://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx?d=0 that this link give me every second a execl file and i want to download this file.how can do it?

gueyenono · January 2, 2021, 7:25pm

Just to be clear, there is a new Excel file on this link every second. So you would like a code that will download every new Excel file every second?

saso_008 · January 2, 2021, 7:28pm

yes i want download file every second or 3 second and merge data together.

gueyenono · January 2, 2021, 8:37pm

Then, you want to do is to run a scheduled script with the download.file() function. Take a look at this article:

saso_008 · January 3, 2021, 3:33pm

my file is aspx and use download.file( ) can't download it. in first step i want to download it and then schedule.

gueyenono · January 3, 2021, 8:33pm

When I try the following code, the file is downloaded, but I can't open it. This may be due to the fact that you can only get to this link if you sign in on the website (i.e. you need to be a member)?

download.file( url = "https://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx", destfile = "file.xlsx")

saso_008 · January 4, 2021, 1:33pm

i use this function but get an error.

Error in download.file(url = url, destfile = "file.xlsx") : 
  cannot open URL 'https://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx?d=0'
In addition: Warning message:
In download.file(url = url, destfile = "file.xlsx") :
  URL 'https://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx?d=0': status was 'SSL peer certificate or SSH remote key was not OK'

gueyenono · January 4, 2021, 1:35pm

@saso_008 I removed the ?d=0 at the end of the link. Copy and paste my code if you want.

saso_008 · January 4, 2021, 1:39pm

dont work and i think for get aspx files we must another functions.

Error in download.file(url = "https://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx",  : 
  cannot open URL 'https://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx'
In addition: Warning message:
In download.file(url = "https://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx",  :
  URL 'https://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx': status was 'SSL peer certificate or SSH remote key was not OK'

gueyenono · January 4, 2021, 1:48pm

I'm not sure why but I am able to download it even though I cannot open it. But looking at the error message you get, I think my earlier suspicion was correct: 'SSL peer certificate or SSH remote key was not OK'. It seems that these excel files are supposed to be available to members only. I am not sure how to interact with this website. Maybe it has a convenient API to get data from it?

saso_008 · January 4, 2021, 1:54pm

thanks @gueyenono . I can copy this file and download it without login to website and we don't have api for get data.

gueyenono · January 4, 2021, 1:56pm

I see then I 'm really not sure why you are not able to download it.
It works on my computer though.

saso_008 · January 4, 2021, 2:03pm

you can download file without any error?

gueyenono · January 4, 2021, 2:05pm

Yes, but for some reason I cannot open it.

saso_008 · January 4, 2021, 2:17pm

you use Rstudio in windows of linux?

gueyenono · January 4, 2021, 2:36pm

My operating system is Windows.

saso_008 · January 6, 2021, 7:00pm

my operating system is linux(debian10) and you did not any idea or can use another way for resolve error or use another function?

gueyenono · January 6, 2021, 9:21pm

I see. I am sorry, I don't know how else to help you.

system · January 27, 2021, 9:21pm

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.