(SQL Server) JSON AppendArray Example
Demonstrates the AppendArray function.
// Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
//
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @sTmp0 nvarchar(4000)
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
EXEC sp_OAMethod @json, 'Load', @success OUT, '{ "name": "John", "marbles": 100 }'
-- Append an empty array named "xyz"
DECLARE @jarr int
EXEC sp_OAMethod @json, 'AppendArray', @jarr OUT, 'xyz'
EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
PRINT @sTmp0
-- Expected output is: {"name":"John","marbles":100,"xyz":[]}
-- Add elements to the array.
EXEC sp_OAMethod @jarr, 'AddStringAt', @success OUT, -1, 'hello'
EXEC sp_OAMethod @jarr, 'AddIntAt', @success OUT, -1, 256
EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
PRINT @sTmp0
-- Expected output is: {"name":"John","marbles":100,"xyz":["hello",256]}
EXEC @hr = sp_OADestroy @jarr
EXEC @hr = sp_OADestroy @json
END
GO
|