Granite is a REST Service for Vantage Epicore ERP.

###RELEASE NOTES:

Version: 0.5

• REST API for getting last MRP run date and time
• Granite is no longer used by MEX.

Version: 0.4

• REST API for generating Flat BOM used by MEX

Version: 0.3

• Just some clean ups

Version: 0.2

• Added REST APIs used by Radiator

###INSTALLATION NOTES:

Required:

1. Tomcat 7.0 (32-bit)
2. JDK 7 Update 79 (32-bit)

Make sure Java Runtime is set to JRE7 in Eclipse, JAVA_HOME and Tomcat.

1. Include following jars in classpath (or C:\Program Files (x86)\Apache Software Foundation\Tomcat 7.0\lib):

• jdbc.jar

• progress.jar

2. Include the following dlls in PATH (C:\Program Files (x86)\Java\jre7\bin):

• JdbcProgress.dll

• procli92.dll

---

REST APIs:

(In the future, APIs need to be documented by something like swagger.io).

PACKAGE: com.gemt.granite.rest.erp.Part

granite/api/part/info/{partnum} Returns basic part information of given "partnum"

granite/api/part/detail/{partnum} Returns detail part information of given "partnum"

granite/api/part/rev/{partnum} Returns part revisions of given "partnum"

granite/api/part//approvedrev/{partnum} Returns approved revision of given "partnum"

granite/api/part//bin/{partnum} Returns primary bin number of given "partnum"

granite/api/part/search/{partnum} Search for part numbers containing text "partnum"

granite/api/part/searchbydesc/{description} Search for part desctiption containing text "description"

granite/api/part//class/{class} Search for class containing text "class"

granite/api/part/plant/{partnum} Returns plate related information for given "partnum". E.g:

REST: http://192.168.74.250/granite/api/part/plant/7188 RESULT:

{
	"partNum": "7188",
	"leadTime": 45,
	"processMRP": true,
	"daysOfSupply": 10
}

---

PACKAGE: com.gemt.granite.rest.erp.Material

granite/api/mtl/{partnum}/{revnum} Returns child parts of given parent "partnum" and "revnum". E.g.:

REST: http://192.168.74.250/granite/api/mtl/7371/- RESULT:

[
	{
		"partNum": "7371",
		"revisionNum": "-",
		"mtlSeq": 10,
		"qtyPer": 1,
		"mtlPartNum": "7251",
		"pullAsAsm": false,
		"viewAsAsm": false
	},
	{
		"partNum": "7371",
		"revisionNum": "-",
		"mtlSeq": 20,
		"qtyPer": 1,
		"mtlPartNum": "4485",
		"pullAsAsm": false,
		"viewAsAsm": false
	},
	{
		"partNum": "7371",
		"revisionNum": "-",
		"mtlSeq": 30,
		"qtyPer": 1,
		"mtlPartNum": "6331-09",
		"pullAsAsm": false,
		"viewAsAsm": false
	}
]

granite/api/mtl//{partnum} Returns child parts of approved revision of given parent "partnum".

granite/api/mtl/detail/{partnum}/{revnum} Returns child parts with detail information for given parent "partnum" and "revnum". E.g.:

REST: http://192.168.74.250/granite/api/mtl/detail/7371/- RESULT:

[
	{
		"partNum": "7371",
		"mtlSeq": 10,
		"qtyPer": 1,
		"mtlPartNum": "7251",
		"bubbleNum": "",
		"pullAsAsm": false,
		"viewAsAsm": false,
		"partDescription": "PLATE SIDE LEFT,7251",
		"partClass": "HORC",
		"invUM": "PC",
		"partType": "P",
		"nonStock": false,
		"manufacturer": "",
		"manufacturerNumber": "",
		"project": "",
		"estimatedCost": 0,
		"mfgComment": "",
		"purComment": "",
		"leadTime": 45,
		"processMRP": false,
		"daysOfSupply": 10,
		"genPOSuggestion": true,
		"revisionNum": "E",
		"revisionEffectiveDate": "24-Jan-2007",
		"approvedVendor": null,
		"primaryBin": "FT013"
	},
	...
]

granite/api/mtl/detail/{partnum} Returns child parts with detail information of approved revision of given parent "partnum" and "revnum".

/granite/api/mtl/flatBOM/{partnum} Returns all the child parts with total quantity as a flat BOM