ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon SQL Backup Options
DrillDown Icon Setup the OLE DB(ADO) for SQL Crystal Reports
DrillDown Icon APIs
DrillDown Icon Item Master
DrillDown Icon Work Order API
DrillDown Icon WO Main
DrillDown Icon WO Add
DrillDown Icon WO Edit
DrillDown Icon WO Get
DrillDown Icon WO Schedule
DrillDown Icon KIT API
DrillDown Icon Shop Floor Tracking API
DrillDown Icon Inventory Handling API
DrillDown Icon Purchase Order API
DrillDown Icon Sales Order API
DrillDown Icon Customer API
DrillDown Icon Q & A API's
DrillDown Icon Code that could be used to find Last Table Modified within SQL
DrillDown Icon Configure SQL Server 2008 R2 to allow Network Connections
DrillDown Icon How to detach and attached databases using the SQL Server Management Studio
DrillDown Icon Restore SQL DB from Backup
DrillDown Icon Setup a SQL Test/Sandbox Database
DrillDown Icon SQLManex Client Server Setup Instructions
DrillDown Icon Setup Folder Permissions to Write "ini" File
DrillDown Icon Setup the ODBC for SQL Crystal Reports
DrillDown Icon Setup a SQL Database Maintenance Plan
DrillDown Icon Setup Task Scheduler to Auto Run MRP
DrillDown Icon Selecting the Authentication Mode
DrillDown Icon Window 10 - Network Disconnect
DrillDown Icon Setup Work Stations
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
WO Add

Functions

WO Add API is used to add a new Work Order. 

URL-{Root URL}/API/WO/Add/{API Key}

Parameters


Parameter  Description Required Comment
 WoNo Work Order Number N  
Uniq_Key Item Unique Identifier Y Used to Choose the item to be built in the Work Order
openclos Work Order Status Y Can be STANDARD, PRIORITY-1, PRIORITY-2, FIRM PLAN, ADMIN HOLD, MFG HOLD, REWORK, REWORK FIRM, CANCEL
Due_Date Work Order Due Date Y Use MM-DD-YYYY format
custNo  Customer Number Y Must be an existing customer
bldQty Build Quantity N Amount to be built in the Work Order

Example Strings

Add Work Order

Url-?uniq_key=UNIQKEY&openclos=STANDARD&Due_Date=MM-DD-YYYY&custno=CUSTOMERNUMBER&bldqty=QTY'

JSON

{

'uniq_key':'UNIQKEY',

'openclos':'STANDARD',

'Due_Date':MM-DD-YYYY',

'custno':'CUSTOMERNUMBER',

'bldqty':'QTY'

}

A successful request should result in

{

$id: "1",

Code: 200,

Message: "WorkOrder added successfully.",

SessionId: null,

IsValidUser: true,

-ResponseObject: {

$id: "2",

WONO: "0000000410",

UNIQ_KEY: "FW7064W8L8",

OPENCLOS: "STANDARD",

ORDERDATE: "2014-11-04T14:55:50.9647637-05:00",

DUE_DATE: "2014-11-07T00:00:00",

AUDPLACE: "",

BLDQTY: 100,

COMPLETE: 0,

BALANCE: 100,

WONOTE: "",

IS_CLOSED: false,

DATECHG: null,

PLANTNO: "",

AUDBY: "",

AUDDATE: null,

MATL_CK: "",

ENGR_CK: "",

QLTY_CK: "",

SALE_CK: "",

KIT_NOTE: "",

MRP_DONE: false,

ORD_TYPE: "",

MAT_REQ_DT: null,

MAT_REQ_Q: 0,

MAT_REQ_D: "",

PROD_TIME: 0,

TTSETPTIME: 0,

ISSUED: false,

ENG_APPR: false,

ENG_APPD: null,

ENG_APPT: "",

ENG_APPI: "",

SHFLNOTE: "",

ORIG_DUEDT: null,

BUILDABLE: 0,

SCHED_FB: 0,

IS_ALLOC: false,

KITSTATUS: "",

KITCLOSEDT: null,

START_DATE: null,

CUSTNO: "0000000008",

SONO: "",

KIT: false,

SHTGNOTE: "",

RELEDATE: null,

SERIALYES: false,

UNIQUELN: "",

GLDIVNO: "",

CMPRICELNK: "",

EACHQTY: 0,

FSTDUEDT: null,

DELIFREQ: "",

PRJUNIQUE: "",

ARCSTAT: "",

SQCSTATUS: "",

KITLSTCHDT: null,

KITLSTCHINIT: null,

MRPONHOLD: false,

COMPLETEDT: null,

KITSTARTINIT: null,

KITCLOSEINIT: null,

KITCOMPLETE: false,

KITCOMPLDT: null,

KITCOMPLINIT: null,

LFCSTITEM: true,

LIS_RWK: false,

UNIQUEREC: null,

UNIQUERECID: null

}

}

Common Errors

API Key Error

If there is a problem with the entered API Key the system will return an API Key error message

{

"$id": "1",

"Code": 403,

"Message": "Invalid API Key.",

"SessionId": null,

"IsValidUser": false,

"ResponseObject": null

}

URL Error

If there is an error with the used URL the system will return a HTTP error.

{

"$id": "1",

"Message": "No HTTP resource was found that matches the request URI 'http://localhost/api/WOAdd/123456789'.",

"MessageDetail": "No type was found that matches the controller named 'WOAdd'."

}

JSON Error

If there is an error with the JSON string the system will return an "Object Reference" error.

{

"$id": "1",

"Code": 403,

"Message": "WorkOrder add failed.Object reference not set to an instance of an object.",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": null

}

Missing required parameter

If a required parameter value is missing the system will return an error message describing the missing parameter.

{

"$id": "1",

"Code": 403,

"Message": "WorkOrder add failed.Work Order Uniq_Key is required",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": null

}

Article ID: 5803