webMethods.io message filtering not working

Hello,

We are trying to make subscriber routing filtering work without success. we are sure we are just missing out an obvious aspect :slight_smile:

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 :slight_smile:

Hi Fabien,

can you try L_EQUALS as comparison operator instead of “==”?

Regards,
Holger

finally succeed to make it works with

  • %body/object/payload/FRO_VI_ACCOUNTTYPE__c%=“Cust”

data => object (coming from standard push block)
== => =

tooltip help seems to have 2 wrong infos …
image

1 Like

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.