RareLogic Query API - Pages Report Sample

sample.rb

require 'oauth'

# A simple Pages pivoted by Category report for the current week
query_json = <<EOS
{
    "report": {
        "report_type": "standard",
        "pivots_attributes": [
            {
                "family": "content",
                "name": "category",
                "label": "Category"
            },
            {
                "family": "content",
                "name": "page",
                "label": "Page"
            }
        ],
        "columns_attributes": [
            {
                "attribute_family": "entity",
                "attribute_name": "uuid",
                "title": "People",
                "aggregator": "COUNT",
                "quantifier": "DISTINCT",
                "sort": "DESC"
            },
            {
                "attribute_family": "content",
                "attribute_name": "page",
                "title": "Page Views",
                "aggregator": "COUNT",
                "sort": "DESC"
            }
        ],
        "segment_attributes": {
            "name": "All Customers"
        }
    },
    "date_range": {
        "type": "this week"
    }
}
EOS

# Create the oAuth consumer
consumer = OAuth::Consumer.new( "_APP_KEY_", "_APP_SECRET_" )

# Create a request and get the response
response = consumer.request(
  :post,
  "https://api.rare.io/profiles/_PROFILE_ID_/query.csv",
  nil,
  {},
  query_json,
  { 'Content-Type' => 'application/json' }
)

# response contains the result in JSON, CSV or XML
puts response