Skip to main content
Jon_Wright
Jon_Wright
Level 4
June 21, 2018
Question

Is it possible to NULL a field from a webhook response

  • June 21, 2018
  • 1 reply
  • 5618 views

I have a webhook which updates a picklist field in Marketo. Occasionally it will come back with an empty response, in those cases I would like it to NULL the existing value in the picklist field.

I can control what value is returned in the JSON response but when I try using a value of NULL it doesn't remove the value in the field. I guess I can get around it by returning the NULL value in a string field and then use this to NULL the picklist, but wanted to avoid the 'let's create another field' solution if possible. I'm sure Sanford Whiteman​ would be able to let me know the answer to this pretty quickly.

Thanks!

1 reply

SanfordWhiteman
SanfordWhiteman
Level 10
June 21, 2018

This is a painfully absent feature.

What I do to avoid an auxiliary field is use a Webhook Is Called trigger and scan the literal response JSON (Add Constraint - Response [contains]).

Obviously not great if you want to do this with tons of different fields but should be good for your one picklist.

Jon_Wright
Jon_WrightAuthor
Level 4
June 22, 2018

Thanks Sanford! Better than an extra field.

SanfordWhiteman
SanfordWhiteman
Level 10
June 22, 2018

Ah, one more thing: Marketo trims insignificant whitespace in JSON responses. So when doing your [contains] make sure you don't include spaces around colons.

    Terms & ConditionsAccessibility statement

    Loading footer...