ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
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 Shop Floor Tracking Transfer
DrillDown Icon Shop Floor Tracking Get
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
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Shop Floor Tracking Get
Shop Floor Tracking Get API allows you to quickly view the status of work orders on the shop floor. 

Get

The Get function of the shop floor tracking API allows you to view the stages of the shop floor for a selected work order.

URL:{Root URL}/api/shopfloortracking/get/{API KEY}

Parameter Description Required Comment
WoNo Work Order Number Y  
includeActivities Choose whether to include all activities of the shop floor N  Can be 0 or 1, default 0
includeSerialInformation Show all serial information with the results  N  Can be 0 or 1, default 0
serialNo  Show all information related to a specific
serial number 
N Can be empty, if used must be padded with '0' up to 30 characters 
Dept_id  Department ID Name  This value can be used to narrow the results to show a specific department 
deptKey Department Key  This value can be used to narrow down the results to show a specific department 

Example request:(Note that provided example strings are for demonstration only and will not work with your system)

URL- ?Wono=393

JSON

{

'WoNo':'393'

}

Results in the following information

{

"$id":"1",

"Code":200,

"Message":"Shop Floor Tracking details:",

"SessionId":null,

"IsValidUser":true,

"ResponseObject":{

"$id":"2",

"SerializedDeptQtyList":null,

"DeptQtyList": [{

"$id":"3",

"WONO":"0000000393",

"DEPT_ID":"PP-T",

"Dept_Name":"PICK & PLACE SMT,TOP SIDE",

"CURR_QTY":0.0,

"NUMBER":5.0,

"DeptKey":"_26G0V7PBG",

"SERIALSTRT":true

},{

"$id":"4",

"WONO":"0000000393",

"DEPT_ID":"ATE ",

"Dept_Name":"ATE/BURN-IN OF COMPONENTS",

"CURR_QTY":0.0,

"NUMBER":2.0,

"DeptKey":"_26G0V7MLP",

"SERIALSTRT":false

},{

"$id":"5",

"WONO":"0000000393",

"DEPT_ID":"STAG",

"Dept_Name":"Material Staging ",

"CURR_QTY":100.0,

"NUMBER":1.0,

"DeptKey":"_2600WHEBG",

"SERIALSTRT":false

},{

"$id":"6",

"WONO":"0000000393",

"DEPT_ID":"WAVE",

"Dept_Name":"Wave Soldering ",

"CURR_QTY":0.0,

"NUMBER":4.0,

"DeptKey":"_26G0V7OJE",

"SERIALSTRT":false

},{

"$id":"7",

"WONO":"0000000393",

"DEPT_ID":"AI ",

"Dept_Name":"AUTO INSERT-THT COMPONENT",

"CURR_QTY":0.0,

"NUMBER":3.0,

"DeptKey":"_26G0V7NN6",

"SERIALSTRT":false

},{

"$id":"8",

"WONO":"0000000393",

"DEPT_ID":"SCRP",

"Dept_Name":"Scrapped Material ",

"CURR_QTY":0.0,

"NUMBER":7.0,

"DeptKey":"_2600WHEBI",

"SERIALSTRT":false

},{

"$id":"9",

"WONO":"0000000393",

"DEPT_ID":"FGI ",

"Dept_Name":"Finished Goods Inventory",

"CURR_QTY":0.0,

"NUMBER":6.0,

"DeptKey":"_2600WHEBH",

"SERIALSTRT":false

}],

"SftAdditionalDetails":null

}

}

Common Errors

URL Error

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

{

"$id": "1",

"Message": "No HTTP resource was found that matches the request URI 'http://localhost/api/ShopFlooTracking/Get/123456789?wono=410'.",

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

}

API Key Error

If there is an error with the API key the system will return an error describing it.

{

"$id": "1",

"Code": 403,

"Message": "Invalid API Key.",

"SessionId": null,

"IsValidUser": false,

"ResponseObject": null

}

Invalid Parameter

If there is an error with a Parameter value the system will return an error message detailing it.

{

"$id": "1",

"Code": 403,

"Message": "Failed:Please provide valid work order number",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": null

}

Article ID: 5737