HELP: How can I parse JSON from a contact property in an email?

[JuliaVallina]

I have taken a look at Hubspot's docs and I don't think this is possible. I also asked Support and they couldn't give a solution.

But I'd love to get more opinions on this.

Let me share the scenario we want to build.

We want to send monthly summary emails to our users.
In our product, a user could have several workspaces and we want to send an email with custom charts for each workspace.

The ideal situation for us would be to store all the information of all the workspaces in a unique Hubspot property in JSON format, because a user can have one workspace but another user can have 10 and we don't want to create 10 properties (one for each workspace).

We stored this information as a JSON in a custom property in the contact.
And we want it to use it in an email, parse it and iterate over the different workspaces to build the email.
But we can't parse nor read the JSON properties in the email.
We are using the filter `fromjson` from your docs (https://developers.hubspot.com/docs/cms/hubl/filters).
We have seen in your docs that Hubl filters are not available in emails.

Is there any alternative anyone can think of?
We really appreciate any help!

[alyssamwilie · Accepted solution]

If you have Marketing Hub Profressional or Enterprise you can use Programmable Email modules which enable the use of filters and other advanced syntax.

[JuliaVallina]

Thank you very much!

I have made a quick test and it just worked.

We'll give this a try

We'll get more deep into it and I'll try to update this thread when we have the email fully built.