Versions Compared

Version Old Version 1 New Version Current
Changes made by

Smita Nair (Deactivated)

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": "20202021-01-09T0514T09:2557:3224.744Z266Z",
    "created_at": "20202021-01-09T0514T09:2557:3224.744Z266Z",
    "id": "5e16b94ca02faf000174e96260001584c7f07c0001209773"
  },
  "eventInfo": {
    "type": "installed"
  },
  "hostInfo": {
    "clientKey": "506e6aa6b776f19a-8aba286b-374538f2-8da28f49-19ac84e3ef0ee60cf7e6ca51",
    "baseUrl": "https://rampatinaxxxxxxxxxx.atlassian.net/wiki",
    "productType": "confluence"
  },
  "pluginInfo": {
    "pluginsVersion": "1.583856.0",
    "pluginKey": "org.swift.confluence.markdownsql"
  }
}

Uninstall 

This data is collected each time the app is uninstalled. 

No Format
{
  "event": {
    "timestamp": "20202021-01-09T0513T06:2517:0700.738Z678Z",
    "created_at": "20202021-01-09T0513T06:2517:0700.738Z678Z",
    "id": "5e16b933ebf8a700013747ee5ffe905c700de90001a09cdc"
  },
  "eventInfo": {
    "type": "uninstalled"
  },
  "hostInfo": {
    "clientKey": "506e6aa6b776f19a-8aba286b-374538f2-8da28f49-19ac84e3ef0ee60cf7e6ca51",
    "baseUrl": "https://rampatinaxxxxxxxxxx.atlassian.net/wiki",
    "productType": "confluence"
  },
  "pluginInfo": {
    "pluginsVersion": "1.583851.0",
    "pluginKey": "org.swift.confluence.markdownsql"
  }
}

Global configuration 

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

No Format
{
  "event": { 
   	"timestamp": "20192021-1102-27T0615T05:4841:5633.776Z630Z", 
   	"created_at": "20192021-1102-27T0615T05:4841:5633.776Z630Z", 
   	"id": "5dde1c58e1658500019bd718602a098debb0130001027568" 
  }, 
  "eventInfo": { 
	"userId": "5d28bc13cbb3670c1fa15a6b", 
	"type": "globalconfigglobalConfig", 
   	"settings": { 
   	  "sendStatisticstransactionIsolation": true"NONE", 
	     "allowWhitelistedUrlslimit": false"5000",  
	  }
"rowsPerPage": "100"
	} 
  }, 
  "hostInfo": { 
   	"host": "https://bobswift22xxxxxxxxxx.atlassian.net/wiki" 
  }, 
  "pluginInfo": { 
   	"links": { 
 	    "marketplace": [ 
 	      { 
       		  "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.markdownsql" 
       		} 
   	  ], 
	     "self": [ 
		{ 
		     {
          "href": "https://bobswift22xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.markdownsql" 
       		} 
	    ] ]
    }, 
    "host": { 
   	  "product": "Confluence" 
    }, 
    "lastUpdated": "20192021-1102-27T0615T05:2204:10Z34Z", 
    "state": "ENABLED", 
    "version": "1.0", 
    "key": "org.swift.confluence.markdownsql", 
    "installedDate": "20192021-1102-27T0615T05:2204:10Z32Z" 
  }
}

...


Data source profile configuration

This data is collected when the user creates a new Profile on the Global Configuration page. collected when a Confluence administrator creates or updates a data source profile.

No Format
{
  "event": {
    "timestamp": "20202021-0102-09T0622T04:3354:1249.795Z969Z",
    "created_at": "20202021-0102-09T0622T04:3354:1249.795Z969Z",
    "id": "5e16c928e3f2e90001207812603339196d6b8400015ac5e6"
  },
  "eventInfo": {
    "typeprofileName": "addedtest",
    "settingstype": {
 "profileAdded",
    "userInUrlParamsuserId": false"5d28bc13cbb3670c1fa15a6b",
      "urlParamssettings": false,{
      "accessTokenuserName": true"",
      "accesstokenInUrlParamsauthType": false"basic",
      "urlpassword": true"",
      "accesstokenInHeaderParamslimitRowsProcessed": truenull,
      "headerParamslimitQueryTime": truenull,
      "passwordInUrlParamshostName": false"",
      "userInHeaderParamsportNumber": false243,
      "profileTypedatabaseName": "github",
      "passwordInHeaderParamsdatabaseType": false,
      "password": false,"postgresql"
      "user": false
    }
  },
  "hostInfo": {
    "host": "https://rampatinaxxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.markdownsql"
        }
      ],
      "self": [
        {
          "href": "https://rampatinaxxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.markdownsql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "20202021-0102-09T0522T04:2518:32Z51Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.markdownsql",
    "installedDate": "20202021-0102-09T0522T04:2518:31Z47Z"
  }
}

...


Macro configuration

This data is collected when the user updates a Profile on the Global Configuration page. collected when a user inserts or updated the configuration of an SQL for Confluence page macro.

No Format
{
  "event": {
    "timestamp": "20202021-01-09T0614T12:3208:3709.528Z730Z",
    "created_at": "20202021-01-09T0614T12:3208:3709.528Z730Z",
    "id": "5e16c905e232320001f157ca600034298d85f10001977434"
  },
  "eventInfo": {
    "typepageId": "updated146440216",
    "settingsmacroId": {
      "userInUrlParams": true,
 "a6654f12-bfba-4dd4-a735-cd5129fd7fa8",
    "urlParamsuserId": true,
 "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "accessTokenparameters": true,{
      "accesstokenInUrlParamsdisplayDataFilter": false"true",
      "urlpagination": "true",
      "accesstokenInHeaderParamsbodyData": true,
      "headerParamsdataSource": true,
      "passwordInUrlParams": false},
      "userInHeaderParamstype": false,
   "macroConfigured"
  },
  "hostInfo": {
    "profileTypehost": "gitlab",https://xxxxxxxxxx.atlassian.net/wiki"
   },
  "passwordInHeaderParamspluginInfo": false,
 {
    "passwordlinks": true,{
      "usermarketplace": [
false     }   },{
  "hostInfo": {     "host  "href": "https://rampatinamarketplace.atlassian.net/wiki"com/plugins/org.swift.confluence.sql"
     },   "pluginInfo":}
{     "links": { ],
      "marketplaceself": [
        {
          "href": "https://marketplacexxxxxxxxxx.atlassian.com/pluginsnet/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.markdownsql"
        }
      ],
    },
 "self   "host": [{
      "product": "Confluence"
{      },
    "hreflastUpdated": "https://rampatina.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.markdown"2021-01-14T09:57:22Z",
        }
      ]
    }"state": "ENABLED",
    "hostversion": {
 "1.0",
    "productkey": "Confluence"
    }org.swift.confluence.sql",
    "lastUpdatedinstalledDate": "20202021-01-09T0514T09:2557:32Z19Z",
    "state": "ENABLED",}
}


