IF statement issue

Questions
,
#1

I’m on the final part of my Workflow but for the life of me I can’t get the IF statement to work. Any advice would be ‘greatly’ appreciated.

For a TRUE result to come back in this instance I would be looking to match the (1) “Mobile Number” from the initial Webhook {{$node[“Webhook - Twilio”].json[“query”][“From”]}} with (2) the “Mobile Number” {{$node[“LIST Airtable Numbers & IDs”].json[“fields”][“Mobile Number”]}} from the Airtable LIST. What am I doing wrong as I keep getting a FALSE result even though I know the test number matches in both these instances?

I am running the flow through a ‘manual’ ‘execute workflow’ as I am testing, but I’m sure this shouldn’t make any difference.

#2

Hey @spessex,

Can you share the json data that is coming out of of the webhook node and the airtable node with any confidential data replaced with random data of the same format?

#3

Hey @jon. Thanks for looking into this.

I have replaced the end 4 digits on any sensitive information with ‘xxxx’.

Webhook JSON:

[

{

“headers”: {

“host”: “xxxx.app.n8n.cloud”,

“x-request-id”: “f8b178f4e4e998c876fd1257d114xxxx”,

“x-real-ip”: “10.40.xx.xx”,

“x-forwarded-for”: “10.40.xx.x”,

“x-forwarded-host”: “xxxx.app.n8n.cloud”,

“x-forwarded-port”: “443”,

“x-forwarded-proto”: “https”,

“x-forwarded-scheme”: “https”,

“x-scheme”: “https”,

“x-twilio-signature”: “n/7U9Xiga/16a8gYwWDXNSAxxxx”,

“i-twilio-idempotency-token”: “37aff8da-2321-4925-882a-47632d47xxxx”,

“accept”: “/”,

“x-home-region”: “us1”,

“user-agent”: “TwilioProxy/1.1”

},

“params”: {

},

“query”: {

“ToCountry”: “GB”,

“ToState”: “”,

“SmsMessageSid”: “SM26a46c8abc552f86a54488336680xxxx”,

“NumMedia”: “0”,

“ToCity”: “”,

“FromZip”: “”,

“SmsSid”: “SM26a46c8abc552f86a54488336680xxxx”,

“FromState”: “”,

“SmsStatus”: “received”,

“FromCity”: “”,

“Body”: “Dad t11”,

“FromCountry”: “GB”,

“To”: “+44788331xxxx”,

“MessagingServiceSid”: “MG496d81cc47d63ecdc29fa78907dexxxx”,

“ToZip”: “”,

“NumSegments”: “1”,

“ReferralNumMedia”: “0”,

“MessageSid”: “SM26a46c8abc552f86a54488336680xxxx”,

“AccountSid”: “ACdb416973023b14c6d9b9d2cd1efbxxxx”,

“From”: “+44795684xxxx”,

“ApiVersion”: “2010-04-01”

},

“body”: {

}

}

]

Airtable Node JSON:

[

{

“id”: “rec9vQhvYrxrZxxxx”,

“createdTime”: “2022-08-02T13:07:08.000Z”,

“fields”: {

“Mobile Number”: “0749722xxxx”,

“Record ID”: “rec9vQhvYrxrZsz9P”

}

},

{

“id”: “recEeg6iwLfdtxxxx”,

“createdTime”: “2022-08-02T13:07:14.000Z”,

“fields”: {

“Mobile Number”: “+44771328xxxx”,

“Record ID”: “recEeg6iwLfdtq5T5”

}

},

{

“id”: “recMwllSrJQeOxxxx”,

“createdTime”: “2022-08-02T13:07:08.000Z”,

“fields”: {

“Mobile Number”: “+44744998xxxx”,

“Record ID”: “recMwllSrJQeOyX2b”

}

},

{

“id”: “recd2bzrXoExxxxxx”,

“createdTime”: “2022-08-03T14:33:15.000Z”,

“fields”: {

“Record ID”: “recd2bzrXoExxexI9”,

“Mobile Number”: “+44795684xxxx”

}

},

{

“id”: “recfm3NjEYTVUsTtL”,

“createdTime”: “2022-08-02T13:07:14.000Z”,

“fields”: {

“Mobile Number”: “+44753842xxxx”,

“Record ID”: “recfm3NjEYTVUsTtL”

}

},

{

“id”: “recicXT85Mkamxxxx”,

“createdTime”: “2022-08-02T13:07:08.000Z”,

“fields”: {

“Mobile Number”: “0789698xxxx”,

“Record ID”: “recicXT85Mkam7OqU”

}

}

]