MCS: Express API, the new feature added in 16.4.1

When we want to create a new Custom API, we have to define the each of the endpoints and, if we want to consume them from Oracle MAX, we have to define the schemas and then add some mock data. Since version 16.4.1 (v3.0), there is a new feature, Express API, where we can create the resources and the schemas easily and declaratively.

I have to say that we can still create the APIs in the old way. But if we want to use Express API, we just have to select that option when creating an API.

The creation popup is the same as in previous versions.

But the API page is different. We no longer see endpoints, schema, security, types and traits menus, and instead of those we have resources menu option.

After creating a resource, we can see 4 tabs.

In the first one we can change the configuration of the resource and we can also define child and parent relationships between resources.

 The next tab is fields. This is the way we start defining the schema of the API.

Using this feature will result in the automatic generation of the schemas.

Another tab is Methods. By default there are 5 methods created for CRUD operations, although we can create custom methods.

The last tab is to provide sample data. Before the Express API we had to manually build the json and now we can insert as many rows as we want using this form.

Now that we have finished to define our API, if we test it we can see the that the data is returned by the API, and we are ready to implement the API and create our MAX application.

OTN Appreciation Day: #ThanksOTN Twitter feed with Oracle MCS and Oracle JET

As we can implement our Custom APIs using node.js, we can almost use any of the available node modules like for example Oracle MCS: Creating PDF files in Custom APIs.
In a project we are developing we have the requirement to display a twitter timeline of a hashtag.

Today is the OTN Appreciation Day and in this post we are going to make a #ThanksOTN twitter feed using Oracle MCS and Oracle JET.

First of all we are going to start with the API design. We are going to create an API called TwitterAPI and a GET method inside feed endpoint.

The next step is to implement the API. To get the twitter feed we are going to use node-twitter module.  To install the module we have to execute npm install twitter  in the folder where our package.json file is.

After that we need to include the module as a dependency.

Moving to the javascript part, this is the implementation.

To get the consumer_key, consumer_secret, access_token_key and access_token_secret we need to create a twitter application. We are just returning the json that the module returns but we could implement something that caches the json and we just call the module every certain amount of time.

To finish the MCS part we have to upload the implementation zip file to MCS.

Moving to JET side, first we need to manually install the MCS library that can be found in your MCS instance.

Then the JET implementation looks like this:

 If we run the application we can see #ThanksOTN feed!

ADF: Update model in value change listener

There are some cases when we need to get a value associated to the new value that we have selected in a selectOneChoice, or that we have typed in an inputText.
In this cases we will not be able to get that value, as the only thing we can do is to get the new value from the ValueChangeListener object.

In this example we are going to use HR schema and we will have Employees view object. In DepartmentId field we are going to create a List of Values to show the DepartmentName value in the selectOneChoice.

We are also going to add DepartmentName field from Departments view into Employees view.

If we have to drag and drop the Employees view from the data control palette into our page and create a form.

In DepartmentId field component, we have to set autoSubmit to true and create a valueChangeListener.

If we print the values in the method. To get the value from the attribute bindings I am using resolveExpression method that can be found in JSFUtils class.

We can see that the model value will be always the previously selected value.

To display the new value associated to the selected one, we need to force the update model calling procesUpdates method.

If we run again the application we can see that the selected value is displayed.

Rio2016 Medal Standings (Part1): Using MCS internal Database

In this 3-part post series I will show how to build an Oracle MAX Application that will display the medal standing in Rio 2016.

This is what we are going to do in order to achieve our goal.

First we are going to use Oracle MCS internal database to store the urls of the flags that we will display in the application and we will also create a custom API to retrieve the records from the database.

Rio2016 Medal Standings (Part1): Using MCS internal Database

The second step is to design and implement the API that we will consume from the MAX application.

We will get the rankings using rio2016 node module that can be found in github.

Rio2016 Medal Standings (Part2): Designing and implementing rankings custom API (Coming soon)

And the last step we have to do is to build Oracle MAX application 

Rio2016 Medal Standings (Part3): Building MAX application (Coming soon)

Let's start! The node module that we are going to use to retrieve the standings doesn't give us the flags url so we need to get them.

