Versions Compared

Old Version 3

changes.mady.by.user Michael Kuhl

Saved on

compared with

New Version Current

changes.mady.by.user Nisha Shantilal

Saved on

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"
  }
}

...

This data is collected when the administrator changes the app's global configuration.  

No Format
{
  "event": { 
   	"timestamp": "2021-0102-06T0115T05:4541:2033.268Z630Z", 
   	"created_at": "2021-0102-06T0115T05:4541:2033.268Z630Z", 
   	"id": "5ff5163027d755000118b9cb602a098debb0130001027568" 
  }, 
  "eventInfo": { 
	"userId": "5d28bc13cbb3670c1fa15a6b", 
	"type": "globalconfigglobalConfig", 
   	"settings": { 
	     "allowJavaScripttransactionIsolation": true"NONE", 
 	    "sendStatisticslimit": true"5000",  
  	  "allowWhitelistedUrlsrowsPerPage": false"100"
	} 
  }, 
 },   "hostInfo": { 
   	"host": "https://bobswift13xxxxxxxxxx.atlassian.net/wiki" 
  }, 
  "pluginInfo": { 
   	"links": { 
   	  "marketplace": [ 
 	      { 
		         "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.refappsql" 
       		} 
   	  ], 
  	   "self": [ 
       		{ 
       		  "href": "https://bobswift13xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.refappsql" 
		} 
	  ] 
 }   }, 
  ]     },
    "host": { 
	     "product": "Confluence" 
    }, 
    "lastUpdated": "2021-0102-05T1815T05:5404:40Z34Z", 
    "state": "ENABLED", 
    "version": "1.0", 
    "key": "org.swift.confluence.refappsql", 
    "installedDate": "2021-0102-05T1815T05:5404:39Z32Z" 
  }
}


New macroData source profile configuration

This data is collected on the first instance when a user Confluence administrator creates a page and inserts the macroor updates a data source profile.

No Format
{
  "event": {
    "timestamp": "2021-0102-14T1222T04:0854:0949.730Z969Z",
    "created_at": "2021-0102-14T1222T04:0854:0949.730Z969Z",
    "id": "600034298d85f10001977434603339196d6b8400015ac5e6"
  },
  "eventInfo": {
    "pageIdprofileName": "146440216test",
    "macroIdtype": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8profileAdded",
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba29035d28bc13cbb3670c1fa15a6b",
    "parameterssettings": {
      "displayDataFilteruserName": "true",
      "paginationauthType": "truebasic",
      "bodyDatapassword": true"",
      "dataSourcelimitRowsProcessed": truenull,
      "limitQueryTime": }null,
      "typehostName": "macroConfigured",
  },    "hostInfoportNumber": 243,
{      "hostdatabaseName": "https://bobswift27.atlassian.net/wiki"",
      "databaseType": "postgresql"
    }
  },
  "hostInfo": {
    "host": "https://xxxxxxxxxx.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-0102-14T0922T04:5718:22Z51Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-0102-14T0922T04:5718:19Z47Z"
  }
}

...


Macro configuration

This data is collected each time the page with an when a user inserts or updated the configuration of an SQL for Confluence page macro is refreshed.

No Format
{
  "keenevent": {
    "timestamp": "2021-01-14T12:0508:4909.682Z730Z",
    "created_at": "2021-01-14T12:0508:4909.682Z730Z",
    "id": "6000339d6205f400018a1c87600034298d85f10001977434"
  },
  "eventInfo": {
    "pageId": "146440216",
    "parametersmacroId": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8",
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "parameters": {
      "displayDataFilter": "true",
      "pagination": "true",
      "bodyData": true,
      "dataSource": true
    },
    "userIdtype": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
 "macroConfigured"
  },
  "renderTimehostInfo": 27545.864999992773,{
    "macroIdhost": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8",
 https://xxxxxxxxxx.atlassian.net/wiki"
  },
  "typepluginInfo": "pageRender"
{
 },   "hostInfolinks": {
    "host": "https://bobswift27.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"
  }
}

...


Page render

This data is collected each time the

...

page with an SQL for Confluence macro is refreshed.

No Format
{
  "keen": {
    "appKeytimestamp":"org.swift.confluence.markdown",
   "collectionName":"servertocloudmigration",
   "analyticsData": "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://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-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": {
      "eventInfomarketplace": [
        {
          "typehref":"servertocloudmigration", "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
  "numberOfProfiles": 5,   ],
      "allowJavaScriptself": true,[
        {
"allowWhitelistUrls": true,          "sendStatistics": true"href": "https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        },
      "hostInfo":{]
    },
    "clientKeyhost":"2b27987a-108e-3992-9007-8e32e3c6696d",
 {
        "baseUrlproduct":"https://rampatinathree.atlassian.net/wiki", "Confluence"
    },
    "productTypelastUpdated":"confluence"
      },
 "2021-02-24T08:22:43Z",
     "pluginInfostate":{
     "ENABLED",
    "pluginsVersionversion": "1.821.0",
         "pluginKeykey": "org.swift.confluence.markdownsql",
      }
"installedDate": "2021-02-24T08:22:41Z"
  }
}