Look at the previous answer and compare. I encourage you to read the documentation and understand fully what openjson does.
it is case sensitive so change to
from OPENJSON (@json, '$.data') as c
instead of
from OPENJSON (@json, '$.Data') as c
Look at the previous answer and compare. I encourage you to read the documentation and understand fully what openjson does.
it is case sensitive so change to
from OPENJSON (@json, '$.data') as c
instead of
from OPENJSON (@json, '$.Data') as c