Hi Developers,
how to convert json data into table format and bulk insert in sql server ,
Json Value : [
{
"groupUserAccessRight": "Contributor",
"displayName": "EDGe_pbiapi",
"identifier": "ee0454e8-bac6-494c-b324-22abe024afb8",
"principalType": "Group"
},
{
"groupUserAccessRight": "Contributor",
"displayName": "Denodo – TD2SNF",
"identifier": "b6929b22-f91e-47c2-a37f-d9fc3275b367",
"principalType": "Group"
}
]
I have to insert this value by bulk.
What i am tried :
CREATE PROC [dbo].[SP_TEST]
@jsonValue NVARCHAR(MAX),
@workspaceid NVARCHAR(MAX),
@reportId NVARCHAR(MAX),
@UserId NVARCHAR(MAX)
AS
BEGIN TRY
BEGIN
DECLARE @groupUserAccessRight AS VARCHAR(max)
DECLARE @principalType AS VARCHAR(max)
DECLARE @EmailAddress AS VARCHAR(max)
INSERT INTO TEST (groupUserAccessRight,principalType) values(groupUserAccessRight,principalType)
SELECT groupUserAccessRight,principalType FROM OPENJSON (@jsonValue)
WITH (
groupUserAccessRight varchar(max) '$.groupUserAccessRight',
principalType varchar(max) '$.principalType'
)
END
I did not get exact output. So if anyone know kindly suggest me to done this task.
Regards,
Paul.S