In Oracle CX Sales, how to create a REST URL with two search parameters using the q=
In CX Sales, I have three opportunities fields: one called PrimaryContactPartyNumber, the other is called CPCStatus_c, and the other OpportunityType_c. The need is to create a REST service that retrieves opportunities based on these fields.
Initially, for example, I have this one for PrimaryContactPartyNumber, and it works correctly:
/crmRestApi/resources/11.13.18.05/opportunities?q=PrimaryContactPartyNumber='1003502'
Then this one for filtering by OpportunityType_c works correctly: OpportunityType_c == 'Consumer Credit'
If I use the first option, it works and returns three records for this customer, but if I use a combination of both, it returns no records. This is the usage example: /crmRestApi/resources/11.13.18.05/opportunities?q=PrimaryContactPartyNumber='1003502' and TipoDeOportunidad_c='Consumer Credit'