At this moment we can display either static or remote images in Oracle MAX, but the source of the image has to be its absolute url, we cannot display images from MCS Storage. This would be a great feature to have.

I stored in a server lots of flags, but we need to know what url corresponds to each country and we will use MCS Database to do it.

First we are going to create a custom api 'RankingCountries'.

In security tab we have to disable 'Login Required' so we don't have to deal with users at this point.

In endpoints tab we have to create 3 of them.

• /load (POST method): we will use this to load the data intro the database.
• /countries: Returns all the countries.
• /countries/{id}: Returns one country.

Now we have finished the design. It's time to start the implementation.

In implementation tab we have to download the JavaScript Scaffold.

This is the first implementation we have to make, the one to load the data.

As you can see we are storing the data that we will provide in the body of the POST call into 'Country' table, where the primary key of the table is 'code'.

The this Platform API will create the table if it doesn't exists.

This is the json we have to provide. The code is the value that we will get from the node module that returns the standings.

The second implementation is the one that returns one country.

We need to provide 2 parameters in this method of the Databse Platform API. The first one is the name of the table, and the second one is the value or values of the primary key.

We will return a json like this: {"ESP": "http://mydomain/Spain.png"}

If we don't find the flag in the database we are going to return the Unknown flag.

The last implementation will return all the countries with the same format as the previous one

 {"ESP": "http://mydomain/Spain.png", "GER", "http://mydomain/Germany.png"}

We will only use /countries endpoint but wanted to show more than one operation that can be done with Database Platform API. You can check more operations like delete or merge in this link: Accessing the Database Access API from Custom Code

We have finished the implementation. In implementation tab we have to upload the .zip file into MCS.

Now it is time to test everything.
After executing the load operation we ar ready to test the two GET operations.

The first one, providing an id that does not exists, returns unknown flag values.

And if we run Countries GET operation we get all the values form the database.

OOW 2016 Session: "Going Mobile with a Hybrid Cloud and On-Premises Architecture"

I am glad to write this post because I have been selected to present a session in Oracle OpenWorld 2016 along with Javier Barrio, avanttic Sales Director.

The name of the session is "Going Mobile with a Hybrid Cloud and On-Premises Architecture" and we will present the customer success of the Oracle Mobile Cloud Service project that avanttic finished some months ago.

You can see the abstract here or in this link: http://bit.ly/2a3xn0D

If you want to learn more about the project you can check the following links:

• You can check this link to learn more in Spanish: http://bit.ly/29DmDpL 
• And read the article in Oracle Magazine here: http://bit.ly/29vyOFB

And of course don't miss the chance to assist to our session in September.

ADF: Responsive UIs using af:matchMediaBehavior

This is not a new component as it was released with version 12.2.1 back in November but it deserves a mention as it allows us to easily create responsive user interfaces. Although we were able to define media queries in our css and skin files, this component allows us to change component properties according to the screen size.

This component has 3 properties to look at:

• propertyName: Name of the property we want to change
• matchedPropertyValue: New value of the property
• mediaQuery: Here we can set the condition by defining a CSS media query. You can learn more about it here: CSS Media Queries

ADF: using popupFetchListener to execute a method before the popup opens

When developing ADF applications, a common way to create or update a record is doing it in a popup. There are many ways to do it that I have seen in some of my last ADF projects, for example:

• Executing createInsert operation in the button's action listener and then opening the popup programmatically 
• Using an action listener to create the record and using showPopupBehavior with triggerType set to click (In this case, if the button is disabled on some condition, the actionListener will be executed anyway)

In this post I am going to show you another way, using popupFetchListener.

