AnsweredAssumed Answered

Using Location Data in Email Scripting

Question asked by Eben Saputra on Jul 18, 2018
Latest reply on Jul 23, 2018 by Eben Saputra

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:


  1. 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?
  2. 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).