JSON Message

[ghost]

Hi @devlead

Please can you advise how to use the JSON message formatting with this API.

What changes need to be made to the code below?

Thanks

SELECT Ok,
Channel,
TimeStamp,
Error
FROM dbo.SlackChatPostMessage(
'token',
'channel',
'message',
null,
null
)

Sana

[ghost]

It does not parse the JSON

[jcnunez007]

You'll have to use another SP, Function or SQL 2016 to finish this off. I've had success with this...SerializedJSON Stored Procedure

Good Luck!

[devlead]

@sanazhussain @jcnunez007 the WCOM SqlServerSlackAPI assembly actually has it's own json serializer built in, so should be fully possible to add support for this for both SQL Server 2012, 2014 and 2016. Just not been a scenario we've had time to explore our selves.