3 Replies Latest reply on May 26, 2016 9:56 AM by Sanford Whiteman

    How can I set a data field to NULL from a webhook?

    Jon Wu

      Is this possible?

       

      Let's say I have a field named HighestScoredCategory and I update that with a webhook that returns JSON such as {"categoryName":"Invitations"} that writes categoryName to HighestScoredCategory.

       

      Is it possible to return something like {"categoryName":null}, to clear the contents of HighestScoredCategory as if I set it to NULL from Marketo? All of the following seem to be ignored:

      {"categoryName":null}

      {"categoryName":NULL}

      {"categoryName":"NULL"}

      {"categoryName":false}

       

      These actually set the string literally (as you might expect, but it was worth trying):

      {"categoryName":"null"}

      {"categoryName":"[null]"}

       

      My current workaround is to return None and add a flow step to update None to NULL. This works fine, but isn't ideal since depends on manual steps from marketing and might not happen everywhere it should.