7 Replies Latest reply on Jul 23, 2018 1:51 PM by Eben Saputra

    Using Location Data in Email Scripting

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