Google Drive

Connect AnyLog to Google Sheets/Drive via the Two Minute Reports add-on to pull query results into reports and graphs.

To extract data from AnyLog into Google Drive we recommend using a tool called Two Minute Reports which provides the ability to import data via REST, Database, Social Media and other SEO services.

Install

  1. Under Extensions goto Add-ons → Get add-ons extensions → add-ons

  2. In the search bar look for “Two Minute Reports” & double click it software list

  3. Install the add-on to your Google Sheets & press “continue”

| install screen 1 | install screen 2 | | — | — |

  1. Google Requires users to confirm - click on the user you’d like to install the application on & press “Allow”

| confirm account | grant permission | | — | — |

Executing REST Request

  1. Once that’s completed launch Two Minute Reports: Extensions → Two Minute_Reports → Launch path Note: Two Minute Reports works best when only a single account is logged in.

  2. Press “Add+” to connect to a new REST connection add

  3. Under Data Source set the Type to API Bridge & Fill-out the form

Notice that for the complete form user should specifiy: Base URL, Authentication (if set) and headers.
For demo purposes, I’m using a query that consists of increments function and returns the data as a list of JSON values without statistics:

sql aiops format=json:list and stat=false "select increments(hour, 1, timestamp), min(timestamp) as timestamp, min(value) as min_value, avg(value) as avg_value, max(value) as max_value from sic1001_mv where timestamp >= NOW() - 1 week"

| type | form | | — | — |

  1. Once the form is complete, test and save the changes - this will validate that the request is valid

| test & save | confirm | | — | — |

  1. In menu, goto Data Queries

menu options

  1. Press Add+ to create a new Query Form

add query form

  1. Fill-out the form, setting Data Source to be the same as the the one created earlier & press “Run Query”

complete form

The steps mentioned above will ultimately result in a table similar to the one shown on the right of the image; with it users can generate images and graphs as shown on the right side of the image, just like any other data set

table & graph