Hello If the json starts with an array your script will fail Here's how to reproduce DECLARE @JsonData nvarchar(max) = '[{ "ois_id": 872326 }]', ....
Hello
If the json starts with an array your script will fail
Here's how to reproduce
DECLARE
@jsondata nvarchar(max) = '[{ "ois_id": 872326 }]',
....