Method GetDelinquencyInfo

Summary

Get Delinquency Information

Remarks

If the account has a deliquent balance, this returns a row with the delinquent amount and service cutoff dates.

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.

Input Parameters

NameTypeLengthDescription
customerNumber numeric 9 [Required] Customer Number. See Account Search methods.
locationNumber numeric 9 [Required] Location Number. See Account Search methods.

Example

GET http://localhost/FusionServices/v3/Naviline/Utilities/DelinquencyInfo/{customerNumber}/{locationNumber}

Return Values

NameDescription
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.

Sample Responses

Sample Code

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); 
 });

C# Razor MVC Sample Code

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);
   }
}