Versions Compared

Old Version 2

changes.mady.by.user Smita Nair

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.

...

The app collects limited information to help us determine the areas to focus on our future releases. We include the Support Entitlement Number (SEN) and other anonymous identifiers to improve the customer support experience.  All fields that could potentially contain personally identifiable information are cleansed of that data before it is transmitted to our servers.

Info

You can opt-out at any point by toggling the analytics option to "off" within the app's Global Configuration screen.

...

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": null,
 true     },"limitQueryTime": null,
      "typehostName": "macroConfigured",
      "portNumber": 243,
      "databaseName": "",
      "databaseType": "postgresql"
    }
  },
  "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-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": {
      "hostmarketplace": "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"
  }
}