Parse JSON data at night within Marketo for further usage

[Franky_Ruyssch2]

Hi,

I have some data fields in my instance that are filled with json data.

I am looking for a solution to be able to parse that data within marketo at night:

e.g. within the json I have a date, which should be copied to a 'date field', which in turn would be used to do date comparisons.

Is there a wat to do that? Can I use Velocity for this?

Any suggestions?

[SanfordWhiteman · Accepted solution]

You can pass the field to a webhook, which will simply echo the JSON back and allow Marketo to pick out the individual fields.

The Postman Echo endpoint can be used for this, but the rate limits are pretty low IIRC.

You can’t use Velocity b/c it can’t make permanent changes to fields. Velocity runs in the email context only.