Versions Compared

Version Old Version 4 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.

...

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", 
			  "newValuelimit": "NONE5000",  
			  "oldValuerowsPerPage": "READ_COMMITTED"100"
	} 
  		}, 
 		 "limithostInfo": { 
			"newValuehost": "5000", 
			"oldValue": "1000" 
		https://xxxxxxxxxx.atlassian.net/wiki" 
  }, 
		  "rowsPerPagepluginInfo": { 
			"newValuelinks": "100",{ 
			  "oldValuemarketplace": "50"[ 
		}  	}  { 
},		    "hostInfohref": { 
	"host": "https://harinathmarketplace.atlassian.net/wikicom/plugins/org.swift.confluence.sql" 
  		}, 
	  "pluginInfo": {], 
	"links": {  		"marketplaceself": [ 
		  { 
			  "href": "https://marketplacexxxxxxxxxx.atlassian.com/pluginsnet/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql" 
		} 
}	  		], 
		"self] 
    }, 
    "host": [{ 
		  {  			"hrefproduct": "https://harinath.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql" 
		  } 
		] 
	}, 
	"host": { 
		"product": "Confluence" 
	}, 
	"lastUpdated": "2021-02-15T05:04:34Z", 
	"state": "ENABLED", 
	"version": "1.0", 
	"key": "org.swift.confluence.sql", 
	"installedDate": "2021-02-15T05:04:32Z" 
  }
}

New macro

This data is collected on the first instance when a user creates a page and inserts the 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"Confluence" 
    }, 
    "lastUpdated": "2021-02-15T05:04:34Z", 
    "state": "ENABLED", 
    "version": "1.0", 
    "key": "org.swift.confluence.sql", 
    "installedDate": "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://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-22T04:18:51Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-02-22T04:18:47Z"
  }
}


Macro configuration

This data is collected when a user 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://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": {
      "displayDataFilterproduct": "trueConfluence",
    },
    "paginationlastUpdated": "true2021-01-14T09:57:22Z",
      "bodyDatastate": true,
      "dataSource": true
    }"ENABLED",
    "typeversion": "macroConfigured1.0"
,
 },   "hostInfokey": {"org.swift.confluence.sql",
    "hostinstalledDate": "https://bobswift27.atlassian.net/wiki"
  },
  "pluginInfo2021-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": {
    "linkstimestamp": {
      "marketplace": [
        {
     "2021-01-14T12:05:49.682Z",
    "hrefcreated_at": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"2021-01-14T12:05:49.682Z",
    "id": "6000339d6205f400018a1c87"
  },
  "eventInfo": {
     ],
 "pageId": "146440216",
    "selfparameters": [{
      "displayDataFilter":  {"true",
      "pagination": "true",
     "href": "https://bobswift21.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
 "bodyData": true,
      "dataSource": true
    },
    "userId":  ]"557058:1701f082-9690-4a9d-8581-022b7fba2903",
     }"renderTime": 27545.864999992773,
    "hostmacroId": {
 "a6654f12-bfba-4dd4-a735-cd5129fd7fa8",
    "producttype": "ConfluencepageRender"
  },
 }, "hostInfo": {
    "lastUpdatedhost": "2021-01-14T09:57:22Z",https://xxxxxxxxxx.atlassian.net/wiki"
  },
  "statepluginInfo": "ENABLED",{
    "versionlinks": "1.0", {
      "keymarketplace": "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": {     "timestamphref": "2021-01-14T12:05:49.682Z",https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "created_atself": "2021-01-14T12:05:49.682Z",
 [
        {
   "id": "6000339d6205f400018a1c87"   },   "href"eventInfo: ": {
    "pageId": "146440216",https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
     "parameters": {  }
    "displayDataFilter": "true", ]
     "pagination": "true",
},
     "bodyDatahost": true,{
      "dataSourceproduct": true"Confluence"
    },
    "userIdlastUpdated": "557058:1701f0822021-9690-4a9d-8581-022b7fba290301-14T09:57:22Z",
    "renderTimestate": 27545.864999992773,
    "macroId": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8"ENABLED",
    "typeversion": "pageRender"
"1.0",
 },   "hostInfokey": {"org.swift.confluence.sql",
    "hostinstalledDate": "https://bobswift27.atlassian.net/wiki"
  },
  "pluginInfo2021-01-14T09:57:19Z"
  }
}

Error

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

No Format
{
  "event": {
    "linkstimestamp": {
 "2021-02-24T12:26:49.161Z",
    "marketplacecreated_at": [
"2021-02-24T12:26:49.161Z",
    "id": "603646096cd44b00010da39d"
 { },
  "eventInfo": {
     "hrefpageId": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"1000177665",
        }
      ],"parameters": {
      "selfpagination": ["false",
      "pageSize": 25,
{         "queryTimeout": 120,
 "href": "https://bobswift21.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"    "limit": "50",
   }   "dataSource": true,
  ]     },"showSql": "true",
      "hostrowsPerPage": {25
    },
    "producttype": "ConfluencepageRender",
    } "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "lastUpdatedmacroId": "2021-01-14T09:57:22Z3b319870-29ab-4256-a67e-2de2b0e77ae4",
    "stateerror": "ENABLED", {
      "versionmessage": "1.0"Profile Not Found"
    },
    "keyrenderTime": "org.swift.confluence.sql"6548.155000000406,
    "installedDatemacroName": "2021-01-14T09:57:19Zsql-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": [
        {
          "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"
  }
}