Page Comparison

...

...

...

...

...

...

...

What is REST API?

A RESTful API is an application program interface (API) that uses HTTP requests to GET, PUT, POST and DELETE data.

...

A RESTful API breaks down a transaction to create a series of small modules. Each module addresses a particular underlying part of the transaction. This modularity provides developers with a lot of flexibility. 

How to set up Burti REST API?

Initial setup is rather complicated, so we do it for the costumer. However, there are some prerequisites that needs to be done, in order to set it up:

...

curl "http://localhost:1402/Web_JSON_Composer.hal" -d @sample.get.data.txt > response.get1.json
curl "http://localhost:1402/Web_JSON_Composer.hal" -d @sample.get.data2.txt > response.get2.json
curl "http://localhost:1402/Web_JSON_UpdatingComposer.hal" -d @sample.post.data.txt > response.post.json

OR

Custom built scripts/applications which can execute curl request commands.

The requests are as follows:

Request full details for a specific Item

 sample.json.txt - made to the READ interface Web_JSON_Composer.hal:

0_query=Web_JSON_INVc_List.hal&0_full=true&0_index=Code&0_Code=10101&0_company=1&0_fieldcnt=1&0_fieldlist=Code

Request full details for a specific Recipy

sample.getjson.datarecipies.txt - made to the READ interface Web_JSON_Composer.hal:

0_query=Web_JSON_INVcRecVc_List.hal&0_full=true&0_index=Code&0_Code=1010120210&0_company=1&0_fieldcnt=1&0_fieldlist=Code

Parameters explained

As you can see, all the parameters are prefixed with a "0_" - this is a number for the request, and is used to make multiple data requests within a single API call. In this example, there is only one data request.

1. query - the specific data interface (will be a separate interface for each register). In this case it's "Web_JSON_INVcRecVc_List.hal" for Items (register code INVcRecVc) - the naming of this interface will be the same accross all registers.
2. full - whether to request the full data or a shorter list of fields - these fields are configured separately
3. index - the index in Hansaworld's datadef, by which to lookup the data, advanced topic, simply use "Code" (might be something other for other registers)
4. Code - the field name within the index, simply use "Code" (might be something other for other registers)
5. fieldcnt - number of fields within the index, use 1 (might be something other for other registers)
6. company - the company number from which we are requesting the data
7. fieldlist - list of the fields within the index, comma separated, use "Code" (might be something other for other registers)

Response file response.get1get.json

Response file Recipies . response.get.recipies.json

Request full list of items

 sample.getjson-2.data2.txt - made to the READ interface Web_JSON_Composer.hal:

0_query=Web_JSON_INVc_List.hal&0_count=500&0_full=false&0_sort_only=true&0_index=Code&0_company=1&1_query=Web_JSON_INVc_List.hal&1_count=500&1_full=false&1_sort_only=true&1_index=Code&1_company=2

Parameters explained

In this example you can see that there are two groups of parameters - prefixed with "0_" and "1_". This illustrates two separate data requests within a single call. The response data will be similarly grouped.

Only describing new options that are not described above:
# sort_only - this will use the provided index name as a sort order only, and will not try to look up specific data (used when listing all records within a register)

Response file  response.get2.json

Insert a new item

 sample.post.data.txtjson - made to the WRITE interface Web_JSON_UpdatingComposer.hal:

{
	"0": {
		"name": "WEB_JSON_INVc_Save.hal",
		"company": 21,
		"data": {
			"action": "insert",
			"matrix": [],
			"Code": "10101",
			"Name": "Piano New",
			"Unittext": "STK"
		}
	},
	"21": {
		"name": "WEB_JSON_INVc_Save.hal",
		"company": 21,
		"data": {
			"action": "insertupdate",
			"matrix": [],
			"Code": "1010210120",
			"Name": "Klarinett New",
			"Unittext": "STK"
		}
	}	
}

Parameters explained

As you can see, the request is now in JSON format. It is once again numbered and can contain multiple requests within the single call. These would be expected to be numbered 0, 1, 2 and so on.

1. name - the name of the update interface. The principle is similar to the read interfaces.
2. company - the company number to use for inserting data
3. data - the data block
4. action - insert/update/delete
5. matrix - to be used with matrix rows - array of rows in the same format as the following
6. Code , - Usually the main index key for records. For "Insert" actions should be blank
7. Name,Unittext- database fields to update with values.

Response file file response.post.json It It contains no warnings or errors, but the format in which such errors would be received, can be seen in the file.

...