Number of records shown in UI and fetch through REST API is different | Community
Skip to main content
manoj_limbachiy
manoj_limbachiy
October 16, 2015
Solved

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

  • October 16, 2015
  • 4 replies
  • 1905 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Kaushalendra

    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-reportdescriptionelement#reference_9ECD594AEDD240D7A475868824079F06

    4 replies

    Kaushalendra
    Adobe Employee
    KaushalendraAdobe EmployeeAccepted solution
    Adobe Employee
    October 16, 2015

    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-reportdescriptionelement#reference_9ECD594AEDD240D7A475868824079F06

    manoj_limbachiy
    manoj_limbachiyAuthor
    October 16, 2015

    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
    Adobe Employee
    KaushalendraAdobe Employee
    Adobe Employee
    October 16, 2015

    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
    manoj_limbachiyAuthor
    October 16, 2015

    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

    Terms & ConditionsAccessibility statement

    Loading footer...