Versions Compared

Old Version 5

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.

...

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_COMMITTED100"
	} 	
  }, 
	  "limithostInfo": { 
		"newValuehost": "5000"https://xxxxxxxxxx.atlassian.net/wiki" 
  }, 
		  "oldValuepluginInfo": "1000"{ 
	  }, 
	  "rowsPerPage"links": { 
		"newValue": "100", 
		"oldValuemarketplace": "50"[ 
	  }  	} { 
 }, 		   "hostInfohref": {  	"host": "https://harinathhttps://marketplace.atlassian.net/wikicom/plugins/org.swift.confluence.sql" 
  		}, 
	  "pluginInfo": { 
	"links": { 
], 
	  "marketplaceself": [ 
		    { 
		  "href": "https://marketplacexxxxxxxxxx.atlassian.comnet/plugins/orgwiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql" 
		} 
	  ] 
    }, 
    "host": { 
	  "selfproduct": [ "Confluence" 
    }, 
		{  		  "hreflastUpdated": "https://harinath.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql" 
		} 
	  ]2021-02-15T05:04:34Z", 
    "state": "ENABLED", 
     }"version": "1.0", 
    "hostkey": { 
	  "product": "Confluence" 
    }"org.swift.confluence.sql", 
    "lastUpdatedinstalledDate": "2021-02-15T05:04:34Z32Z", 
    "state": "ENABLED", 
}
}


Data source profile configuration

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

No Format
{
   "versionevent": "1.0", {
    "keytimestamp": "org.swift.confluence.sql", 2021-02-22T04:54:49.969Z",
    "installedDatecreated_at": "2021-02-15T0522T04:0454:32Z49.969Z",
   }
}

New macro

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

No Format
{ "id": "603339196d6b8400015ac5e6"
  },
  "eventeventInfo": {
    "timestampprofileName": "2021-01-14T12:08:09.730Ztest",
    "created_attype": "2021-01-14T12:08:09.730ZprofileAdded",
    "iduserId": "600034298d85f100019774345d28bc13cbb3670c1fa15a6b",
  },   "eventInfosettings": {
      "pageIduserName": "146440216",
      "macroIdauthType": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8basic",
      "userIdpassword": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
",
      "parameterslimitRowsProcessed": {null,
      "displayDataFilterlimitQueryTime": "true"null,
      "paginationhostName": "true",
      "bodyDataportNumber": true243,
      "dataSourcedatabaseName": true
  "",
 },     "typedatabaseType": "macroConfiguredpostgresql"
    }
  },
  "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": {
    "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"
  }
}