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 Inventor
DrillDown Icon Get
DrillDown Icon Add
DrillDown Icon Edit
DrillDown Icon Delete
DrillDown Icon Copy
DrillDown Icon Next PN
DrillDown Icon InvtmfHd
DrillDown Icon Invtmfsp
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 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
 
Add

The Item Master add API is used to insert new items into the database. 

URL-{Root URL}/api/ItemMaster/Add/{API KEY}

Parameters

Parameter Description Required Comment
part_class Part Class   Y Used to designate the new part's class. Must be a valid part class. 
part_type Part Type  Y Used to designate the new part's type. Must be a valid part type.
part_sourc Part Source  Y Used to designate the new part's source. Must be a valid part source. 
U_of_Meas Unit of Measurement   Y The part's unit of measurement. Must be a valid unit of measurement in the system.
Pur_UOfM Purchasing Unit of Measurement  Y The part's purchasing unit of measurement. Must be a valid unit of measurement.  
CustNo  Customer Identifier Number  Y The customer number is used to select the customer for the part. 
CustPartNo  Customer Part Number  Y Used to set the Customer's part number. 
CustRev Customer Revision  Y Used to set the revision level on the customer part.
part_No Part Number  Y Used to set the part number.
status  Part Status  Y Used to set the part's status, can be "active" or "inactive".
serialYes Serial Number Yes or No  Y Can be "true" or "false".
descript  Description  Y Can be true or false.

Example Strings

Example ItemMaster Add String-

URL-?Part_Class=CAP-SMT&Part_Type=0402&Part_Sourc=make&U_Of_Meas=Each&Pur_UOfM=Each&Custno=0000000001&custpartno=n7105&custrev=Q&part_no=121-1000003&status=Active&SerialYes=False&descript=test

JSON-

{

'Part_Class':'CAP-SMT',

'Part_Type':'0402',

'Part_Sourc':'make',

'U_Of_Meas':'Each',

'Pur_UOfM':'Each',

'Custno':'0000000001',

'custpartno':'n7105',

'custrev':'Q',

'part_no':'121-1000003',

'status':'Active',

'SerialYes':'False',

'descript':'test'

}

A successful add should result in:

{

"$id": "1",

"Code": 200,

"Message": "Inventor added successfully.",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": "0CQOOPKEFK"

}

Add New Item with InvtmfHD Information.

Adding InvtmfHd information at the same time as the basic part information. For InvtmfHd parameters see InvtmfHd Add API.

Example ItemMaster Add string with InvtmfHd Information

JSON

{'Part_Class':'PARTCLASS','Part_Type':'PARTTYPE','Part_Sourc':'SOURCE','U_Of_Meas':'UOM','Pur_UOfM':'PURCHASEUOM','Custno':'CUSTOMERNUMBER','custPartNo':'CUSTPARTNUMBER','part_no':'PARTNUMBER','status':'Active','SerialYes':'false','Descript':'new add',

InvtmfHdList: [{'partmfgr':'MANUFACTURER','mfgr_pt_no':'MANUFACTURER PARTNUMBER','MATLTYPE':'MATERIALTYPE','MATLTYPEVALUE':'','ORDERPREF':'1','SFTYSTK':'10','LDISALLOWBUY':'false','LDISALLOWKIT':'false',

 

}]

}

A successful should result in.

{

"$id": "1",

"Code": 200,

"Message": "Inventor added successfully.",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": "UO2PKV74UE"

}

Common Errors

API Key Error

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

{

"$id": "1",

"Code": 403,

"Message": "Invalid API Key.",

"SessionId": null,

"IsValidUser": false,

"ResponseObject": null

}

URL Error

If there is an error within 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/ItemMaster/Ad/123456789'.",

"MessageDetail": "No action was found on the controller 'ItemMaster' that matches the name 'Ad'."

}

Part Already in System

If the part number being added is already being used the system will return an error message describing it.

{

"$id": "1",

"Code": 403,

"Message": "Inventor add failed.Part number '121-1000003' and Revision '' already exists for customer '0000000001'.",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": null

}

Missing Parameter

If a required parameter is missing the system will return an error message asking for the parameter.

{

"$id": "1",

"Code": 403,

"Message":"Inventor add failed.Please provide description for Inventor.",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": null

}

Incorrect Parameter

If an incorrect parameter value is used the system will return an error describing the incorrect parameter.

{

"$id": "1",

"Code": 403,

"Message": "Inventor edit failed.Unique_key required.",

"SessionId": null,

"IsValidUser": true,

"ResponseObject": null

}

Article ID: 5873