Login to the website and download the CSV file

Questions & Answers
1

Hi,

I need to get data from an old website (which is built on old technologies) in the form of a CSV file and work with it.

After logging in to the website using the name and password, I change (3 data): https://i.imgur.com/pBWzsQu.png

to get to the required variable data from CSV file: https://i.imgur.com/ihUmUZT.png
(this file is downloaded locally using some mathematical filter)

login request: https://hastebin.com/raw/ahevisebuw
login response: https://hastebin.com/raw/urofociros
login cURL (cmd-save): https://hastebin.com/raw/edohokawid

(data change to requested url) request: https://hastebin.com/raw/xuxufefepe
(data change to requested url) response: https://hastebin.com/raw/ibimecajij
(data change to requested url) cURL (cmd-save): https://hastebin.com/raw/fayezodesa

Can you please advise me how I should probably set up the scenario?

And yes, it will definitely be a large amount of data, so the assumption is that I will buy at least a PRO plan.

2

Hi @Lola ,
welcome to Make! This is definitely a more advanced workflow :smiley:

A few questions / thoughts:

a) there are credentials in the screenshots - those are example ones? Otherwise please change them now :smiley:
b) I tried to access the website but I couldn’t visit it. (tried: http://japan77.cloud/cz/Account/Login)

c) How often do you want to do this?

Depending on your answers, I’d advise differently.

If you only use it a few times per week, you might set it up using HTTP modules (enable "share cookies with following HTTP modules).
If you use it a few hundred times per week (or sooner :D), I’d think about setting up a custom app. Thee you can have multiple API requests (login, download csv…) using one operation in Make. This is obviously more difficult than the first solution but after some usage this might be worth it.

Happy to help on both!

Best,
Richard

1 Like
3

Hi Richard, I am facing something similar where I have to login multiple times and save cookies for a specfic site. What do you mean by create an application?

4

Sorry, that’s not very clear by myself. I meant creating a custom app on Make. There you can handle login/refresh etc.

5