Number of records shown in UI and fetch through REST API is different

[manoj_limbachiy]

We follow the below mentioned steps to get data using Omniture REST API:

• First we get the Endopint using Company.GetEndpoint, method:

     Endpoint URL: https:\\api5.omniture.com\admin\1.4\rest\

• We call Report.Queue, method using the following parameters
  • reportSuiteID
  • dateFrom
  • dateGranularity = “day”
  • min_granularity = 1
  • Matrix
    • visitors
    • pageviews
    • uniquevisitors
    • bouncerate
    • totaltimespent
    • visits
    • entries
    • exits
  • Elements
    • geocountry
    • page
• After getting the ReportId, we call the method Report.Get
• For this report suite id we get 10 rows from Omniture for date 07/14/2015, but when we login into Omniture Web UI, there are 20 records displays for that specific day.

Please let us know if we are missing anything or any further details.

[Kaushalendra · Accepted solution]

The reason you are getting 10 results is that the when a breakdown is applied (as in your request breakdown for geocountry and page is applied), it returns Top 10 records. You can specify this limit and where to start with fetching the results in your request.

Please refer to the below page for more details on these configuration:

https://marketing.adobe.com/developer/documentation/analytics-reporting-1-4/r-reportdescriptioneleme...

[manoj_limbachiy]

Hi Kaushalendra,

Thanks for the quick reply. I tried applying the top and startingWith but it is not returning more than 10 records, following is the parameter passed in Report.Queue method

reportDescription = new
                        {
                            reportSuiteID = reportSuiteId,
                            dateFrom = fromDate.Value.ToString("yyyy-MM-dd"),
                            dateTo = toDate.Value.ToString("yyyy-MM-dd"),
                            top = 50000,
                            dateGranularity = "day",
                            min_granularity = 1,
                            metrics = array of fields,
                            elements = array of fields,
                        }
                    };
                    request.AddBody(body);

Please let me know if I am missing anything.

[Kaushalendra]

Would it be possible for you to provide me the full Request you are sending through and the response received?

Also, it seems that this query might need some of your account specific analysis and hence would suggest you to get in touch with ClientCare team by creating a ticket in name of any of the Supported Users for SiteCatalyst in your company.

~ Kaushal

[manoj_limbachiy]

Hi Kaushalendra,

Thanks for the response. Actually, I applied the top to elements and it works, before that I was applying top to report definition.

Regards,

Manoj