Webhook JSON response mapping - iterating values | Community
Skip to main content
Asha_Kamble1
Asha_Kamble1
New Participant
June 6, 2019
Question

Webhook JSON response mapping - iterating values

  • June 6, 2019
  • 2 replies
  • 4637 views

Hi, 

 

I am working with Marketo webhooks. I need to map JSON response similar to below, where "orderDate" is to be mapped to a Marketo field. However, I need to get every "orderDate" from this response and compare it with the existing marketo field value. In case, if anyone has tackled this kind of scenario before, I can use some help.

 

{ "profileId" : 1234, "firstName" : "Jane", "lastName" : "Doe", "orders" : [ { "orderId" : 5678, "orderDate" : "2015-01-01", "orderProductId" : "4982" }, { "orderId" : 5672, "orderDate" : "2014-05-07", "orderProductId" : "4982" }, { "orderId" : 5673, "orderDate" : "2014-03-02", "orderProductId" : "4982" } ] }

 

Thanks in advance,

Asha Kamble

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

2 replies

Jay_Jiang
Jay_Jiang
New Participant
June 6, 2019

I'm guessing you're trying to record the latest value so in response, you should look into using a handler that you code yourself

instead of sending the payload profileId={{lead.profileId}} directly to the external system, send the payload profileId={{lead.profileId}}&orderDate={{lead.orderDate}} to a handler which

1. forwards the request profileId={{lead.profileId}} to the external system and gets the full json response

2. parses the json response from the external system and handles the comparison logic for orderDate={{lead.orderDate}}

3. returns only the value for the latest orderDate {'orderDate':'2015-01-01'} to marketo

Jay_Jiang
Jay_Jiang
New Participant
June 6, 2019

alternatively, if you're only using the data in email comms and not for filtering or anything, you can then just write the whole response to a textarea field and manipulate the json using velocity

Oz_Platero
Oz_Platero
New Participant
September 2, 2020

@jay_jiang ,

How would you go about capturing the whole JSON response?

thanks

SanfordWhiteman
SanfordWhiteman
New Participant
June 6, 2019

Please edit your post & highlight the JSON (like all code) using the Advanced Editor's Syntax Highlighter.

When you say "compare it" -- to what end? Are you only trying to overwrite the value stored in Mkto if the value in the JSON is later, for example, taking the latest of the later values? Be exact: while it's very unlikely that you can do what you want without passing the response through a webhook gateway, we need to know your technical objective.

Terms & ConditionsAccessibility statement

Loading footer...