Page render

This data is collected each time the page with an SQL for Confluence macro is refreshed.

No Format
{
  "keen": {
    "versiontimestamp": "1.02021-01-14T12:05:49.682Z",
    "keycreated_at": "org.swift.confluence.markdown2021-01-14T12:05:49.682Z",
    "installedDateid": "2020-01-09T05:25:31Z6000339d6205f400018a1c87"
  }
}

New Markdown macro

This data is collected on the first instance when a user creates a page and inserts the macro.

No Format
{,
  "eventeventInfo": {
    "timestamppageId": "2019-11-27T08:52:58.364Z",
146440216",
    "created_atparameters": "2019-11-27T08:52:58.364Z", {
      "iddisplayDataFilter": "5dde396a5de5280001e3f0f6true"
  },
 
"eventInfo": {     "typepagination": "view-pagetrue",
      "macroNamebodyData": "markdown-url"true,
      "macroParmsdataSource": {true
      "url": true},
      "replaceuserId": true,
 "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "findrenderTime": true27545.864999992773,
 
    "allowHtmlmacroId": "falsea6654f12-bfba-4dd4-a735-cd5129fd7fa8",
      "tableClasstype": "@nonepageRender",
      "hardwrap": true
    }
  },
  "hostInfo": {
    "host": "https://bobswift22xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.markdownsql"
        }
      ],
      "self": [
        {
          "href": "https://bobswift22xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.markdownsql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "20192021-1101-27T0614T09:2257:10Z22Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.markdown",
    "installedDate": "2019-11-27T06:22:10Z"
  }
}

Whitelist configuration

This data is collected each time a URL is configured as a whitelisted URL.

No Format
{
  "event": {
    "timestampkey": "2019-11-27T06:52:18.465Zorg.swift.confluence.sql",
    "created_atinstalledDate": "20192021-1101-27T0614T09:5257:18.465Z19Z",
    "id": "5dde1d223699fe0001af2056"
  },}
}

Error

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

No Format
{
  "eventInfoevent": {
    "typetimestamp": "whitelistconfig"2021-02-24T12:26:49.161Z",
  },   "hostInfocreated_at": {
    "host": "https://bobswift22.atlassian.net/wiki"
  },2021-02-24T12:26:49.161Z",
    "pluginInfoid": {
    "links603646096cd44b00010da39d":
{    },
  "marketplaceeventInfo": [
        {
     
    "hrefpageId": "https://marketplace.atlassian.com/plugins/org.swift.confluence.markdown"
1000177665",
    "parameters": {
 }       ]"pagination": "false",
      "selfpageSize": [25,
        {
   "queryTimeout": 120,
      "hreflimit": "https://bobswift22.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.markdown"
"50",
      "dataSource": true,
       }"showSql": "true",
      "rowsPerPage": ]25
    },
    "hosttype": "pageRender",
  {  "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "productmacroId": "Confluence"
    }3b319870-29ab-4256-a67e-2de2b0e77ae4",
    "lastUpdatederror": "2019-11-27T06:22:10Z", {
      "statemessage": "ENABLEDProfile Not Found",
    "version": "1.0"},
    "keyrenderTime": "org.swift.confluence.markdown"6548.155000000406,
    "installedDatemacroName": "2019-11-27T06:22:10Zsql-query"
  }
}

Migration

This data is collected each time the administrator begins a server to cloud migration.

No Format
,
  "hostInfo": {
    "appKeyhost": "org.swift.confluence.markdown",
https://xxxxxxxxxx.atlassian.net/wiki"
  },
  "collectionNamepluginInfo":"servertocloudmigration", {
    "analyticsDatalinks": {
      "eventInfomarketplace": [
        {
          "href":   "type":"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",
 {
        "baseUrl":product"https://rampatinathree.atlassian.net/wiki",          "productType":"confluence"
 "Confluence"
    },
     "lastUpdated": "pluginInfo":{2021-02-24T08:22:43Z",
    "state": "ENABLED",
    "pluginsVersionversion": "1.821.0",
    
    "pluginKeykey": "org.swift.confluence.markdownsql",
      }
"installedDate": "2021-02-24T08:22:41Z"
  }
}