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 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 Sales Order
DrillDown Icon Sales Order Item
DrillDown Icon Add
DrillDown Icon Edit
DrillDown Icon Get
DrillDown Icon Delete
DrillDown Icon Sales Order Item Price
DrillDown Icon Sales Order Item Due Date
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
 
Get

​Function

Sales Order Item Get API is used to find and view details about items in existing sales orders. 

URL-{Root URL}/API/SO/ItemGet/{API Key}

Parameters

 Parameter Description Required Comment
SoNo Sales Order Number Y  
line_no Line Number N Chooses the line where the part will be added to the SO
part_num Part Number Y The part that is being added to the SO
uniq_key Item identifier N Can be used instead of part number
uOfMeas Unit of Measurement Y The Item's unit of measurement
eachQty Each Delivery Quantity N If used has to be greater than 0 and less than the amount ordered.
ord_qty Quantity Ordered Y Amount of the item to add to the sales order
soDet_Desc Item Description Y
trans_days Transfer Days N Will be automatically entered by the system, can be changed. 
fstduedt First Due Date N Will be automatically entered by the system, can be changed.
deliFreq Delivery Frequency N Can be 'DY', 'WK', or 'MO'
note SO Item Note N Can be used to add a note to the item
status SO Item Status Y Can be 'Standard', 'Priority-1', 'Priority-2', 'Cancel', 'Closed'
w_key Warehouse Unique Record Identifier N Used if the item is a 'BUY' or 'MAKE' part. 

Example Strings

Edit Existing SO

URL- ?UNIQUELN=UNIQUELN

JSON-

{

'UNIQUELN':'UNIQUELN'

}

A successful request returns the following

{

$id: "1",

Code: 200,

Message: "Sales Order Item details:",

SessionId: null,

IsValidUser: true,

-ResponseObject: {

$id: "2",

DueDateList: [ ],

SOPRICESList: [ ],

UNIQUELN: "A6WDVN62YM",

UNIQ_KEY: "_44Y0WP6H4",

SONO: "0000000789",

LINE_NO: "0000002",

UOFMEAS: "each",

EACHQTY: 0,

ORD_QTY: 0,

SHIPPEDQTY: 0,

BALANCE: 0,

Sodet_Desc: "Loud ",

TRANS_DAYS: 1,

FSTDUEDT: "2014-11-13T00:00:00",

DELIFREQ: " ",

CATEGORY: "000000000~",

NOTE: "",

EXTENDED: 0,

BULLETIN: "",

WONOFLAG: false,

QTYFROMINV: 0,

STATUS: "STANDARD ",

W_KEY: "_4500WBEBA",

ORIGINUQLN: " ",

PRJUNIQUE: " ",

ARCSTATUS: " ",

PRODTPUNIQ: " ",

PRODTPUKLN: " ",

CNFGQTYPER: 0,

MRPONHOLD: false,

SOURCEINSP: false,

FIRSTARTCL: false,

LFCSTITEM: false,

LWARRANTY: false,

PART_NUM: null,

PRJCT_NUM: null,

REVISION: null

}

}

Common Errors

API Key Error

If the entered API Key is invalid the system will return an invalid API Key error message.

{

"$id": "1",

"Code": 403,

"Message": "Invalid API Key.",

"SessionId": null,

"IsValidUser": false,

"ResponseObject": null

}

URL Error

If the entered URL is invalid the system will return a "HTTP" error message.

{

"$id": "1",

"Message": "No HTTP resource was found that matches the request URI 'http://localhost/api/SOItemGet/23456789?UNIQUELN=_47D0OEV28'.",

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

}

Item Does Not Exist

If the entered item does not exist the system will return an "Item Does Not Exist" error message.

{

"$id": "1",

"Code": 403,

"Message": "Sales Order Item does not exists.",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": null

}

Article ID: 5762