Get stats from piwik database

Support & Bugs
1

Hi! I am including piwik statistics in my backoffice and i need to get information about the visits in each page.
I’m using the next code:

$url="$this->site?module=API&method=Actions.get&idSite=1&period=range&date=$this->datainicio,$this->datafim&format=JSON&token_auth=$this->token$pag";
$fetched = file_get_contents($url);
$data = json_decode($fetched);
return $data->nb_pageviews;

I receive the correct information but i’m putting it in a table, so it needs many requests what slows my website.

Someone knows another way of get the information?
I tried read the schema of the datebase but it seems very difficult build the query’s for that…

2

Why do you need many requests, what exactly do you change in the request?

3

I’m setting the values in a table where each row has a column with the number of visits, etc…, e need a request for each value in that column