Skip to main content
Franky_Ruyssch2
Level 4
Feb 14, 2020 2:58 PM UTC
Solved

Use Json instead of custom objects

I want to use json data instead of custom objects to store event visit information. The idea is the following :

[
  {
    "event_name":"EventA",
    "event_year":"2020",
    "event_received_score":3,
    "event_received_demo":true
  },
  {
    "event_name":"EventB",
    "event_year":"2020",
    "event_received_score":4,
    "event_received_demo":false
  }
]
 
How will Marketo react if I want to query for event_name = "EventA" and "event_received_score" > 3 within that same event. Not creating a true for "event_received_score" based on the value in the second event object ( "EventB" ) 
Can this be solved?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SanfordWhiteman
SanfordWhitemanAccepted solution
User Group Leader
Feb 15, 2020 5:18 AM UTC

If you use a predictable JSON indenting format (more to the point, no indenting or whitespace at all), then even though Marketo can't actually parse JSON internally (for that, you'd use a webhook, and I certainly recommend you do for advanced logic) you can use the Contains operator.

3 replies

SanfordWhiteman
User Group Leader
SanfordWhitemanUser Group LeaderAccepted solution
User Group Leader
Feb 15, 2020 5:18 AM UTC

If you use a predictable JSON indenting format (more to the point, no indenting or whitespace at all), then even though Marketo can't actually parse JSON internally (for that, you'd use a webhook, and I certainly recommend you do for advanced logic) you can use the Contains operator.

Translate
Tony_Mayse
Level 2
Feb 18, 2020 10:35 PM UTC

It looks to me like should be using Custom Activities: https://developers.marketo.com/rest-api/lead-database/activities/#custom_activity_types

Translate
SanfordWhiteman
User Group Leader
User Group Leader
Feb 18, 2020 10:52 PM UTC

Only if you have no need to access the actual contents of the event in an email, which is an implied need if moving from COs.

Translate