Parsing a JSON string in sqlserver

Manoj_Gokhale 

ALTER PROCEDURE [dbo].[API_JCRUD_DBS_RTGS_ACK33]
@pJson VARCHAR(MAX)
AS
BEGIN
	SET NOCOUNT ON;
	BEGIN TRY
		BEGIN TRAN
			SELECT 
				 a.msgId 
				,b.responseType
				,b.senderPartyswiftBic
				,b.receivingPartybankName
				,c.address1
			FROM OPENJSON ( @pJson )
			WITH 
			(   
				 msgId VARCHAR(100) N'$.header.msgId' 
				,txnResponses NVARCHAR(MAX) N'$.txnResponses' AS JSON
			)a
			CROSS APPLY
			OPENJSON ( a.txnResponses, N'$')
			WITH 
			(   
				 responseType VARCHAR(100) N'$.chargesAmount'
				,senderPartyswiftBic VARCHAR(100) N'$.senderParty.swiftBic'
				,receivingPartybankName VARCHAR(100) N'$.receivingParty.bankName'
				,bankAddresses NVARCHAR(MAX) N'$.receivingParty.bankAddresses' AS JSON
			)b
			CROSS APPLY
			OPENJSON ( b.bankAddresses, N'$')
			WITH 
			(   
				address1  VARCHAR(100) N'$.address'
			)c
		COMMIT TRAN
	END TRY
	BEGIN CATCH
	END CATCH
END