Forum Discussion

whaleyl's avatar
whaleyl
New Contributor III
8 years ago
Solved

Map Incoming JSON Body

I have a requirement for a pipeline that is supposed to accept an incoming JSON body/payload of attributes in place of sending parameters via the task URL for security related reasons. For the sake...
json
mapper
transform
  • dwhansen-cbg's avatar
    dwhansen-cbg
    6 years ago

    One way I figured out to do this is use UNNEST(STRING_TO_ARRAY()) in an execute SQL snap.

    UNNEST(STRING_TO_ARRAY(nested_multi_value_field)) as unnested_multi_value_field

del's avatar
del
Contributor III
8 years ago

That is correct. Two things to note:

  • this may be obvious, but the client/consumer must submit an HTTP POST method instead of a GET method
  • as a matter of practice, the consumer should set the HTTP header Content-Type to "application/json "(although I’m not certain it’s necessary for SnapLogic with the JSON Parser as the beginning snap)
whaleyl's avatar
whaleyl
New Contributor III
8 years ago

Excellent, both very helpful tips.

I was able to test this method, and can confirm it works great. Thanks again for the quick help!