n8n + HTTP node / API + Filter = Invalid payload

Ask the community
1

Hello Community,

I have an invalid payload message on an HTTP POST call from n8n node with the following filter :

{
“filter”: {
“condition”: {
“conditions”: [
{
“leftSide”: “email”,
“operator”: “IS”,
“rightSide”: “toto@x.com”
}
]
}
},
“paging”: {
“offset”: 0,
“limit”: 1
}
}

I want to do a lookup and check if the record with email = “toto@x.com” exists in my table “contacts”

Not sure about the syntaxe of the filter section, …

Thanks for your help, …

I hope the filter option will be implement in the n8n node :wink:

2

Maybe our integration with them that we released yesterday will help you?

Otherwise, you’ll need to use the API call for “find records” and include the users recordID in that call to find out if a user exists or not, I believe.

3

Ok, got it!

Yes, I use the n8n node released few days ago.

Do you plan to implement SQL search in the node ?

1 Like
4

Not at the moment… can you explain your use case and why you need that?