How to write an application for unloading Yandex.Direct statistics via the "zero" API from scratch?

Question

ruby

I am a zero in programming, setting myself the task of learning how to write my own tools for solving practical marketing problems.
The first task is described in the title of the question. In it, I would like to upload data at least in CSV, ideally in MySQL.
I ask knowledgeable people to suggest which methods and tools I should choose and which sources to read / study (preferably in order of priority) in order to complete the task as quickly as possible.
PS: I don't know why (stereotype), but I would like to learn and do it in Ruby.
UPD: The application must be able to automatically collect statistics on a schedule or at a specified frequency.

Answer 1

I suppose that if you are solving practical problems, then it is unlikely that you are very interested in setting up a *.nix environment and doing all the other infrastructure work.
If you want to interact with api (metrics or something else, it's api for that), then I would write a few simple functions in javascript, wrap them in some unsightly interface on an html page and put it on github, which access would be always and everywhere. Experience with api in javascript will be useful, for example, if you want to manually manage the goals of the metric (so that when copying text from the block, the goal yaCounterID.reachGoal ('phone_copy'), for example) is "achieved").
Of course, javascript will not save data to a file or database so easily, but for starters, you can simplify and automate the processes a bit. In the future, you can use localstorage, indexedDB. Might be a good browser extension.
Pros:
- Installation of software and OS is not required (a browser with a convenient console is always at hand)
- You can host statics for free on github to get access from anywhere
- Simple operations in javascript can be done without having particularly deep knowledge
- Development perspective (extension for browser, mobile application, backed+frontend)
Cons:
- At the initial stage, there is no way to work with the file system or database
- Open source code (minus?)

Answer 2

write a ruby ​​or python script that will pull the Yandex api, and put its call in cron or task manager in windows, if you choose ruby, you can easily find the necessary gems for implementation
, for example, restclient - to send requests to api, writeexcel to upload data to exel , in fact, the task is not one of the most difficult, if you sit for a day, you will figure it out