I'm getting an error when trying to send a HTTP API request from clay

sorry this is the correct image

💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

https://app.clay.com/workspaces/4711/tables/t_6Rd7NGpNXS2b/views/gv_FPEiheMdZd2v

Add double quotes around the dynamic columns and it should be good.

A quote is missing around email column.

Hey, thanks for reaching out Parth - Seems like you made it work but now we're getting 400 error from the API, which usually indicates a bad request. The error message suggests that ngrok is unable to connect to the upstream service running at localhost:8080. This is likely causing the issue in Clay when trying to run the integration. It looks like the integration error is a 400 error from the API, which usually indicates a bad request. The error message suggests that ngrok is unable to connect to the upstream service running at localhost:8080. This is likely causing the issue in Clay when trying to run the integration. Here’s a step-by-step guide to troubleshoot and resolve this: 1. Check Localhost Service • Ensure the service you are connecting to on localhost:8080 is running and accessible. • Verify that there are no firewalls or restrictions preventing ngrok from tunneling to that service. 2. Verify ngrok Configuration • Confirm that your ngrok setup is correctly configured to tunnel to localhost:8080. • You can check this by running: ngrok http 8080 • Make sure the ngrok URL matches what’s configured in your Clay integration. 3. Restart the ngrok Session • Sometimes, restarting ngrok can help. Stop the current ngrok session and run it again: ngrok http 8080 • Update the Clay integration with the new ngrok URL if it changes. 4. Check the API Request Format • Review the request Clay is sending through the ngrok tunnel to ensure it meets the API’s expected format. • Ensure all required headers, parameters, and endpoints are correctly set up. 5. Review ngrok Logs for More Details • Use the command: ngrok logs • This will provide you with more detailed logs on what might be causing the connection refusal or other issues. 6. Update or Reinstall ngrok if Needed • Ensure you have the latest version of ngrok. Sometimes, updating or reinstalling can fix tunneling issues. If the issue persists after following these steps, feel free to reach out with any specific error messages or logs you encounter, and we can dig deeper into the problem! 😊🚀

This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.