Jarvis Pizzeria: ORDS-CRUD Generator

The Auto REST feature allows you to quickly set up REST services on your ORDS enabled database. This feature allows users wanting to quickly enable database objects and run basic queries. Users wanting more complex operations will need the Full REST development setup.

In order to use the Auto REST functionality, only a few actions are required. Although the amount of work when using the Full REST option is not too bad, it is still considerably more than with Auto REST.

To reduce the effort difference between Auto REST and Full REST, fellow Jarvis owner Rick has developed an ORDS-CRUD generator. With the help of this tool it is possible to generate CRUD templates for REST enabled resources (e.g. an address table).

The tool is available in a VBCS and a JSFiddle variant.

Remark: the tool only just exists, and new functionalities / possibilities are added regularly. So keep following the development.

Click here to read the complete post.

Jarvis Pizzeria: Testing in PCS against the Development or Production environment

Within PCS there are actually two different environments, a development environment and the production environment. Once you have deployed your application it is available in the production environment as a certain version of the application. However, you might want to test your application before you deploy a new version. You can also test your environment against the so called ‘development environment’.

The blue button bar has a Test as well as an Deploy button on the top right.

Continue reading

Jarvis Pizzeria: Using the REST interface to start a Process

In the previous blog, we already explained how you can start your process from a SOAP interface. It is also possible to do this with a REST call. For this you need to find out a couple of things about your process after which you can do a post on the Oracle API to start the process. You can use any REST client you want, in this example we use Postman.

First of all, you need to query the process definitions API. This can be found by putting /bpm/api/4.0/process-definitions after the baseUrl, in our example:

https://pcs-jarvis18.process.us2.oraclecloud.com/bpm/api/4.0/process-definitions

Luckily PCS does not allow just anyone to see this information. We need to use Basic Auth and enter our username and password.

Continue reading