Skip to main content
Franky_Ruyssch2
Level 4
February 14, 2020
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
Level 10
February 15, 2020

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
SanfordWhitemanAccepted solution
Level 10
February 15, 2020

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
February 18, 2020

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

Translate
SanfordWhiteman
Level 10
February 18, 2020

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