I’m trying to transition from Airtable to CODA and need help with a Make 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:
RuntimeError
[400] Bad Request: Unexpected token ‘/’, “//www.airb”… is not valid JSON
Origin
Coda
Steps taken so far
I’ve checked the JSON output from Apify, and it’s valid.
I suspect CODA might not be handling the query they i am writing it, but i am new at this.
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 CODA module.
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
others can save time when catching up with the latest activity here, and
allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
Could you please create a separate topic for your question?
While it’s tempting to continue an existing thread, a more effective approach would be to start a new topic. It helps other community users to respond to your query, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy.
The “New Topic” link can be found in the top-right of the header:
