VSI 5 Enterprise Summary Export - 12 Months of Data

README.md

VSI 5 Enterprise Summary Export - 12 Months of Data

This gist contains a few exmaples of how to export your VSI data. In particular, 12 months of enterprise summary data. You can export to either a CSV file or a JSON file allowing you to then import the data into any analytics tool you choose.

This is a RESTful API call, so you need to create a script that can make an HTTP POST request to https://vsi5.visualstorageintelligence.com/api/export/v1/enterprise_summary_12_months. The payload you post should be in JSON format and should contain the following key value pairs:

output_format: "csv" or "json" request_user: the email address you use to login to VSI request_password: the password you use to login to VSI

This gist provides 3 examples: one in curl, one in PowerShell, and one in Python 3.

vsi5_export_12_months_enterprise_summary.ps1

$headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$headers.Add("Content-Type", "application/json")

$body = "{
`n    `"export_format`": `"json`",
`n    `"request_user`": `"your email address here`",
`n    `"request_password`": `"your password here`"
`n}"

$response = Invoke-RestMethod 'https://vsi5.visualstorageintelligence.com/api/export/v1/enterprise_summary_12_months' -Method 'POST' -Headers $headers -Body $body
$response | ConvertTo-Json

vsi5_export_12_months_enterprise_summary.sh

/api/export/v1/enterprise_summary_12_months

curl --location --request POST 'https://vsi5.visualstorageintelligence.com/api/export/v1/enterprise_summary_12_months' \
--header 'Content-Type: application/json' \
--data-raw '{
    "export_format": "json",
    "request_user": "your email here",
    "request_password": "your password here"
}'

vsi5_export_12_months_enterprise_summery.py

import http.client
import json

conn = http.client.HTTPSConnection("vsi5.visualstorageintelligence.com")
payload = json.dumps({
  "export_format": "json",
  "request_user": "your email here",
  "request_password": "your password here"
})
headers = {
  'Content-Type': 'application/json'
}
conn.request("POST", "/api/export/v1/enterprise_summary_12_months", payload, headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))