PostJobOrderSync
Name | Type | Length | Description |
---|---|---|---|
syncType | System.String | 1 | [Required] F=Full Sync; I=Incremental Sync |
POST http://localhost/FusionServices/v3/Naviline/WorkOrders/JobOrderSync
Name | Description |
---|---|
OUT_ERRCDE | Error Code: 0000 or 0001 |
OUT_ERRDSC | Error Description: Success or Error = Invalid environment parameters |
REQUESTNBR | Work request number – ‘WF01234567’ |
JOBNBR | Job order number – ‘001’ (numeric) |
REQCATG | Work request category |
WORKTYPE | Work type |
REQORIGIN | Request Origin |
SHORTDSC | Short DescriptionWork request status (text) – description derived from ABADCD status code value |
REQSTATUS | Work request status (text) – description derived from ABADCD status code value |
REQSTSCDE | Work request status code • ‘AS’ – Assigned • ‘AU’ - Authorized • ‘CA’ – Canceled • ‘CL’ – Closed • ‘CO’ – Completed • ‘HD’ – Held for deposit • ‘HO’ – On hold • ‘OP’ - Open |
CUSTOMERID | CIS customer ID (numeric) |
REQNAME | Requestor name |
REQDEPT | Requesting department |
REQPRIORITY | Request priority |
LOCATIONID | Location ID (numeric) |
GENLOC | General location |
WRSCHSTRDTE | W/R scheduled start date – YYYYMMDD (numeric) |
WRSCHCMPDTE | W/R scheduled completion date – YYYYMMDD (numeric) |
WRACTSTRDTE | W/R actual start date – YYYYMMDD (numeric) |
WRACTCMPDTE | W/R actual completion date – YYYYMMDD (numeric) |
WRPRJNBR | W/R project number |
ASSIGNDEPT | W/R assigned department |
WRUOP | W/R UOP code |
WRUOPQTY | W/R UOP quantity – ‘12345.123’ (numeric) |
RLTDREQ | Related request number – ‘WF01234567’ |
UNITIZMTHD | Unitization methodL • ‘ ‘ – Not specified • ‘C’ – Cost • ‘H’ - Hours |
DEPRTECDE | Depreciation rate code |
DEPRECCONV | Depreciation convention: • ‘H’ - 50% Install/50% Retire • ‘I’ - 100% for install month • ‘R’ - 100% for retire month |
SUBACCTGRP | Subaccount group |
SUBACCT | Subaccount |
WRXCOORD | W/R X-coordinate (numeric) – ‘1234567890.123456’ |
WRYCOORD | W/R Y-coordinate (numeric) – ‘1234567890.123456’ |
WRZCOORD | W/R Z-coordinate (numeric) – ‘123456789.12’ |
WRREQDTE | W/R request date – YYYYMMDD (numeric) |
WRKREQGRP | Work request group: • ‘CP’ – Capital • ‘UC’ – Utility capital • ‘UT’ – Utility non-capital • ‘WF’ – Non-capital non-utility |
CHGTODEPT | Charge to department |
CATG | J/O request category |
TASK | Task |
STDTASK | Standard Task |
JODESC | Job Order Description |
SERVICE | Service |
SVCSEQ | Service sequence – ‘000’ (numeric) |
METERNBR | Meter Number |
CREW | Crew |
JOSCHSTRDTE | J/O scheduled start date – YYYYMMDD (numeric) |
JOSCHCMPDTE | J/O scheduled completion date – YYYYMMDD (numeric) |
JOACTSTRDTE | J/O actual start date – YYYYMMDD (numeric) |
JOACTCMPDTE | J/O actual completion date – YYYYMMDD (numeric) |
JOSTATUS | Job order status (text) |
JOSTSCDE | Job order status code: • ‘CA’ – Canceled • ‘CL’ – Closed • ‘CO’ – Completed • ‘IS’ – Issued(printed) • ‘RD’ – Ready • ‘SD’ - Scheduled |
DISPATCHBY | Dispatched by (user ID) |
DISPATCHTO | Dispatched to employee ID (numeric) |
DISPATCHDTE | Dispatched date – YYYYMMDD (numeric) |
DISPATCHTIM | Dispatched time – HHMMSS (military time) |
JOUOP | J/O UOP code |
JOUOPQTY | J/O UOP quantity – ‘12345.123’ (numeric) |
JODEPT | J/O assigned department |
JOPROJNBR | J/O project number |
JOXCOORD | J/O X-coordinate (numeric) – ‘1234567890.123456’ |
JOYCOORD | J/O Y-coordinate (numeric) – ‘1234567890.123456’ |
JOZCOORD | J/O Z-coordinate (numeric) – ‘123456789.12’ |
DFTPRACCT | Default payroll account |
DFTPIACCT | Default purchasing/inventory account |
DFTPOACCT | Default purchase order account |
DFTPCACCT | Default p-card account (future) |
NEWMTRNBR | New meter number |
using System.Net;
using Newtonsoft.Json.Linq;
public void MethodName(parms)
{
string uri = "http://localhost/FusionServices/v3/Naviline/WorkOrders/JobOrderSync";
System.Collections.Specialized.NameValueCollection postParms =
new System.Collections.Specialized.NameValueCollection();
// Set paramater values
postParms.Add("syncType",System.Web.HttpUtility.UrlEncode("F"));
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 REQUESTNBR = row["REQUESTNBR"].ToString();
string JOBNBR = row["JOBNBR"].ToString();
string REQCATG = row["REQCATG"].ToString();
string WORKTYPE = row["WORKTYPE"].ToString();
string REQORIGIN = row["REQORIGIN"].ToString();
string SHORTDSC = row["SHORTDSC"].ToString();
string REQSTATUS = row["REQSTATUS"].ToString();
string REQSTSCDE = row["REQSTSCDE"].ToString();
string CUSTOMERID = row["CUSTOMERID"].ToString();
string REQNAME = row["REQNAME"].ToString();
string REQDEPT = row["REQDEPT"].ToString();
string REQPRIORITY = row["REQPRIORITY"].ToString();
string LOCATIONID = row["LOCATIONID"].ToString();
string GENLOC = row["GENLOC"].ToString();
string WRSCHSTRDTE = row["WRSCHSTRDTE"].ToString();
string WRSCHCMPDTE = row["WRSCHCMPDTE"].ToString();
string WRACTSTRDTE = row["WRACTSTRDTE"].ToString();
string WRACTCMPDTE = row["WRACTCMPDTE"].ToString();
string WRPRJNBR = row["WRPRJNBR"].ToString();
string ASSIGNDEPT = row["ASSIGNDEPT"].ToString();
string WRUOP = row["WRUOP"].ToString();
string WRUOPQTY = row["WRUOPQTY"].ToString();
string RLTDREQ = row["RLTDREQ"].ToString();
string UNITIZMTHD = row["UNITIZMTHD"].ToString();
string DEPRTECDE = row["DEPRTECDE"].ToString();
string DEPRECCONV = row["DEPRECCONV"].ToString();
string SUBACCTGRP = row["SUBACCTGRP"].ToString();
string SUBACCT = row["SUBACCT"].ToString();
string WRXCOORD = row["WRXCOORD"].ToString();
string WRYCOORD = row["WRYCOORD"].ToString();
string WRZCOORD = row["WRZCOORD"].ToString();
string WRREQDTE = row["WRREQDTE"].ToString();
string WRKREQGRP = row["WRKREQGRP"].ToString();
string CHGTODEPT = row["CHGTODEPT"].ToString();
string CATG = row["CATG"].ToString();
string TASK = row["TASK"].ToString();
string STDTASK = row["STDTASK"].ToString();
string JODESC = row["JODESC"].ToString();
string SERVICE = row["SERVICE"].ToString();
string SVCSEQ = row["SVCSEQ"].ToString();
string METERNBR = row["METERNBR"].ToString();
string CREW = row["CREW"].ToString();
string JOSCHSTRDTE = row["JOSCHSTRDTE"].ToString();
string JOSCHCMPDTE = row["JOSCHCMPDTE"].ToString();
string JOACTSTRDTE = row["JOACTSTRDTE"].ToString();
string JOACTCMPDTE = row["JOACTCMPDTE"].ToString();
string JOSTATUS = row["JOSTATUS"].ToString();
string JOSTSCDE = row["JOSTSCDE"].ToString();
string DISPATCHBY = row["DISPATCHBY"].ToString();
string DISPATCHTO = row["DISPATCHTO"].ToString();
string DISPATCHDTE = row["DISPATCHDTE"].ToString();
string DISPATCHTIM = row["DISPATCHTIM"].ToString();
string JOUOP = row["JOUOP"].ToString();
string JOUOPQTY = row["JOUOPQTY"].ToString();
string JODEPT = row["JODEPT"].ToString();
string JOPROJNBR = row["JOPROJNBR"].ToString();
string JOXCOORD = row["JOXCOORD"].ToString();
string JOYCOORD = row["JOYCOORD"].ToString();
string JOZCOORD = row["JOZCOORD"].ToString();
string DFTPRACCT = row["DFTPRACCT"].ToString();
string DFTPIACCT = row["DFTPIACCT"].ToString();
string DFTPOACCT = row["DFTPOACCT"].ToString();
string DFTPCACCT = row["DFTPCACCT"].ToString();
string NEWMTRNBR = row["NEWMTRNBR"].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 PostJobOrderSync
{
// Add property for each input param in order to map a field to it
[Required(ErrorMessage = "Required")]
[RegularExpression("^(?=.{0,1}$).*", ErrorMessage = "Must be 1 characters or less. ")]
public string syncType{get; set;}
public PostJobOrderSync()
{
//Set any defaults here
}
}
}
@* NOTE: Use Add->View to add the View. *@
@* NOTE: Check the 'Create strongly-typed view checkbox, and select the PostJobOrderSync 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.PostJobOrderSync
@{
ViewBag.Title = "PostJobOrderSync";
}
<h2>PostJobOrderSync</h2>
@using (Html.BeginForm()) {
@Html.AntiForgeryToken()
@Html.ValidationSummary(true)
<fieldset>
<legend>PostJobOrderSync</legend>
<div class="editor-label">
@Html.LabelFor(model => model.syncType)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.syncType)
@Html.ValidationMessageFor(model => model.syncType)
</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/PostJobOrderSync
public ActionResult PostJobOrderSync()
{
// Create a new instance of the model to pick up any default values.
PostJobOrderSync model = new PostJobOrderSync();
// pass model to set to default values
// NOTE: Change 'MyFolderPath' to the path to the .cshtml file.
return View("~/Views/MyFolderPath/PostJobOrderSync.cshtml", model);
}
//
// POST: /MyController/PostJobOrderSync
[HttpPost]
public ActionResult PostJobOrderSync(FormCollection collection)
{
string url = "v3/Naviline/WorkOrders/JobOrderSync";
// Get the value from each input field
NameValueCollection inputParms = new NameValueCollection();
inputParms.Add("syncType", collection["syncType"]);
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", "PostJobOrderSync");
return View("Error", info);
}
}