Hello,
We are trying to make subscriber routing filtering work without success. we are sure we are just missing out an obvious aspect
We publish a salesforce CDC (capture data change) to a topic as object (not string)
Seen in the log, this is the structure we got out of it
> {
> "JMSMessage": {
> "properties": {
> "JMSXDeliveryCount": 1
> },
> "header": {
> "JMSCorrelationID": null,
> "JMSDeliveryMode": 2,
> "..." : "..."
> },
> "body": {
> "object": {
> "payload": {
> "LastModifiedDate": "2023-05-25T15:17:40.000Z",
> "FRO_VI_ACCOUNTTYPE__c": "Cust"
> }
> }
> }
> }
> }
> }
We would like to trigger a workflow only if JMSMessage.body.payload.FRO_VI_ACCOUNTTYPE__c = “Cust”
All our attempts failed so far, we saved + skip + save all the time. How it’s triggered
we tried
- %JMSMessage/body/object/payload/FRO_VI_ACCOUNTTYPE__c%==“Cust”
- %JMSMessage/body/object/payload/FRO_VI_ACCOUNTTYPE__c%=“Cust”
- %body/object/payload/FRO_VI_ACCOUNTTYPE__c%==“Cust”
- %body/payload/FRO_VI_ACCOUNTTYPE__c%==“Cust”
- %body/data/payload/FRO_VI_ACCOUNTTYPE__c%==“Cust” (documentation points to data rather object)
any help would be appreciated