Use Json instead of custom objects | Community
Skip to main content
Franky_Ruyssch2
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
Level 10
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.

View reply

3 replies

Tony_Mayse
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
SanfordWhiteman
Level 10
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
SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
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
Terms & ConditionsAccessibility statement

Loading footer...