Visual Builder

Get Involved. Join the Conversation.

Posts

  • Vinod Kumar Kv
    Salesforce rest OAUTH2 call from VBCS395.0
    Topic posted December 8, 2018 by Vinod Kumar KvBronze Medal: 1,250+ Points, tagged REST 
    Title:
    Salesforce rest OAUTH2 call from VBCS
    Summary:
    Salesforce rest OAUTH2 call from VBCS
    Content:

    Hello,

    We are trying to access datat from salesforce using oauth2 rest API authentication using VBCS services. We have created a connected app in salesforce and it working fine in postman. Same oauth2 request is not working in VBCS. Detailed screenshots of POSTMAN and VBCS setup are attached below.

    Please let us know how to make sales force OAuth2 API call from VBCS.

    Thanks

    Version:
    Version: 18.4.1
    Image:
  • Lanke Dibora
    Not able to import external js file in to VBCSAnswered315.0
    Topic posted September 18, 2019 by Lanke DiboraBronze Medal: 1,250+ Points 
    Title:
    Not able to import external js file in to VBCS
    Summary:
    Not able to import external js file in to VBCS
    Content:

    HI,

    I have followed the below url and tried, its not working for me.

    https://blogs.oracle.com/vbcs/importing-and-using-javascript-libraries-in-your-visual-builder-custom-code

    Imported gl-matrix.js as shown in attached file.

    Below is the js code.

    define(["flows/main/resources/gl-matrix"],
      function(glmatrix) {
        'use strict';

        var PageModule = function PageModule() {};

        PageModule.prototype.testFun = function() {
          var filesArr = [];
         
          var myVce3 =  glmatrix.vec3.create();
          glmatrix.vec3.set(myVce3, 0, 2.0);
          return myVce3;
        }
        return PageModule;
      });

    But I'm getting the below error.

     

     

     

    Image:
    Document:
    Error.PNG (27KB)
  • Guy Lior
    Pagination error in new version of VBCS (19.3.1.2)Answered305.0
    Topic posted October 10, 2019 by Guy LiorBronze Medal: 1,250+ Points 
    Title:
    Pagination error in new version of VBCS (19.3.1.2)
    Summary:
    Pagination error in new version of VBCS (19.3.1.2)
    Content:

    Since the new version of VBCS (19.3.1.2) I am getting the following error , was working on previous version for sure

    Error: getConfig() for "<endpoint name>" is missing required parameters: "offset", "limit"

    Any idea?

  • Vinod Kumar Kv
    How to use conditional compound filter for below criteria:...25
    Topic posted November 9, 2018 by Vinod Kumar KvBronze Medal: 1,250+ Points, tagged Business Objects, Database 
    Title:
    How to use conditional compound filter for below criteria: Service Data Provider (on table)
    Summary:
    How to use conditional compound filter for below criteria: Source: Service Data Provider (on table)
    Content:

    How to use conditional compound filter for below criteria:

    Source: Service Data Provider (on table)

    Scenario:

    By default show query all records for object with sid==$page.variables.pk

    OR

    There is filter by name text box on page: if user wants to search records based on name then use criteria
    sid==$page.variables.pk AND firstName LIKE $page.variables.nameFilter

    Basically we want to have primary key filter always. If there is value in filter text box then apply AND operator with PRIMARY KEY value

    CRITERIA: (sid==$page.variables.pk) OR (sid==$page.variables.pk AND firstName LIKE $page.variables.nameFilter)
    At any point of time only one should work.

    As of now we have below mentioned filter criteria but this code is listing all records always with .
    {
     "criteria": [
      {
       "attribute": "{{ \"sId\" }}",
       "op": "{{ \"$eq\" }}",
       "value": "{{ $page.variables.pk }}"
      },
      {
         "op": "{{ \"$and\" }}",
         "criteria": [
          {
           "attribute": "{{ \"firstName\" }}",
           "op": "{{ \"$co\" }}",
           "value": "{{  \"$page.variables.nameFilter\" }}"
          },
          {
           "attribute": "{{ \"sId\" }}",
           "op": "{{ \"$eq\" }}",
           "value": "{{ $page.variables.pk }}"
          }
         ]
      }
     ],
     "op": "{{ \"$or\" }}"
    }

     

  • ashwini pote
    View button to select columns to be displayed in the tableAnswered235.0
    Topic posted August 27, 2019 by ashwini poteBlue Ribbon: 750+ Points 
    Title:
    View button to select columns to be displayed in the table
    Summary:
    View button to select columns to be displayed in the table
    Content:

    Hi,

     

    We have a requirement of hide some of the table columns when first time data is rendered. After that, allow user to select columns from View tab/button/list to display in the table.

    In ADF, we had panel collection and by default, it was providing view menu items in the toolbar which lists all the table columns and once it is checked that column was displayed in the table. Refer : http://andrejusb.blogspot.com/2009/01/panel-collection-and-hidden-columns.html

    But I am not seeing such type of in built functionality in VBCS.

    Please help if anyone knows how to achieve same functionality in VBCS?

     

    Regards,

    Ashwini

  • Jgn P
    Business Objects Lookup using RESTAnswered225.0
    Topic posted December 11, 2018 by Jgn PBlue Ribbon: 750+ Points, tagged Business Objects, REST 
    Title:
    Business Objects Lookup using REST
    Summary:
    Business Objects Lookup using REST
    Content:

    is there a way to create a Rest End point to look up a business object row by a custom created field and not by the id field of a newly created Business Object in VBCS. I can see that by default it gives me the option to look up by id parameter but i am looking to see if it can be looked up by another custom field. 

  • Bhanu Sethi
    Search for data on a VBCS page based on a parameter value21
    Topic posted April 29, 2019 by Bhanu SethiGreen Ribbon: 100+ Points, tagged Database, REST, UI, Web 
    Title:
    Search for data on a VBCS page based on a parameter value
    Content:

    Hi,

    We have devloped a page in VBCS visual application wherein we are displaying data for the jobs submitted in the past.

    The requirement here is that if the user enters a request id in a text area the table below should show the details of the corresponding record.

    How can we achieve this in VBCS?

    Thanks in advance.

     

  • Mohana Gopal Selvam
    Resource Owner OAuth2.0 - Bearer Token ConfigurationAnswered195.0
    Topic posted July 29, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged REST 
    Title:
    Resource Owner OAuth2.0 - Bearer Token Configuration
    Content:

    Hi,

    We have Token API which doesnt have Client Id & Client Secret, it has only user name & password. I tried to create connection using 'Resource Owner OAuth2.0' authorization, but got the below error when I test my API. Please find the configuration screenshot. 

    {
        "type": "HTTP://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1",
        "status": 400,
        "title": "Bad Request",
        "detail": "{\"type\":\"abcs://proxy_problem/oauth/client\",\"title\":\"Missing OAuth Value\",\"detail\":\"Missing client_id and client_secret for third party server\",\"status\":400}"
    }

    How to achieve this in VBCS. Please note I am using OIC - VBCS.

    Thanks,

    Mohan

    Image:
  • Rajeev Singh
    ADP row count check18
    Topic posted September 5, 2019 by Rajeev SinghRed Ribbon: 250+ Points 
    Title:
    ADP row count check
    Summary:
    ADP row count check
    Content:

    Hi,

    I am calling a service and populating my ADP with response data using assign variable. How do i check if the ADP is empty or contains rows of data?

    Version:
    19.1.3
  • Mark Chappell
    How to read from 2 Business Object in 1 Action Chain18
    Topic posted June 22, 2019 by Mark ChappellBronze Medal: 1,250+ Points, tagged Action Flows, Business Objects, REST, SaaS Integration 
    Title:
    How to read from 2 Business Object in 1 Action Chain
    Summary:
    How to read from 2 Business Object (parent and child) in 1 Action Chain and contruct a single payload?
    Content:

    Hi OVBCS Guru’s

    I need some help with my OVBCS Application. I am a novice with OVBCS, and I am sure my question is a simple enough task / standard design pattern for the more experienced OVBCS practitioners out there ?? How can I construct a single payload (i.e. variable) from 2 business objects (parent and child), within the same action chain, so I can then call an external REST API passing the parent child payload to it?

    I have built a simple Sales Order application, with 1 Sales Order header and 1 Sales Order Lines table. These are based on separate Header and Lines Business Objects. I’ve created a relationship between them and have functionality to restrict the line records based on the header record selected.  I have a button within the header record table, which when pressed, gets the header record via the BO REST Endpoint, and populates a variable I’ve created. 

    This variable is based on a Service Connection I’ve created, which is based on an external REST API I want to call. This is an OICS Integration I’ve built. I can assign the data from my Header Table into my variable, and then call my Integration via an Action Chain triggered on the Button press, all good so far.

    However, my problem is, I need to also obtain the Line data on my button press action. I have attempted to update my Action Chain, to first call the REST Endpoint of the Header BO, passing to it the current action chain key value. I am then assigning the returned values to my variable. 

    My intention was then to call the REST Endpoint for my child BO and then have another Assign action to map, all of the Lines returned, to the Line Array in the same variable as above… Is this the correct approach?

    If so, how to I call the Lines BO REST Endpoint, to return only those lines associated with the Header record? As the REST Endpoints are by default taking the BO ID value? I’ve attached my VB APP, and Word Doc with additional screen shots. 

    Any help with this will be greatly appreciated.

    Thank you

    Mark.

    Document: