Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
{
  "event": {
    "timestamp": "2021-01-14T09:57:24.266Z",
    "created_at": "2021-01-14T09:57:24.266Z",
    "id": "60001584c7f07c0001209773"
  },
  "eventInfo": {
    "type": "installed"
  },
  "hostInfo": {
    "clientKey": "b776f19a-286b-38f2-8f49-e60cf7e6ca51",
    "baseUrl": "https://bobswift21xxxxxxxxxx.atlassian.net/wiki",
    "productType": "confluence"
  },
  "pluginInfo": {
    "pluginsVersion": "1.856.0",
    "pluginKey": "org.swift.confluence.sql"
  }
}

...

No Format
{
  "event": {
    "timestamp": "2021-01-13T06:17:00.678Z",
    "created_at": "2021-01-13T06:17:00.678Z",
    "id": "5ffe905c700de90001a09cdc"
  },
  "eventInfo": {
    "type": "uninstalled"
  },
  "hostInfo": {
    "clientKey": "b776f19a-286b-38f2-8f49-e60cf7e6ca51",
    "baseUrl": "https://bobswift21xxxxxxxxxx.atlassian.net/wiki",
    "productType": "confluence"
  },
  "pluginInfo": {
    "pluginsVersion": "1.851.0",
    "pluginKey": "org.swift.confluence.sql"
  }
}

...

No Format
{
  "event": { 
	"timestamp": "2021-02-15T05:41:33.630Z", 
	"created_at": "2021-02-15T05:41:33.630Z", 
	"id": "602a098debb0130001027568" 
  }, 
  "eventInfo": { 
	"userId": "5d28bc13cbb3670c1fa15a6b", 
	"type": "globalConfig", 
	"settings": { 
	  "transactionIsolation": {"NONE", 
	  "limit": "5000",  
	  "newValuerowsPerPage": "NONE", 
		"oldValue": "READ_COMMITTED" 
	  }, 
	  "limit": 100"
	} 
  }, 
  "hostInfo": { 
	"host": "https://xxxxxxxxxx.atlassian.net/wiki" 
  }, 
  "pluginInfo": { 
	"links": { 
	  "marketplace": [ 
	    { 
		  "newValuehref": "5000",https://marketplace.atlassian.com/plugins/org.swift.confluence.sql" 
		} 
	  ], 
	  "self": [ 
		{ 
		  "oldValuehref": "1000https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql" 
		} 
	  ] 
    }, 
 	   "rowsPerPagehost": { 
		"newValue  "product": "Confluence" 
    }, 
    "lastUpdated": "2021-02-15T05:04:34Z", 
    "state": "ENABLED", 
    "version": "1.0", 
    "key": "100org.swift.confluence.sql", 
  		  "oldValueinstalledDate": "50"2021-02-15T05:04:32Z" 
 	 }
} 
	} 
  }, 


Data source profile configuration

This data is collected when a Confluence administrator creates or updates a data source profile.

No Format
{
  "event": {
    "timestamp": "2021-02-22T04:54:49.969Z",
    "created_at": "2021-02-22T04:54:49.969Z",
    "id": "603339196d6b8400015ac5e6"
  },
  "eventInfo": {
    "profileName": "test",
    "type": "profileAdded",
    "userId": "5d28bc13cbb3670c1fa15a6b",
    "settings": {
      "userName": "",
      "authType": "basic",
      "password": "",
      "limitRowsProcessed": null,
      "limitQueryTime": null,
      "hostName": "",
      "portNumber": 243,
      "databaseName": "",
      "databaseType": "postgresql"
    }
  },
  "hostInfo": {
    	"host": "https://harinathxxxxxxxxxx.atlassian.net/wiki"
   }, 
  "pluginInfo": {
  	  "links": {
 	     "marketplace": [
    	    {
       		   "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
    		    }
 	     ],
    	  "self": [
    		{    {
        		  "href": "https://harinathxxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
       		 }
    	  ]
     },
     "host": {
 	     "product": "Confluence" 
    },
     "lastUpdated": "2021-02-15T0522T04:0418:34Z51Z", 
    "state": "ENABLED", 
    "version": "1.0",
     "key": "org.swift.confluence.sql",
     "installedDate": "2021-02-15T0522T04:0418:32Z47Z"
   }
}


New macroMacro configuration

This data is collected on the first instance when a user creates a page and inserts or updated the configuration of anĀ SQL for Confluence page macro.

No Format
{
  "event": {
    "timestamp": "2021-01-14T12:08:09.730Z",
    "created_at": "2021-01-14T12:08:09.730Z",
    "id": "600034298d85f10001977434"
  },
  "eventInfo": {
    "pageId": "146440216",
    "macroId": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8",
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "parameters": {
      "displayDataFilter": "true",
      "pagination": "true",
      "bodyData": true,
      "dataSource": true
    },
    "type": "macroConfigured"
  },
  "hostInfo": {
    "host": "https://bobswift27xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://bobswift21xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-01-14T09:57:22Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-01-14T09:57:19Z"
  }
}

...

No Format
{
  "keen": {
    "timestamp": "2021-01-14T12:05:49.682Z",
    "created_at": "2021-01-14T12:05:49.682Z",
    "id": "6000339d6205f400018a1c87"
  },
  "eventInfo": {
    "pageId": "146440216",
    "parameters": {
      "displayDataFilter": "true",
      "pagination": "true",
      "bodyData": true,
      "dataSource": true
    },
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "renderTime": 27545.864999992773,
    "macroId": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8",
    "type": "pageRender"
  },
  "hostInfo": {
    "host": "https://bobswift27xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://bobswift21xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-01-14T09:57:22Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-01-14T09:57:19Z"
  }
}

Error

This data is collected whenever a user encounters an error usingĀ SQL for Confluence.

No Format
{
  "event": {
    "timestamp": "2021-02-24T12:26:49.161Z",
    "created_at": "2021-02-24T12:26:49.161Z",
    "id": "603646096cd44b00010da39d"
  },
  "eventInfo": {
    "pageId": "1000177665",
    "parameters": {
      "pagination": "false",
      "pageSize": 25,
      "queryTimeout": 120,
      "limit": "50",
      "dataSource": true,
      "showSql": "true",
      "rowsPerPage": 25
    },
    "type": "pageRender",
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "macroId": "3b319870-29ab-4256-a67e-2de2b0e77ae4",
    "error": {
      "message": "Profile Not Found"
    },
    "renderTime": 6548.155000000406,
    "macroName": "sql-query"
  },
  "hostInfo": {
    "host": "https://xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-02-24T08:22:43Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-02-24T08:22:41Z"
  }
}