[HELP] I can't use the jmespath function, referenced to a node value

Questions
,
1

image
image994×519 19.5 KB

{{ $jmespath($(‘ASSINATURAS - APPS’).first().json[“data”], “[?ProductId==24].Id”) }}

{{ $jmespath($(‘ASSINATURAS - APPS’).first().json[“data”], “[?ProductId==$json.produto_delete].Id”) }}
{{ $jmespath($(‘ASSINATURAS - APPS’).first().json[“data”], “[?ProductId==$json.produto_delete].Id”) }}
{{ $jmespath($(‘ASSINATURAS - APPS’).first().json[“data”], “[?ProductId==$json.produto_delete].Id”) }}

{{ $(‘LISTA DE ASSINATURAS’).item.json.produto_delete }}
{{ $json.produto_delete }}

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
4

Hi @Ruan17, when using JMESPath you’d need to ensure your expression resolves to a valid JMESPath expression. This can be a bit tricky at times.

Perhaps you can confirm the exact JSON data structure you currently have in a first step? In particular the JSON data from your ASSINATURAS - APPS node as well as the JSON data coming in on your current node.