Article Details
Id:13012
Product:finPOWER Connect
Type:NEW
Version:2.03.00
Opened:11/05/2015
Closed:18/06/2015
Released:09/07/2015
Job: J015441
High Importance
Breaking Change

Service Logs; new field "PurgeAction" to assist purging of data

A new field "PurgeAction" has been added to the "ISServiceLog" table. The Service Log table holds a record of web service calls. This information can get very large over time, but most of the information is very important.

The Database Purge now has additional settings to purge and/ or clear Service Logs. There is an option to "Purge Service Logs flagged as purgeable?" which utilises this new "PurgeAction" field. In addition the Clear Service Log Request/ Response details utilises this flag as noted below.

Clear Request/ Response

The following web service requests flag the Request and Response details as not being required, and therefore can be cleared during the purge if the "Clear Service Log Request/ Response details?" is checked and the date of the request is on or before the date selected.

  • Credit Enquiry, ABN Lookup; Business Enquiry
  • Credit Enquiry, Bank Statements; Create Request
  • Credit Enquiry, Bank Statements; Delete Request
  • Credit Enquiry, Bank Statements; Download Data
  • Credit Enquiry, Bank Statements; View Request
  • Credit Enquiry, CentrixNZ; Commercial Credit Report
  • Credit Enquiry, CentrixNZ; Consumer Credit Check
  • Credit Enquiry, CentrixNZ; Consumer Product Enquiry
  • Credit Enquiry, CreditSense; Application Status
  • Credit Enquiry, CreditSense; Create Token
  • Credit Enquiry, CreditSense; Download Bank Xml
  • Credit Enquiry, CreditSense; Expire Token
  • Credit Enquiry, GreenId; Background Check

Purge Record

The following web service requests flag the ISServiceLog record as able to be deleted during a purge, if the "Purge Service Logs flagged as purgeable?" option is checked. None of these requests are important, e.g. they are ping tests on the web service.

  • Credit Enquiry, ABN Lookup; Business Selection
  • Credit Enquiry, BankStatements; ClientLogin
  • Credit Enquiry, BankStatements; GetInstitutions
  • Credit Enquiry, BankStatements; Verify
  • Credit Enquiry, Centrix NZ; Commercial Search
  • Credit Enquiry, Companies Office NZ; Entity Search
  • Credit Enquiry, CreditSense; GetSessionId
  • Credit Enquiry, CreditSense; RequestPing
  • Credit Enquiry, CreditWorks NZ; Company Search
  • Credit Enquiry, CreditWorks NZ; GetSessionTicketUid
  • Credit Enquiry, VedaConnect AU; Ticket Response
  • Credit Enquiry, VedaXML AU; Company Selection
  • Credit Enquiry, VedaXML AU; VerifyConnection
  • Credit Enquiry, VedaXML NZ; VerifyConnection
  • Security Enquiry, MotorWeb; Ping

Purge Record (after 30 Days)

The following web service requests flag the ISServiceLog record as able to be deleted during a purge, if the "Purge Service Logs flagged as purgeable?" option is checked and they are older than 30 days. None of these requests are important, e.g. they are ping tests on the web service.

  • Credit Enquiry, CreditSense; Update Application Settings
  • Security Enquiry, MotorWeb; VirPDF