Question

Photo of Matt Rouse

0

Parse JSON data in SQL

1

I'm trying to pass values from a Communication into a workflow attribute. The body of a text message is stored in a JSON file. Is there a good way to parse JSON in SQL so I can access the message value? An example of a JSON string I would want to acces in SQL:  {    "Message": "-Matt Rouse-\nAnother test!\n( @964 )",    "FromValue": "654"  }

 

Thanks!

  • Photo of David Leigh

    0

    Matt,

    It's not pretty, but this approach has been used with some success, so it might help you out:
    http://mtkcode.blogspot.com.au/2014/08/parse-json-string-by-sql-script.html