Where to put spaces in JSON (integrating Zapier)

@jjay.lewin

As far as I understand JSON formatting, it doesn’t seem like spaces are relevant for the formatting in general. Think of how you can “minify” CSS or JS code from a human-readable format to a single line of text without issues to improve website loading speed, if that makes sense?

It seems to me that the part above is where you’re having issues. As far as I understand, you’re missing a double quote before the email address value that you are trying to parse through Zapier, thus you’re getting a 200 error code. Do you think that could be the root cause here?

Here’s an example of how you’d format column_values for the email column on the Try-It-Yourself page by connecting to our API directly. The formatting should keep the same spirit on Zapier’s end too:

{\“email\” : {\“email\” : \“example@example.com\“,\“text\“:\“my email\“}}“)

Let me know if that sheds a bit more light on this. It can be somewhat confusing to deal with JSON at first, but having some examples can really help get to a point where things work, at least :slight_smile:

-Alex

2 Likes