Visual Builder

Get Involved. Join the Conversation.

Topic

    James Pitman
    How to manually control the q variable assignment on a SDP?
    Topic posted August 27, 2019 by James PitmanGreen Ribbon: 100+ Points, tagged REST 
    10 Views, 2 Comments
    Title:
    How to manually control the q variable assignment on a SDP?
    Summary:
    Oracle Engagement Cloud has a REST API glitch where certain Id field searches works weird for "OR" condition
    Content:

    We have an issue where Oracle Engagement Cloud has a REST API glitch.  Certain Id field searches works weird for "OR" conditions and we need to be able to manually control the SDP q parameter setting.  We want to continue to use a SDP and not switch to an ADP since pagination is controlled more automatically.

    This does not work in REST test tool.

    https://dummy.fa.us2.oraclecloud.com:443/crmRestApi/resources/latest/opportunities/?q=SalesStageId = '300000010344169' or SalesStageId ='300000010344169' or SalesStageId='300000010344170'

    This does work in REST test tool

    https://dummy.fa.us2.oraclecloud.com:443/crmRestApi/resources/latest/opportunities/?q=SalesStageId = '300000010344169' or '300000010344169' or '300000010344170'

    As you can see we need to be able to suppress the repeating field name that the normal filter criterion process adds to the q parameter.

     

    Any thoughts would be helpful.  Relief from an Oracle SR on Engagement Cloud REST will be slow moving.

    Version:
    19.1.3

    Comment