Overcoming Challenges: Trimming Whitespaces in JSON for Make.com Users

Have you ever encountered a problem where you get an error message saying “Invalid JSON” when you try to parse JSON right after a webhook? This could be due to spaces before or after a value in your JSON. For instance, you might have something like this: " Value" or "Value ".

So, how do you trim any possible white space that are more than 1 at any value in your JSON? Let's walk through a solution.

Step 1: Identify the Problem

First, you need to understand that extra spaces within a value shouldn’t cause it to become invalid, since you can have spaces within a value. The problem could be that the JSON is not properly formatted at its source.

Step 2: Fix the JSON at its Source

If you have access to the source of the JSON, it’s better to just fix the generated JSON there. This will prevent the issue from recurring in the future.

Step 3: Use Trim Function

If you can't fix the JSON at its source, you can use the trim function after you have sent the existing queue to an external webhook. Make sure to set the content type into JSON.

Step 4: Check the Content-Type Headers

Another possible cause of the problem is that the content-type headers are not being used. Make sure to include these in your JSON.

Troubleshooting Tips

If you're still encountering problems, try to check the original data. The error could be caused by everything under ‘value’ being formatted as JSON.

In conclusion, dealing with JSON and webhooks can sometimes be tricky, but with the right approach and tools, you can easily overcome these challenges. Remember to always check your JSON at its source and use the appropriate functions and headers.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.