Help Needed: Checking for Existing Rows in CODA via Make.com

[Nick_Lamoureux]

Hey everyone,

I’m trying to transition from Airtable to CODA and need help with a Make.com scenario. My goal is simple:

I scrape Airbnb listings using Apify.
I check if the scraped URL already exists in my CODA table (by looking at the URL column).
If it exists, do nothing. If it doesn’t, I add the new data to the table.
However, I’m running into an error in the first step when querying CODA:

Blockquote
RuntimeError
[400] Bad Request: Unexpected token ‘/’, “//www.airb”… is not valid JSON
Origin
Coda

I’ve checked the JSON output from Apify, and it’s valid. I suspect CODA might not be handling the query correctly.

Has anyone encountered this issue?

Is there something wrong with my query format? Or does CODA require a different approach to checking for existing rows?

I’ve also attached a screenshot of my Make.com CODA module.

Would love any insights! Thanks in advance.

[Nick_Lamoureux]

Well this was the answers :

Looks like you should remove the < > brackets around <URL>, and add double quotes, like this:

"URL":"{{3.url}}"