Use Json instead of custom objects

[Franky_Ruyssch2]

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?

[SanfordWhiteman · Accepted solution]

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.

[Tony_Mayse]

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

[SanfordWhiteman]

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.