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).