Reporting API not giving me valid data

HI All,

I have a site registered in Matomo for which I have imported data from GoogleAnalyticsImporter

The issues are as follows:

  1. We display Total Views for a given post for which we invoke the Actions.getPageUrl Matomo API

When I specify a specific date eg : 2021-03-29 - I get 3 nb_hits but if I add a date range from 2019-11-12 to 2021-03-30 I get zero - API should have atleast returned 3 as the above mentioned date is well within the date range.

  1. How can I query the database (which tables) to find PageViews corresponding to a Page? Can you share the specific table names where the exact mapping of Page and PageViews happen ?