Webhook Response Mapping when the results are random | Community
Skip to main content
michaelstancil
michaelstancil
New Participant
December 10, 2021
Solved

Webhook Response Mapping when the results are random

  • December 10, 2021
  • 1 reply
  • 2919 views

Hi there,

 

I have a webhook calling an API returns a list of items, the only issue is the results are not formatted the same each time, so the value of item[1].itemName may be "Blue Cars" in one call, and "Red Cars" in another, and I'm trying to get the count. All of the items I need are provided in the response, I'm just not sure how (and if) I can add the item name (with spaces) to the response attribute to grab the value.

 

I have scrubbed the response, but note that I do receive values with a space in-between them (Blue space car) as well as slashes (Green slash Blue car)

 

{"car_count":123456,"item_count":117733,"item_types":[{"item_type":"Blue Car","item_type_count":1115,"item_type_ratio":12},{"item_type":"Red Car","item_type_count":1225,"item_type_ratio":14},{"item_type":"Green/Blue Car","item_type_count":1345,"item_type_ratio":6}],"item_types_ratio":22}
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

You can’t do this with the simple dot-and-bracket notation of a Response Mapping, because there’s no way to find a property value by another property value. You’d need something like JSONPath for that, which isn’t supported.

 

So you‘d need to call your API via another intermediate webhook (i.e. “webhook gateway”) that transforms the data on-the-fly for Marketo consumption.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
December 11, 2021

You can’t do this with the simple dot-and-bracket notation of a Response Mapping, because there’s no way to find a property value by another property value. You’d need something like JSONPath for that, which isn’t supported.

 

So you‘d need to call your API via another intermediate webhook (i.e. “webhook gateway”) that transforms the data on-the-fly for Marketo consumption.

michaelstancil
michaelstancilAuthor
New Participant
December 14, 2021

@sanfordwhiteman I was hoping you would response, big fan! As far as a webhook gateway, do you have any recommendations on services that do that?

 

As far as this request, luckily the API service was able to update their service over the weekend so that I could do key value pairs,!

SanfordWhiteman
SanfordWhiteman
New Participant
December 14, 2021
As far as a webhook gateway, do you have any recommendations on services that do that?

Sure, you could’ve done that with AWS API Gateway since the transform is pretty simple.

 

AWS APIGW supports JSONPath so for example you can use the expression

$.item_types[?(@.item_type == "Blue Car")].item_type_count

which will return the item_type_count for the object with item_type "Blue Car".

 

Then you can use Velocity (!) to do other fun stuff with the results.

    Terms & ConditionsAccessibility statement

    Loading footer...