3e650e67-d23d-4b04-bb40-eb389dc40a5f Webhook Retention Adds a new route, /Webhooks/Messages/Retention - which is a DELETE request.&#13;&#10;&#13;&#10;Invoking this route will delete old webhook messages (and their responses) if they are more than a configured number of days old.&#13;&#10;&#13;&#10;A system setting, WebHookMessageRetentionDays defines the number of days to retain the sent and not permanently failed webhook messages. true false 1 Jiwa Financials 7.2.1.0 using System; using System.Collections; using System.Linq; using ServiceStack; using ServiceStack.Model; using ServiceStack.Host; using System.Reflection; using ServiceStack.OrmLite; namespace JiwaFinancials.Jiwa.JiwaServiceModel { public class WebHookRetentionRESTAPIPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaRESTAPIPlugin { public static int WebHookMessageRetentionDays = 30; #region "Configuration" public void Configure(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin, ServiceStack.ServiceStackHost AppHost, Funq.Container Container, JiwaApplication.Manager JiwaApplicationManager) { // Read system setting value WebHookMessageRetentionDays = Plugin.Manager.Database.ReadSystemSetting<int>(Plugin.Name, "WebHookMessageRetentionDays", 30); AppHost.RegisterService<WebhookServices>(); AppHost.Routes.Add(typeof(WebhooksMessagedApplyRetentionPolicyRequest), "/Webhooks/Messages/Retention", "DELETE", "Removes sent or permanently failed webhook messages older than the retention period", ""); // Need to add a AssemblyResolve handler so this plugin can find the REST API plugin (as it has it as a plugin reference). // temporary work-around for https://jiwa.atlassian.net/browse/DEV-9893 AppDomain.CurrentDomain.AssemblyResolve += delegate(object sender, System.ResolveEventArgs args) { return AssemblyResolve(sender, args, Plugin); }; } public System.Reflection.Assembly AssemblyResolve(object sender, System.ResolveEventArgs args, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { // If the requested assembly is a reference to another plugin, then we need to attempt to resolve the assembly ourselves foreach(JiwaApplication.Plugin.PluginReference pluginReference in Plugin.PluginReferenceCollection) { if (String.Format("{0}, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null", pluginReference.Name) == args.Name) { return System.Reflection.Assembly.LoadFile(pluginReference.Plugin.RuntimeFileName); } } return null; } #endregion } #region "Requests" [ApiResponse(204, "Deleted OK")] [ApiResponse(401, "Not authenticated")] [ApiResponse(403, "Not authorised")] public class WebhooksMessagedApplyRetentionPolicyRequest { } #endregion #region "Services" [CompressResponse] public class WebhookServices : Service { public void Delete(WebhooksMessagedApplyRetentionPolicyRequest request) { // Remove from database using(var db = RESTAPIPlugin.AppHost.GetDbConnection()) { db.ExecuteSql(@"DELETE FROM SY_WebhookMessage WHERE DATEDIFF(DAY, LastSavedDateTime, SYSUTCDATETIME()) > @RetentionDays AND (Status = 1 OR Status = 3)", new { RetentionDays = WebHookRetentionRESTAPIPlugin.WebHookMessageRetentionDays }); db.Close(); } // Also remove any in-memory WebhookMessages in the API service. We need to do this, because the API service won't know about our database deletion above. RESTAPIPlugin.WebhookMessages.RemoveAll(x => (DateTime.UtcNow - x.LastSavedDateTime).TotalDays > WebHookRetentionRESTAPIPlugin.WebHookMessageRetentionDays && (x.Status == 1 || x.Status == 3)); } } #endregion } Abort CSharp 6dca9501-3f98-4b40-a4c0-716fed9e014e JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaApplication.dll 533884ef-fc07-41e0-a77f-ee995ebd9523 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll fa3198f1-3f7f-47a5-830b-c00023a2dbaf System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll 303e229f-fb18-4894-b6f4-7ac060a94d9a System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Data.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll f60faa51-849f-4977-97cc-dc2d552866d0 System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Runtime.Serialization.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll 0629ab5b-e8f1-4df8-b603-502911b21f9f System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Security.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll 3c54dd10-da2e-49ab-a597-c70f39ef36dd System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Core.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll b9d95434-51f9-4543-a6d4-eb26183a13b5 System.Net, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Net.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Net\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Net.dll f9651bf5-c9c2-424f-bc44-6f8c835bc384 System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Web.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Web\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.dll 2b8c8c16-cc21-4ee4-8d21-70972099264f ServiceStack.Common, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Common.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\ServiceStack.Common.dll 73ac9085-79b9-4e13-97eb-8bba1fb0e47f ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\ServiceStack.dll 577ccb17-9bc0-4561-ad93-7a4f3eff2442 ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\ServiceStack.Interfaces.dll 77385a75-128a-489d-a495-1f6f21a5caea ServiceStack.Server, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Server.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\ServiceStack.Server.dll 808ee200-cd85-455c-995c-7a535f00c64e ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\ServiceStack.Text.dll 51aae69c-c83a-4284-8420-a6f857182671 ServiceStack.OrmLite.SqlServer, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.OrmLite.SqlServer.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\ServiceStack.OrmLite.SqlServer.dll 56a545fa-9e6f-4183-b7ad-ee96c2ffe074 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaServiceModel.dll bf232b07-763f-4905-87a7-c1f3df0a080e JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaODBC.dll 54c070d5-a0fe-4de0-a3eb-bf97e715a70b ServiceStack.OrmLite, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.OrmLite.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\ServiceStack.OrmLite.dll 427c1a7877944ebeb4d2 WebHookMessageRetentionDays Number of days to retain and not permanently failed webhookmessages. Messages and their responses older than this are deleted 1 Integer 30 30 cfabbc38-5172-408e-b6a1-4b69f339380e fb0c1ea8-c560-41ef-b718-f0dc70ba89b9 REST API Provides a REST HTTP endpoint with some routes. Jiwa Financials false 0