Method GetAmountDue

Summary

Get Amount Due

Remarks

Gets amount due for all projects

For larger file downloads, use PostSearchAmountDue to allow for paging the data returned.

Requires

Input Parameters

NameTypeLengthDescription
None No input parameters to pass

Example

GET http://localhost/FusionServices/v3/Naviline/PlanningEngineering/AmountDue

Return Values

NameDescription
YEAR Project Year
PROJECT Project Number
BALANCE_DUE Amount Due on the application
DESCRIPTION Description of the application
DEVELOPER Developer name
ROWS Number of rows returned
LASTPYER Last Project Year returned
LASTPNBR Last Project Number returned
MOREYN More records Y/N
ErrorCode Error code 0000=Success
ErrorMessage Error Message

Sample Responses

Sample Code

using System.Net;
using Newtonsoft.Json.Linq;

public void MethodName(parms)
{
    string uri = "http://localhost/FusionServices/v3/Naviline/PlanningEngineering/AmountDue";
    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 YEAR = row["YEAR"].ToString();
             string PROJECT = row["PROJECT"].ToString();
             string BALANCE_DUE = row["BALANCE_DUE"].ToString();
             string DESCRIPTION = row["DESCRIPTION"].ToString();
             string DEVELOPER = row["DEVELOPER"].ToString();
             // TODO - YOUR CODE HERE
        }
    }
}

$.get('http://localhost/FusionServices/v3/Naviline/PlanningEngineering/AmountDue', 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 GetAmountDue
   {
       // Add property for each input param in order to map a field to it
       public GetAmountDue()
       {
           //Set any defaults here
       }
   }
}
@* NOTE: Use Add->View to add the View. *@
@* NOTE: Check the 'Create strongly-typed view checkbox, and select the GetAmountDue 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.GetAmountDue

@{
   ViewBag.Title = "GetAmountDue";
   string myUrl = "http://localhost/FusionServices/v3/Naviline/PlanningEngineering/AmountDue";
}

<h2>GetAmountDue</h2>
@using (Html.BeginForm()) {
   @Html.AntiForgeryToken()
   @Html.ValidationSummary(true)
   <fieldset>
   <legend>GetAmountDue</legend>
       <div class="editor-label">Use the fields below to change the values and resubmit.</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/GetAmountDue
public ActionResult GetAmountDue()
{
   // Create a new instance of the model to pick up any default values.
   GetAmountDue model =  new GetAmountDue();

   // pass model to set to default values
   // NOTE: Change 'MyFolderPath' to the path to the .cshtml file.
   return View("~/Views/MyFolderPath/GetAmountDue.cshtml", model);
}

// 
// POST: /MyController/GetAmountDue
[HttpPost]
public ActionResult GetAmountDue(FormCollection collection)
{
   string url = "v3/Naviline/PlanningEngineering/AmountDue";
   // Get the value from each input field
   NameValueCollection inputParms = new NameValueCollection();

   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", "GetAmountDue");
       return View("Error", info);
   }
}