Get Delinquency Information
Once an account becomes delinquent, they are sent three notices and then a final cut off notice. This method returns the dates and status of each notice.
The OutputParms returns any exemptions that have been granted to the customer, such as for bankruptcy.
Name | Type | Length | Description |
---|---|---|---|
customerNumber | numeric | 9 | [Required] Customer Number. See Account Search methods. |
locationNumber | numeric | 9 | [Required] Location Number. See Account Search methods. |
GET http://localhost/FusionServices/v3/Naviline/Utilities/DelinquencyInfo/{customerNumber}/{locationNumber}
Name | Description |
---|---|
TDLQAMT | Delinquent Amount that was originally past due. |
TDLQLEFT | Delinquent Amount that is remaining to be paid. |
TCUTDT | Service Cut Off Date if delinquency is not paid. Format: mmddyyyy |
TCUTPRC | Servcie Cut Off notice processed. Y=notice was sent |
T1NOTDT | Date First Notice of delinquency will be sent. Format: mmddyyyy |
T1NOTPRC | First Notice processed. Y=notice was sent |
T2NOTDT | Date Second Notice of delinquency will be sent. Format: mmddyyyy |
T2NOTPRC | Second Notice processed. Y=notice was sent |
T3NOTDT | Date Third Notice of delinquency will be sent. Format: mmddyyyy |
T3NOTPRC | Third Notice processed. Y=notice was sent |
CutOffExemptCode | Code value indicating customer is exempt from service cut off. |
CutOffExemptDesc | Description of reason customer is exempt from service cut off. |
CutOffValidThruDate | Date the cut off exemption is valid thru. Format: mmddyyyy 00000000=no exemption |
DelqExemptCode | Code value indicating customer is exempt from delinquency. |
DelqExemptDesc | Description of reason customer is exempt from delinquency. |
DelqValidThruDate | Date the delinquency exemption is valid thru. Format: mmddyyyy 00000000=no exemption |
CustSpecialCode | Code value indicating special status for the customer. |
CustSpecialCodeDesc | Description of special status for the customer. |
AcctStatusFlag | AccountStatus code indicating if a utility account is active or otherwise. |
ErrorCode | 0000=Deliquency info returned. 0001=No delinquency found. |
using System.Net;
using Newtonsoft.Json.Linq;
public void MethodName(parms)
{
string uri = "http://localhost/FusionServices/v3/Naviline/Utilities/DelinquencyInfo/473/22910";
WebClient wc = new WebClient();
wc.Headers.Set("X-APPID", "YOURID");
wc.Headers.Set("X-APPKEY", "YOURKEY");
string stringResult = wc.DownloadString(new Uri(uri));
JObject response = JObject.Parse(stringResult);
string error = response["OutputParms"]["ErrorCode"].ToString();
if (error == "0000")
{
JArray jRows = (JArray)response["Rows"];
foreach (JObject row in jRows)
{
string TDLQAMT = row["TDLQAMT"].ToString();
string TDLQLEFT = row["TDLQLEFT"].ToString();
string TCUTDT = row["TCUTDT"].ToString();
string TCUTPRC = row["TCUTPRC"].ToString();
string T1NOTDT = row["T1NOTDT"].ToString();
string T1NOTPRC = row["T1NOTPRC"].ToString();
string T2NOTDT = row["T2NOTDT"].ToString();
string T2NOTPRC = row["T2NOTPRC"].ToString();
string T3NOTDT = row["T3NOTDT"].ToString();
string T3NOTPRC = row["T3NOTPRC"].ToString();
// TODO - YOUR CODE HERE
}
}
}
$.get('http://localhost/FusionServices/v3/Naviline/Utilities/DelinquencyInfo/473/22910', function(response) {
$('#resultDiv).html(response);
});
using System;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
using System.Collections.Specialized;
using FusionServiceHelper.Models;
// NOTE: Use the namespace generated when you add the class, so that it is correct.
namespace FusionRazor.Models
{
public class GetDelinquencyInfo
{
// Add property for each input param in order to map a field to it
[Required(ErrorMessage = "Required")]
[RegularExpression("[0-9]{0,9}", ErrorMessage = "Numeric values only. Must be 9 digits or less. ")]
public string customerNumber{get; set;}
[Required(ErrorMessage = "Required")]
[RegularExpression("[0-9]{0,9}", ErrorMessage = "Numeric values only. Must be 9 digits or less. ")]
public string locationNumber{get; set;}
public GetDelinquencyInfo()
{
//Set any defaults here
customerNumber = DefaultData.Get("customerNumber");
locationNumber = DefaultData.Get("locationNumber");
}
}
}
@* NOTE: Use Add->View to add the View. *@
@* NOTE: Check the 'Create strongly-typed view checkbox, and select the GetDelinquencyInfo class. *@
@* NOTE: Select Edit as the Scaffold template. *@
@* NOTE: Use the @model line that is generated at the top. Replace the rest with the lines below.
@model FusionRazor.Models.GetDelinquencyInfo
@{
ViewBag.Title = "GetDelinquencyInfo";
string myUrl = "http://localhost/FusionServices/v3/Naviline/Utilities/DelinquencyInfo/" + Model.customerNumber + "/" + Model.locationNumber;
}
<h2>GetDelinquencyInfo</h2>
@using (Html.BeginForm()) {
@Html.AntiForgeryToken()
@Html.ValidationSummary(true)
<fieldset>
<legend>GetDelinquencyInfo</legend>
<div class="editor-label">Use the fields below to change the values and resubmit.</div>
<div class="editor-label">
@Html.LabelFor(model => model.customerNumber)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.customerNumber)
@Html.ValidationMessageFor(model => model.customerNumber)
</div>
<div class="editor-label">
@Html.LabelFor(model => model.locationNumber)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.locationNumber)
@Html.ValidationMessageFor(model => model.locationNumber)
</div>
<p>
<input type="submit" value="Submit"/>
</p>
</fieldset>
}
@section Scripts {
@Scripts.Render("~/bundles/jqueryval")
}
using System;
using System.Collections.Specialized;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using FusionServiceHelper.Models;
// NOTE: Replace 'MyController' with the name of your controller.
//
// GET: /MyController/GetDelinquencyInfo
public ActionResult GetDelinquencyInfo()
{
// Create a new instance of the model to pick up any default values.
GetDelinquencyInfo model = new GetDelinquencyInfo();
// pass model to set to default values
// NOTE: Change 'MyFolderPath' to the path to the .cshtml file.
return View("~/Views/MyFolderPath/GetDelinquencyInfo.cshtml", model);
}
//
// POST: /MyController/GetDelinquencyInfo
[HttpPost]
public ActionResult GetDelinquencyInfo(FormCollection collection)
{
string url = "v3/Naviline/Utilities/DelinquencyInfo/{customerNumber}/{locationNumber}";
// Get the value from each input field
NameValueCollection inputParms = new NameValueCollection();
inputParms.Add("customerNumber", collection["customerNumber"]);
inputParms.Add("locationNumber", collection["locationNumber"]);
try
{
// Send the request
FusionServiceRequest request = new FusionServiceRequest();
FusionServiceResult result = request.Get(url, inputParms);
return View("Result", result);
}
catch(Exception e)
{
HandleErrorInfo info = new HandleErrorInfo(e, "MyController", "GetDelinquencyInfo");
return View("Error", info);
}
}