In this example we are going to drag and drop Departments view object as a table (we don't really need it but we can see the new created record), and 2 buttons, one for creating records and other for editing them.

In each button we are going to add a showPopupBehavior component  with triggerType property set to action and popupId proerty set to the id of our popup.

ADF: tagCloud component overview

In ADF 12.2.1.1, released a couple of weeks ago, we had many new features as you can see in my previous post ADF 12.2.1.1 has been released: Bug fixes and lots of new features.

One of them is the DVT component Tag Cloud (af:tagCloud).

In this example I am going to show a quick overview of the component. I am going to use Jobs and Employees tables of HR schema.

In order to create the component we just have to drag and drop the desired viewobject into our page and select 'Tag Cloud'.

In the wizard we have to provide at least 2 fields: 'Text Value' that will be de displayed value in the tag cloud and 'Relative Size' that will determine the size of each item.
We can also create Grouping rules to make each group to have a different color or to highlight the items of the group when we hover them, etc.

If we run the application, by default we will see something like this (rectangular layout).

ADF 12.2.1.1 has been released: Bug fixes and lots of new features

Oracle has released a new version 12.2.1.1, not just and ADF version, it is a new release for all Oracle Fusion Middleware products.

Although this could be seen as a minor release, it comes with lots of new features in ADF Business Components, mainly in REST support, and Data Visualization Tools among others, as well as a lot of bug fixes.



There are many new enhancements to Gauge components, we can now set a title, border and also set the indicator wider that the plot area.

Oracle MAX: Building my first application (Part 2): Application development

In the last release of Oracle Mobile Cloud Service, Oracle Mobile Application Accelerator (Oracle MAX) and Location Services were released. In my first technical post about MCS 2.0 I am going to focus on Oracle MAX, the new tool that allows us to create applications without coding, and that will enable business users, and people that doesn't know about programming, to build applications easily.

This is a 2 part post where you can find:

• Oracle MAX: Building my first application (Part 1): Custom API design
• Oracle MAX: Building my first application (Part 2): Application development

In the first part of this post we built a Custom API that we will consume from Oracle MAX.

In order to access Oracle MAX, In Oracle MCS applications menu, we have to click on Mobile Applications.

If we want to allow a business user to access Oracle MAX we need to asign them MobileEnvironment_BusinessUser role. Any other user should not have this role as it will not be allowed to access Oracle MCS itself.

This is what we will see the first time we log into Oracle MAX. As we don't have any application, we can just create a new one.

Once we click on New Application, we will see the first wizard. We have to set the name of the application. This is the name that we will see in our device.

The next step is to define the layout among the predefined ones.

Oracle MAX: Building my first application (Part 1): Custom API design

In the last release of Oracle Mobile Cloud Service, Oracle Mobile Application Accelerator (Oracle MAX) and Location Services were released. In my first technical post about MCS 2.0 I am going to focus on Oracle MAX, the new tool that allows us to create applications without coding, and that will enable business users, and people that doesn't know about programming, to build applications easily.

This is a 2 part post where you can find:

• Oracle MAX: Building my first application (Part 1): Custom API design
• Oracle MAX: Building my first application (Part 2): Application development

Before that any user can create an application we have to design correctly our Custom API.

Oracle MAX uses business object, so first we need to define schemas for the endpoints.

In this quick example, in our Custom API we are going to have 2 endpoints

/posts that will return a list of all posts, and
/post/id that will give us the information of the post.

Now that we have our endpoints create we have to create schemas for them.

In the left hand side menu, we have to click on 'Schema', and if we don't have any schema yet, click on 'New Schema' button.

The first one is Post schema.

This is the base schema for the post object. Now we need to create a schema for every endpoint. 

For /posts endpints we will have getPosts

And for /posts/id endpoints we are going to create getPost schema.

The first step is completed. Now we need to associate the schema to each endpoints and create Mock Data in the responses to each endpoint.

At the moment it is mandatory, and if you don't have mock data you will not be able to create lists in the application. I would like to thanks Denis Tyrell and Laura Akel for their help with this issue.

For each endpoint we have to click on methods.

Then in responses we have to select the schema that corresponds to the endpoint by adding new Media Type.

And also adding mock data in examples tab.

Our first endpoints is finished, and our second endpoints will looks like:

The last step is to publish the API, because we will not be able to consume it if it is not published.

In API menu, right click on the desired API and click on Publish.

I am not going to implement the APIs as you cna check other posts like Post 1, Post 2, Post 3 or OTN Article. Implementation and design should be done by someone with development skills,

In the next post we will build the application itself and this step can be done by anyone, as the application development is based on wizards and we don't have to write any line of code.