search

WCOMAB / SqlServerSlackAPI

SqlServerSlackAPI is a SQL Server CLR assembly for direct communication with Slack via TSQL
Microsoft Public License
29 stars 7 forks source link

JSON Message #5

Open ghost opened 8 years ago

ghost commented 8 years ago

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 commented 8 years ago

It does not parse the JSON image

jcnunez007 commented 8 years ago

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 commented 8 years ago

@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.