JSON extract value

Question

I have this data in a table:

{ "keys": [ "00170000007u8uJ" ] }

I need to extract only the value 00170000007u8uJ in a SQL Server 2016 select query.

Answer 1

This should do it

declare @json           nvarchar(max)=N'{ "keys": [ "00170000007u8uJ" ] }';

select [value] from openjson(json_query(@json, N'$.keys'));

If the JSON is in a table then like this

create table #temp_json(json_col        nvarchar(max));
insert #temp_json(json_col) values (N'{ "keys": [ "00170000007u8uJ" ] }');

select [value] 
from
  #temp_json tj
 cross apply
  openjson(json_query(tj.json_col, N'$.keys'));