Parse JSON data at night within Marketo for further usage | Community
Skip to main content
Franky_Ruyssch2
Franky_Ruyssch2
Level 4
September 28, 2021
Solved

Parse JSON data at night within Marketo for further usage

  • September 28, 2021
  • 1 reply
  • 1192 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

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.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
September 28, 2021

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.

    Terms & ConditionsAccessibility statement

    Loading footer...