AnsweredAssumed Answered

Webhook JSON response mapping - iterating values

Question asked by Asha Kamble on Jun 6, 2019
Latest reply on Jun 6, 2019 by Jay Jiang

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

Outcomes