Pageviews per visit

Retrieve and display pages viewed in a visit. This specific api call is turned off by default, please contact support@opentracker.net to turn this api call on.

API Usage

This API produces a json array. Perform GET or POST requests. Visitors can also be retrieved based on a page_idx, and/ or visit_id, and/ or a machine_idx.

Parameters

One or more of the following parameters are required:

filterByUrlTitle: Display data for the specified url or title. Default is everything.
filterByPageId: Display data for the specified page ids. Page id is a unique identifier of each page. Default is all page ids.
filterByMachineId Display data for these machine ids. Machine id is a unique identifier of each visitor. Default is all machine ids.
filterByVisitId Display data for these visit ids. Visit id is a unique identifier of each visit. Default is all visit ids.
from Find all pages from the specified unix timestamp. Default is all unix timestamps.
to Find all pages up to the specified unix timestamp. Default is all unix timestamps.
offset Starting point from where records will display. The default is [0] (most recent chronological event).
limit Maximum number of records displayed in output. Default is [40]. Maximum is 10,000.
login Your opentracker login email. Default is support@opentracker.net
password Your password.
ticketId A ticketId can be used to provide credentials with an expiring token. A ticketId can be used instead of a login/ password combination. Further information can be found here.
site The site for which to display data. Default is [www.opentracker.net].
locale The locale parameter is an identifier for a particular combination of language and region (e.g. en_US) and determines the format of the data returned. A list of locales can be found here.
dataType The dataType parameter determines the format of the data returned. Values can be [json] | html | jsondatatable | jsonjqgrid
ignoreLocale Display columns without language translation. Boolean. [false]|true.
dateFormat The dateFormat parameter determines the format of dates returned. An example is dateFormat=yyyy-dd-MM. Syntax can be found here.

Examples

To search for all visited pages containing 'login' in www.mydomain.com
HTTP GET/ POST: view_pages.jsp?login=demo@opentracker.net&password=demo123&site=www.opentracker.net&filterByUrlTitle=*login*&offset=0&limit=10

To search for one of the pages visited by the user with machine id 3850451
HTTP GET/ POST: view_pages.jsp?filterByMachineId=3850451

Response

This page returns a json array with 'n' entries starting from the specified offset formatted as:

{ "resultsList": [
{
"error":"java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \\'\\'3850451\\',0\\' at line 23\\n\\tat glowaxes.sql.DatabaseStatementsManager.getMultipleExecute(DatabaseStatementsManager.java:672)\\n\\tat glowaxes.sql.DatabaseStatementsManager.getMultipleExecute(DatabaseStatementsManager.java:434)\\n\\tat glowaxes.cql.IStatementsManager.getMultipleExecute(IStatementsManager.java:22)\\n\\tat glowaxes.data.SqlSerie.processSql(SqlSerie.java:326)\\n\\tat glowaxes.data.DataIsland.performHeavyLoad(DataIsland.java:639)\\n\\tat glowaxes.data.DataIsland.setData(DataIsland.java:411)\\n\\tat glowaxes.tags.DataTag.doEndTag(DataTag.java:208)\\n\\tat org.apache.jsp.api.views.view_005fpages_jsp._jspService(view_005fpages_jsp.java:1261)\\n\\tat org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)\\n\\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\\n\\tat org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)\\n\\tat org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)\\n\\tat org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)\\n\\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\\n\\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\\n\\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\\n\\tat org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)\\n\\tat org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)\\n\\tat org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)\\n\\tat org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)\\n\\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\\n\\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\\n\\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\\n\\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\\n\\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\\n\\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)\\n\\tat org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)\\n\\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\\n\\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)\\n\\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)\\n\\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)\\n\\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\\n\\tat java.lang.Thread.run(Thread.java:745)\\nCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \\'\\'3850451\\',0\\' at line 23\\n\\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\\n\\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\\n\\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\\n\\tat java.lang.reflect.Constructor.newInstance(Constructor.java:423)\\n\\tat com.mysql.jdbc.Util.handleNewInstance(Util.java:409)\\n\\tat com.mysql.jdbc.Util.getInstance(Util.java:384)\\n\\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)\\n\\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)\\n\\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)\\n\\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)\\n\\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)\\n\\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)\\n\\tat com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)\\n\\tat com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)\\n\\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\\n\\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\\n\\tat glowaxes.sql.debug.DebuggableStatement.executeQuery(DebuggableStatement.java:596)\\n\\tat glowaxes.sql.DatabaseStatementsManager.getMultipleExecute(DatabaseStatementsManager.java:642)\\n\\t... 32 more\\n"}
]
}

Errors

If errors are encountered, the first encountered error will be returned of form "Error: exception: message

Error: java.lang.RuntimeException: Login/ site combination is not valid

We would love to hear your feedback. Please use the facebook comment box below