Comments

  • Vinod Kumar Kv

    Hello,

    We have already tried  OAuth Resource Owner Password and screenshot you have seen is old one. We are getting the same error with  OAuth Resource Owner Password.

    It will be good if you could share VBCS - Salesforce integration checklist which will help us to move forward.

    Thanks

  • Vinod Kumar Kv

    Hello Shay,

     

    Can you please step in and support us on this, we are having this issue for a while now and not able to move forward.

  • Vinod Kumar Kv

    Hello John,

    Thanks for your reply but it looks irrelevant in the present context as it refers to a totally different platform (OIC) and the tools available there are not supported by VBCS currently.

    We want to do the OAuth in VBCS using REST API not SOAP.

    Please let us know if you require more information from us on this issue.

    Thanks

  • Vinod Kumar Kv

    Hello Thomas

    Please find below the flow for OAuth calls made to salesforce:

    CALL 1 (To receive instance_url, token_type and access_token ):
    TYPE: POST
    URL:  https://login.salesforce.com/services/oauth2/token?grant_type=password&client_id=USER-CLIENT-ID&client_secret=USER-CLIENT-SECRET&username=USER-NAME&password=USER-PASSWORD-SALEASFORSE-TOKEN

     We need to pass username:password and clientid:secret  in the URL as shown in the above  CALL 1 URL 

    RESPONSE from CALL 1:
    {
        "access_token": "00D90000000npjw!AQcAQJIqLM7_PUP6ahbzFikmeWM4tY._t78FvLnthYyb6DjPUWrcHGhWHrUjBI3tA94W_3lRwZ.p55BQMBIQ5zUU_70zThgE",
        "instance_url": "https://nguleria-dev-ed.my.salesforce.com",
        "id": "https://login.salesforce.com/id/00D90000000npjwEAA/00590000001HuRnAAK",
        "token_type": "Bearer",
        "issued_at": "1545146633690",
        "signature": "gKI+aM5jQn6fjKYaD3Pvm71QqlwJo5+C2Xj92uCxL0g="
    }

    -------------------------------------------------------------------

    CALL 2 (To get data from salesforce):
    TYPE: GET
    URL: https://nguleria-dev-ed.my.salesforce.com/services/data/v43.0/query/?q=SELECT+name,email,MailingCity+from+Contact 
    REQUEST HEADER of CALL 2: Authorization Bearer 00D90000000npjw!AQcAQJIqLM7_PUP6ahbzFikmeWM4tY._t78FvLnthYyb6DjPUWrcHGhWHrUjBI3tA94W_3lRwZ.p55BQMBIQ5zUU_70zThgE
    instance_url, token_type and access_token received in call 1 will be input to call 2 to fetch data from salesforce using OAuth

    We need to put token_type and access_token as request header (as attribute - Authorization) in CALL 2 to fetch information from salesforce.

    RESPONSE from call 2:
    {
        "totalSize": 1,
        "done": true,
        "records": [
            {
                "attributes": {
                    "type": "Contact",
                    "url": "/services/data/v43.0/sobjects/Contact/0039000002WwwLEAAZ"
                },
                "Name": "Naveen Guleria",
                "Email": "naveen.guleria@gmail.com",
                "MailingCity": "Bangalore"
            }
        ]
    }

    We are trying to use VBCS services for this but not able to make salesforce OAuth working.

    Please let us know if you require more information.

    Thanks

  • Vinod Kumar Kv

    Hello John,

    Thanks for your appreciation. we are in the process of making complete video of the product.

    Meanwhile your understanding is correct we are using $co for name and $eq for surveyType

    Thanks

     

     

  • Vinod Kumar Kv

    Thanks John,

    We are using VBCS version: Version: 18.4.1

    We are doing the same as mentioned above. It is working.

    The problem is when the page loads the first time and we only want to filter by serveyType dropdown filter and click the button no filter data is retrieved. Now we keep the dropdown filter as it is and simultaneously enter some filter in the text box then filter criteria seems to be working. This happens only the very first time where both needs to be selected after that each individual criteria works independently.

    Thanks

  • Vinod Kumar Kv

    Hello Shay,

    We have further analyzed this issue and found that filter starts working if we make a filter call by supplying both filter valuesName and Type). 

    If we supply value only for Type after page load it will not work. We also have seen network tab in debug console and found that no REST calls are issued on clicking  search.

    Once we put value in text field as well as select value from dropdown filter starts working and we see  REST calls in network tab as well.

    Is this desired behavior or bug?

    Thanks

  • Vinod Kumar Kv

    Hello Shay,

    Thanks for your reply:

    As per requirement ​filter shown on attached screen image should work for below conditions:

    1) no filter if nothing is selected as criteria

    2) Append name text for filtering records (only Name as filter)

    3) Append type text for filtering type (only Type as filter)

    4) Append name and type for filtering records (Name and Type both as filter)

    Please see attached image for screen filter not working and filter criteria JSON.

    Please guide us how to achieve processing of this filter criteria in VBCS

    Thanks

  • Vinod Kumar Kv

    Hello,

    Compound filter is not working as expected:

    Scenario: We have two fields on page for search criteria: Name(oj-input-text) and Type ["Online", "Email", "Sms"] (oj-select-one)

    Now filter should work for below conditions:

    1) no filter if nothing is selected as criteria

    2) Append name text for filtering records (only Name as filter)

    3) Append type text for filtering type (only Type as filter)

    4) Append name and type for filtering records (Name and Type both as filter)

    We followed the link for building advance filter criteria: https://blogs.oracle.com/shay/filtering-data-providers-with-compound-conditions-in-visual-builder

    As we run our VBCS application filtering is not working as expected because it keeps one of the criteria as default criteria and other criteria which is not default will not work unless and until you have something in default criteria associated by VBCS (in our case name text).

    Please guide us how to achieve filtering as we have mentioned above.

    Thanks

  • Vinod Kumar Kv

    Hello,

    Please let us know how to make aggregate and group-by rest calls in VBCS as this has huge impact and dependency on reports we are generating. 

    Thanks

  • Vinod Kumar Kv

    Hello Thomas,

    Thanks for your reply. 

    We have already gone through the twitter blog also.

    Can you please provide us steps to configure OAUTH2 call to salesforce server from VBCS in-case we have missed minor steps.

    Thanks

  • Vinod Kumar Kv

    Hello,

    Any update on Salesforce OAuth2 rest API implementation in VBCS because we have demo with he client. 

    Thanks

  • Vinod Kumar Kv

    Hello John,

    Thanks a lot for quick reply.

    Regards

  • Vinod Kumar Kv

    Hello Christopher,

    Thanks for your reply but this way we can get access to whole application anonymously.

    We want only particular pages (2 or 3 pages) to be accessible anonymously. Rest all pages should be accessed only after login.

    How to achieve this in VBCS?

    Thanks

  • Vinod Kumar Kv

    Hello Thomas,

    Please find attached Network.har

    Thanks

    network.har (133KB)