Query
Click here for a complete list of operations.
ExecuteQuery
Returns the results of a query for a site. In order for this function to work, you must manually add a unique authorization code into the AuthorizationCode element of the App_Data\Config\AppConfig.xml file. This code must be at least 10 alphanumeric characters long. For the highest security, it is recommended that this be a GUID.
Test
The test form is only available for methods with primitive types as parameters.SOAP 1.1
The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.
POST /Services/Query.asmx HTTP/1.1 Host: stats.smartertools.com Content-Type: text/xml; charset=utf-8 Content-Length: length SOAPAction: "http://smartertools.com/smarterstats/query/ExecuteQuery" <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <ExecuteQuery xmlns="http://smartertools.com/smarterstats/query/"> <authUserName>string</authUserName> <authPassword>string</authPassword> <authorizationCode>string</authorizationCode> <queryName>string</queryName> <keyValuePairs> <string>string</string> <string>string</string> </keyValuePairs> </ExecuteQuery> </soap:Body> </soap:Envelope>
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <ExecuteQueryResponse xmlns="http://smartertools.com/smarterstats/query/"> <ExecuteQueryResult> <Success>boolean</Success> <Completed>boolean</Completed> <CompletedPercent>int</CompletedPercent> <AsyncGuid>string</AsyncGuid> <QueryTimeMilliseconds>long</QueryTimeMilliseconds> <TableData> <QueryResultRow> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location xsi:nil="true" /> </QueryResultRow> <QueryResultRow> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location xsi:nil="true" /> </QueryResultRow> </TableData> <FooterUnknown> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterUnknown> <FooterOtherItems> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterOtherItems> <FooterTotals> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterTotals> </ExecuteQueryResult> </ExecuteQueryResponse> </soap:Body> </soap:Envelope>
SOAP 1.2
The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.
POST /Services/Query.asmx HTTP/1.1 Host: stats.smartertools.com Content-Type: application/soap+xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"> <soap12:Body> <ExecuteQuery xmlns="http://smartertools.com/smarterstats/query/"> <authUserName>string</authUserName> <authPassword>string</authPassword> <authorizationCode>string</authorizationCode> <queryName>string</queryName> <keyValuePairs> <string>string</string> <string>string</string> </keyValuePairs> </ExecuteQuery> </soap12:Body> </soap12:Envelope>
HTTP/1.1 200 OK Content-Type: application/soap+xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"> <soap12:Body> <ExecuteQueryResponse xmlns="http://smartertools.com/smarterstats/query/"> <ExecuteQueryResult> <Success>boolean</Success> <Completed>boolean</Completed> <CompletedPercent>int</CompletedPercent> <AsyncGuid>string</AsyncGuid> <QueryTimeMilliseconds>long</QueryTimeMilliseconds> <TableData> <QueryResultRow> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location xsi:nil="true" /> </QueryResultRow> <QueryResultRow> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location xsi:nil="true" /> </QueryResultRow> </TableData> <FooterUnknown> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterUnknown> <FooterOtherItems> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterOtherItems> <FooterTotals> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterTotals> </ExecuteQueryResult> </ExecuteQueryResponse> </soap12:Body> </soap12:Envelope>
HTTP GET
The following is a sample HTTP GET request and response. The placeholders shown need to be replaced with actual values.
GET /Services/Query.asmx/ExecuteQuery?authUserName=string&authPassword=string&authorizationCode=string&queryName=string&keyValuePairs=string&keyValuePairs=string HTTP/1.1 Host: stats.smartertools.com
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <QueryResult xmlns="http://smartertools.com/smarterstats/query/"> <Success>boolean</Success> <Completed>boolean</Completed> <CompletedPercent>int</CompletedPercent> <AsyncGuid>string</AsyncGuid> <QueryTimeMilliseconds>long</QueryTimeMilliseconds> <TableData> <QueryResultRow> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </QueryResultRow> <QueryResultRow> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </QueryResultRow> </TableData> <FooterUnknown> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterUnknown> <FooterOtherItems> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterOtherItems> <FooterTotals> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterTotals> </QueryResult>
HTTP POST
The following is a sample HTTP POST request and response. The placeholders shown need to be replaced with actual values.
POST /Services/Query.asmx/ExecuteQuery HTTP/1.1 Host: stats.smartertools.com Content-Type: application/x-www-form-urlencoded Content-Length: length authUserName=string&authPassword=string&authorizationCode=string&queryName=string&keyValuePairs=string&keyValuePairs=string
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <QueryResult xmlns="http://smartertools.com/smarterstats/query/"> <Success>boolean</Success> <Completed>boolean</Completed> <CompletedPercent>int</CompletedPercent> <AsyncGuid>string</AsyncGuid> <QueryTimeMilliseconds>long</QueryTimeMilliseconds> <TableData> <QueryResultRow> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </QueryResultRow> <QueryResultRow> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </QueryResultRow> </TableData> <FooterUnknown> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterUnknown> <FooterOtherItems> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterOtherItems> <FooterTotals> <ID>int</ID> <ItemCount>long</ItemCount> <DateTicks>long</DateTicks> <Name>string</Name> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <RegionCode>string</RegionCode> <RegionName>string</RegionName> <RegionFipsCode>string</RegionFipsCode> <City>string</City> <IpAddress>string</IpAddress> <Browser>string</Browser> <Device>string</Device> <BrowserVersion>string</BrowserVersion> <Platform>string</Platform> <SearchEngine>string</SearchEngine> <Phrase>string</Phrase> <ProtocolStatus>string</ProtocolStatus> <URIStemText>string</URIStemText> <BandwidthIn>long</BandwidthIn> <BandwidthOut>long</BandwidthOut> <DateOfLog>dateTime</DateOfLog> <DateFirst>dateTime</DateFirst> <DateLast>dateTime</DateLast> <ServerName>string</ServerName> <Username>string</Username> <Bounces>long</Bounces> <Entrances>long</Entrances> <Exits>long</Exits> <Visitors>long</Visitors> <UniqueVisits>long</UniqueVisits> <ReturnVisits>long</ReturnVisits> <NewVisits>long</NewVisits> <TimeTakenMs>long</TimeTakenMs> <VisitLengthSeconds>long</VisitLengthSeconds> <Hits>long</Hits> <Views>long</Views> <Visits>long</Visits> <BandwidthBytes>long</BandwidthBytes> <RawBandwidthBytes>long</RawBandwidthBytes> <FileBandwidth>long</FileBandwidth> <Keyword>string</Keyword> <SearchRank>int</SearchRank> <ResultCount>long</ResultCount> <ViewsDuringVisit>long</ViewsDuringVisit> <SiteUrl>string</SiteUrl> <SiteUrlLink>string</SiteUrlLink> <Location> <area_code>int</area_code> <city>string</city> <CountryCode>string</CountryCode> <CountryName>string</CountryName> <DmaCode>int</DmaCode> <Latitude>double</Latitude> <Longitude>double</Longitude> <PostalCode>string</PostalCode> <region>string</region> </Location> </FooterTotals> </QueryResult>