Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

REST API to return data in JSON format

Is there any REST API in Vertica that will return data in JSON format?

Comments

  • edited August 2017

    Hi!

    Management API

    The Management API is a REST API that you can use to view and manage Vertica databases with scripts or applications that accept REST and JSON. The response format for all requests is JSON.

    The Management API provides a subset of the database administration tools found in the Management Console. Features include the ability to:

    • View host and network details for each node
    • View details on database version, structure, and state
    • View and update licenses
    • Start and stop databases on the entire cluster or individual nodes
    • View details about available database backups, start a new database backup, and restore backups from specific archives
    • View and set database configuration parameters
    • Add hosts to the database, remove hosts from the database, and replace hosts with standby hosts
    • Create and delete databases
    • View a list of running jobs
    • Run rebalance or workload analyzer on a database
    • Create and manage event listeners (also known as webhooks)

    For example:

    [email protected]:~$ curl -H "VerticaApiKey: <key>" --insecure https://localhost:5444/hosts | json_pp 
      % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                     Dload  Upload   Total   Spent    Left  Speed
    100   624  100   624    0     0   2478      0 --:--:-- --:--:-- --:--:--  2486
    {
       "href" : "/hosts",
       "links" : [
          "/:hostid"
       ],
       "mime-type" : "application/vertica.hosts.json-v2",
       "body" : [
          {
             "max_user_proc" : "31764",
             "vertica" : {
                "arch" : "iamd64",
                "release" : "6",
                "version" : "8.0.1",
                "brand" : "vertica"
             },
             "total_memory" : 7966,
             "nics" : [
                {
                   "name" : "eth0",
                   "speed" : "1000",
                   "broadcast" : "192.168.9.255",
                   "ipaddr" : "192.168.9.134",
                   "netmask" : "255.255.255.0"
                },
                {
                   "ipaddr" : "127.0.0.1",
                   "broadcast" : "255.255.255.255",
                   "netmask" : "255.0.0.0",
                   "speed" : "locallink",
                   "name" : "lo"
                }
             ],
             "cpu_info" : {
                "cpu_type" : " Intel(R) Core(TM) i5-4670K CPU @ 3.40GHz",
                "number_of_cpus" : 2
             },
             "hostname" : "synapse",
             "host_id" : "127.0.0.1"
          }
       ]
    }
    
    
  • edited August 2017

    Thank you for this detailed response

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.