Visual Builder Cloud Service - Web Application Design

Designing Forms in Visual Builder Cloud Service

In this post I will give you an overview of how to design a form in VBCS and make use of the available REST services in Fusion ERP Cloud to view the data.

VBCS can only work with REST services as of now but we can leverage Integration cloud to convert web services into REST services and make them available to VBCS.

The example provided below designs a simple form with a table and connect to ERP Cloud to get the inventory item details.

Create a new application and add the relevant details and click on Finish.

Now click on Service Connections and add the relevant details.

Create a new Service Connection and select the source as Define by Specification

Enter the relevant details and click on next

select the items end point and click on create

Now navigate to Web Applications and create a new Web Application as shown below.

Design the form and add the table component to the form as shown below.

Click on the Add Data property to map the underlying source data for the table. Select the item end point and click on next.

Select the columns which are to be displayed on the form.

Click on Next and associate any query parameters if required. In this example we don't have any query parameters to add so click on Finish.

We can now view the data in the Design View as shown below.

We can also change the column name by editing the headerText tag as shown below.

Click on Run icon to run the application.

The form would be displayed in a new window.

Managing Application Data in VBCS

Overview

Business Objects in Visual Builder Cloud Services enable us to create and store data for the custom objects. The underlying data is exposed to the web / mobile applications via REST API's.

In this article I will give an overview of how to create custom table, access data via REST API's and options available in VBCS to import or export data. Do bear in mind that there is a limitation on the data storage capability in VBCS if you are planning to store large volume of data then i recommend using Database Cloud Service (DBCS).

Creating tables in VBCS

Navigate to Business Objects and Click on + icon at the to

Enter the name for the Business Object and click on the tick icon

Navigate to Fields tab and add the relevant columns to the business object.

I have added couple of columns to this table ( ItemNumber and Description)

Note that the id and the WHO Columns will be added automatically.

Accessing tables in VBCS

I will use the REST endpoint (POST method) to populate the data into the Item Object

Similarly, you can also insert the data by clicking on the Add Row button as shown below.

Exporting / Importing Data inVBCS

Use Export All Data option from Data Manager to export the data objects available with in an application.

A zip file would be generated will the all the business objects data in csv format.

Similarly, you can use import from file to upload all the business objects data into VBCS.

Edit Business Objects Data in Excel

In the new release of VBCS we can also edit the business objects in Excel. Installing this Plugin enables a new menu item on the excel application.