topic Re: Updating properties with html which contains double quotes in APIs & Integrations

Updating properties with html which contains double quotes

MichaelBrock — Thu, 12 Oct 2023 15:32:01 GMT

I'm working on a project for a client that wants to send a weekly sales email via HubSpot. The email is customized each week and uses html/css. I am currently using the json api to import the email body for every contact each week into a custom property which the client then uses to format the email. However, we are having issues with the formating of the email. Sending the email body in html via json api requires escaping the double quotes but their process of using the property contents for the email is not working with that and it is failing to "unescape" the double quotes. I attepted escaping the double quotes as \", \\", and also replacing them with " but nothing is working. Any ideas?

Re: Updating properties with html which contains double quotes

BérangèreL — Fri, 13 Oct 2023 08:44:19 GMT

Hi @MichaelBrock,

Thank you for reaching out to the Community!

I'd like to tag @SKathara: Hi, regarding this similar post "Import API Failing because of double quotes" how did you solve it, please, to help @MichaelBrock?

I see that you mentioned "My code was escaping the " with a \ and that was causing issue.".

I'd like to get the insights of other subject matter experts on this: @Anton, @MBERARD and @BarryGrennan do you have any advice to help @MichaelBrock, please?

Also, if anybody else has anything to add and/or share, please feel free to join in the conversation 🙂

Thanks and have a fantastic day!

Best,
Bérangère

Re: Updating properties with html which contains double quotes

MichaelBrock — Mon, 16 Oct 2023 14:21:12 GMT

I never managed to get the import to work with double quotes. Regardless of how I escaped them in the JSON when updating the contact property, they would not render correctly when used in the email. Instead, I reworked the html to use single quotes instead of double quotes to avoid having to escape any special characters.

Re: Updating properties with html which contains double quotes

Anton — Mon, 16 Oct 2023 16:26:34 GMT

Hi @MichaelBrock,

just a thought:
Since you're working with API to generate the email - would it be a an option to do it something like this:

... {% set email_body = Result of the JSON %} <body> {{ email_body|escape_json }} </body>

... {% set email_body = "{YOUR JSON result}"%} <body> {{ email_body|fromjson }} </body>

here's a description of the filters:

- escape_json

- fromjson

best,

Anton