Super basic http request does not work with {{ $json.URL }} :(

I know it is super basic; but
my http request only work when I hard code the URL itself and does not with: {{ $json.URL }}

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:

ok I almost figured it
by using the item path

but how I could make the
{{ **$item("0")**.$node["If"].json["URL"] }} dynamic so it loop into each line

Hmm, it seems to work as expected for me - what exactly is not working for you?

I assume you receive multiple items from the Google Sheet Trigger node and not all of them have a valid value for URL set. So the HTTP Request node works for some (the ones that have a valid value) but fails for the one(s) that do(es) not.

1 Like

in my test I have 3 new rows

  • I added another IF to filter if NO URL, because when I add a blank line it was breaking the flow

my issue is the result of item (“0”) which is the first new row
{{ **$item("0")**.$node["If"].json["URL"] }} dynamic so it loop into each line
is copied into row 2 and 3

I did try with a loop, but no luck

  • but why {{ $json.URL }} can’t work
    it would be so simple

@jan and @bartv
how would you do that ?

here a sample shared publicaly with editor right

my actual workflow which point to the sample sheet

with an example of the desired result

Are you experiencing the same error? For me, everything is working fine

1 Like

To be clear. If you filter out empty ones {{ $json.URL }} should work totally fine.

  • Yes I filter the empty line without URL) at the 1st IF

2024-03-2407-52-49-ezgif.com-video-to-gif-converter

Please switch from “Schema” to “Table” view. There you will then probably see that there are 3 different URLs. Then try each of the one by one, and I assume one of them will result in exactly the error you are seeing.

2 Likes

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