Search for a utility account by Drivers License Number
Name | Type | Length | Description |
---|---|---|---|
dl | System.String | 0 | [Required] Full or partial drivers license number to search for |
POST http://localhost/FusionServices/v2/Naviline/Utilities/Search/ByDriversLicense
This returns account info for both residential and commercial customers that match the license number. It returns the customer number and location number which together make up the account number used by most other services to identify the customer’s account. It also returns additional information, such as the address, so the customer can select which account is theirs in case multiple licenses match the criteria.
Name | Description |
---|---|
Customer | The customer number for the account. The customer number and location number together make up the account number used by most other services to identify the customer’s account. |
Location | The location number for the account. Location number is the second part of the account number used to identify the customer’s account. |
LocationAddress | Location street address |
CustomerName | The customer’s name. For residential accounts, it should be in the format LAST, FIRST. For commercial accounts, it will be the business name. |
DriverLicenseNumber | Driver License Number found |
SSN | Social security number |
Misc1Description | Misc data 1 description |
Misc1Date | Misc data 1 date |
Misc1Number | Misc data 1 number |
Misc1UserDefined | Misc data 1 user defined value |
Misc2Description | Misc data 12description |
Misc2Date | Misc data 2 date |
Misc2Number | Misc data 2 number |
Misc2UserDefined | Misc data 2 user defined value |
Confidential | Indicates if the customer information is restricted and should not be given out or displayed. Y=Yes, N=No |
CashOnly | Indicates if the customer is required to make all payments in cash only. Y=Yes N=No |
Status | The status of the account. The account status codes and their descriptions are: A = Active, C = Collections, D = Deleted, F = Finalled, I = Inactive, S = Shutoff, T = Terminated, N = Terminated, non-payment, V = Vacation, W = Writeoff |
ServiceInformation | Services on the account. Returns service code and description. Ex: SW = Sewer, WA = Water |
using System.Net;
using Newtonsoft.Json.Linq;
public void MethodName(parms)
{
string uri = "http://localhost/FusionServices/v2/Naviline/Utilities/Search/ByDriversLicense";
System.Collections.Specialized.NameValueCollection postParms =
new System.Collections.Specialized.NameValueCollection();
// Set paramater values
postParms.Add("dl",System.Web.HttpUtility.UrlEncode("dl12345"));
WebClient req = new WebClient();
wc.Headers.Add("Content-Type", "application/x-www-form-urlencoded");
wc.Headers.Set("X-APPID", "YOURID");
wc.Headers.Set("X-APPKEY", "YOURKEY");
byte[] responseBytes = wc.UploadValues(new Uri(uri), "POST", postParms);
string stringResult = Encoding.UTF8.GetString(responseBytes);
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 Customer = row["Customer"].ToString();
string Location = row["Location"].ToString();
string LocationAddress = row["LocationAddress"].ToString();
string CustomerName = row["CustomerName"].ToString();
string DriverLicenseNumber = row["DriverLicenseNumber"].ToString();
string SSN = row["SSN"].ToString();
string Misc1Description = row["Misc1Description"].ToString();
string Misc1Date = row["Misc1Date"].ToString();
string Misc1Number = row["Misc1Number"].ToString();
string Misc1UserDefined = row["Misc1UserDefined"].ToString();
string Misc2Description = row["Misc2Description"].ToString();
string Misc2Date = row["Misc2Date"].ToString();
string Misc2Number = row["Misc2Number"].ToString();
string Misc2UserDefined = row["Misc2UserDefined"].ToString();
string Confidential = row["Confidential"].ToString();
string CashOnly = row["CashOnly"].ToString();
string Status = row["Status"].ToString();
string ServiceInformation = row["ServiceInformation"].ToString();
// TODO - YOUR CODE HERE
}
}
}
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 PostUtilitiesAccountSearchByLicense
{
// Add property for each input param in order to map a field to it
[Required(ErrorMessage = "Required")]
public string dl{get; set;}
public PostUtilitiesAccountSearchByLicense()
{
//Set any defaults here
}
}
}
@* NOTE: Use Add->View to add the View. *@
@* NOTE: Check the 'Create strongly-typed view checkbox, and select the PostUtilitiesAccountSearchByLicense 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.PostUtilitiesAccountSearchByLicense
@{
ViewBag.Title = "PostUtilitiesAccountSearchByLicense";
}
<h2>PostUtilitiesAccountSearchByLicense</h2>
@using (Html.BeginForm()) {
@Html.AntiForgeryToken()
@Html.ValidationSummary(true)
<fieldset>
<legend>PostUtilitiesAccountSearchByLicense</legend>
<div class="editor-label">
@Html.LabelFor(model => model.dl)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.dl)
@Html.ValidationMessageFor(model => model.dl)
</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/PostUtilitiesAccountSearchByLicense
public ActionResult PostUtilitiesAccountSearchByLicense()
{
// Create a new instance of the model to pick up any default values.
PostUtilitiesAccountSearchByLicense model = new PostUtilitiesAccountSearchByLicense();
// pass model to set to default values
// NOTE: Change 'MyFolderPath' to the path to the .cshtml file.
return View("~/Views/MyFolderPath/PostUtilitiesAccountSearchByLicense.cshtml", model);
}
//
// POST: /MyController/PostUtilitiesAccountSearchByLicense
[HttpPost]
public ActionResult PostUtilitiesAccountSearchByLicense(FormCollection collection)
{
string url = "v2/Naviline/Utilities/Search/ByDriversLicense";
// Get the value from each input field
NameValueCollection inputParms = new NameValueCollection();
inputParms.Add("dl", collection["dl"]);
try
{
// Send the request
FusionServiceRequest request = new FusionServiceRequest();
FusionServiceResult result = request.Post(url, inputParms);
return View("Result", result);
}
catch(Exception e)
{
HandleErrorInfo info = new HandleErrorInfo(e, "MyController", "PostUtilitiesAccountSearchByLicense");
return View("Error", info);
}
}