Using Location Data in Email Scripting

Question

We have a JSON source of data with information on 150 locations. Based on a field ID in a person we would like to load the data for 1 of those locations into an email (Address etc).

We see two possible options but are seeing issues both routes:

Import the data as a custom object with API into Marketo. Each location is a separate entry. The problem is how in my email do I load a specific entry based on a field ID in a Person?
Import all the data as a token into Marketo. The problem I am stuck on here is how can I pull just the location I need (Do I have JSON Path or would it have to be nested array structure). and if the JSON structure were to change I would have to update every single email template (Instead of 1 piece of code for import).

SanfordWhiteman · Accepted Answer

You can't do this with a Custom Object -- there's no such thing as a shared CO (2nd-level CO) that's accessible from Velocity. So [1] is just not an option. (Which is fine, [2] is a good approach.)

(Do I have JSON Path or would it have to be nested array structure). and if the JSON structure were to change I would have to update every single email template (Instead of 1 piece of code for import).

You don't have JSONPath, so you'd be iterating over a List or Map (of course any userland JSONPath implementation is actually doing the same thing).

I don't see why that would even be necessary, if the keys of a Map are your field IDs you can just seek right to them.

You also don't need to update any templates if your matching criteria change, just change the Velocity token that does the seeking. One change in one place.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded