• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

#016 - Pulling Data from an Outside Web Service

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #016 - Pulling Data from an Outside Web Service

    SUMMARY:

    In this session we covered two interesting topics involving data sources in Nitro App Builder: (1) Pulling data from an outside JSON web service to populate a NAB widget, and (2) using the new vvIn_virtual helper function, introduced in Valence 6, through which a widget can apply filters to WITH clauses inside SQL statements.


    URL: https://www.youtube.com/watch?v=trzcMgjiD2U
    DD#16.jpg


    TIMESTAMPS AND FEATURES COVERED:

    1:23​ - Creating a Grid in NAB
    2:15​ - Going over the usage of vvln_virtual helper function
    3:50​ - Syntax for vvln_virtual
    5:50​ - Setting up a filter in the new virtual column
    7:58​ - Creating a Data Source that is consuming an outside Web Service using an SQL statement
    9:40​ - Using an URL in the Data Source that returns an array
    12:50​ - Creating a Grid based on the Data Source
    14:00​ - Creating an App listing information from the outside service
    14:30​ - Setting up Filtering using the URL parameters
    15:50​ - Adding a filter for the user to change the results displayed in the app
    17:35​ - Using Outside Web Service with User and Password
    20:20​ - Accessing the Database on a Remote IBM i
Working...
X