Hello
I have been working heavily on N8N these days (maybe my messages here are an indication )
I spent all day challenging myself to solve my issue but I tried everything I could think off and could not figure it out.
So I am calling an API that gives me public company accounts (nothing confidential) and I want to query a specific value and extract it.
My current workflow is the following:
- First node sets a company ID and a code
- Second node calls the account details through an HTTP request
For each year, for the code set in first node, I am trying to extract the value for the key âMontant brut annĂ©e Nâ.
Here itâs maybe clearer in this screenshot:
I have been trying to split and filter, also tried code using GPT4 with a dozen solutions but none worked as intended.
I made a simple workflow where I have added the HTTP request JSON output as set node for testing.
Unfortunately Discourse doesnât let me paste it because the JSON is too large so you will find the workflow ready to copy paste here: { "meta": { "instanceId": "1d17b93da6a4dfec32237d10fc41b01c9bcb5fe4cfc1f - Pastebin.com
Could anyone give me a hand here? I would really appreciate it.
Thank you!