SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

DECLARE @Json nvarchar(max) = '[
  {
    "attributes": {
        "2003": "Some text",
        "2004": 0,
        "2006": 0,
        "2008": 0,
        "2011": 0,
        "2120": 0
    },
    "path": "/Path1",
    "changeDate": "2019-11-11T13:56:37.987Z",
    "guid": "00000000-0000-0000-0000-000000000000",
    "version": 0,
    "timestamp": "2019-11-11T14:21:14.86427Z"
  },
  {
    "attributes": {
        "2121": 0,
        "2297": 0,
        "2298": 0,
        "2299": 0,
        "2805": 0,
        "8501": 0,
        "12004": 0,
        "13266": 0,
        "13282": 0

},
    "path": "P:/Path2/SubPath",
    "changeDate": "2019-11-11T13:55:35.943Z",
    "guid": "705b30ab-53b0-42ee-bb98-6d80daae2e18",
    "version": 1,
    "timestamp": "2019-11-11T09:08:54.417Z"
  },
  {
    "attributes": {},
    "path": "PP:/OneMorePath",
    "changeDate": "2019-11-11T14:20:49.5Z",
    "guid": "b9aac8f3-1f2a-4b52-b8d8-af6b654d3f0f",
    "version": 41,
    "timestamp": "2019-11-11T13:26:24.723Z"
  }
]';

CREATE TABLE [dbo].[Foo]
(
    [Id] UNIQUEIDENTIFIER NOT NULL PRIMARY KEY DEFAULT(NEWID()),
    [Path] NVARCHAR(128) NOT NULL,
    [ChangeDate] DATETIME NOT NULL,
    [Guid] UNIQUEIDENTIFIER NOT NULL,
    [Version] INT NOT NULL,
    [Timestamp] DATETIME NOT NULL
)

CREATE TABLE [dbo].[FooAttributes]
(
    [Id] UNIQUEIDENTIFIER NOT NULL PRIMARY KEY DEFAULT(NEWID()),
    [IdFoo] UNIQUEIDENTIFIER NOT NULL,
    [Key] INT NOT NULL,
    [Value] NVARCHAR(255) NOT NULL
)

SELECT *
FROM OPENJSON(@Json)
      WITH (
        [Path] NVARCHAR(128) 'strict $.path',
        [ChangeDate] DATETIME2 '$.changeDate',
        [Guid] UNIQUEIDENTIFIER '$.guid',
        [Version] INT '$.version',
        [Timestamp] DATETIME2 '$.timestamp'
      )

SELECT [Guid],  [key], [value]
FROM OPENJSON(@Json)
      WITH (
        [Guid] UNIQUEIDENTIFIER '$.guid',
        [Attributes] NVARCHAR(max) '$.attributes' As Json
      )
CROSS APPLY OPENJSON(Attributes)

Path	ChangeDate	Guid	Version	Timestamp
/Path1	2019-11-11 13:56:37.9870000	00000000-0000-0000-0000-000000000000	0	2019-11-11 14:21:14.8642700
P:/Path2/SubPath	2019-11-11 13:55:35.9430000	705b30ab-53b0-42ee-bb98-6d80daae2e18	1	2019-11-11 09:08:54.4170000
PP:/OneMorePath	2019-11-11 14:20:49.5000000	b9aac8f3-1f2a-4b52-b8d8-af6b654d3f0f	41	2019-11-11 13:26:24.7230000

Guid	key	value
00000000-0000-0000-0000-000000000000	2003	Some text
00000000-0000-0000-0000-000000000000	2004	0
00000000-0000-0000-0000-000000000000	2006	0
00000000-0000-0000-0000-000000000000	2008	0
00000000-0000-0000-0000-000000000000	2011	0
00000000-0000-0000-0000-000000000000	2120	0
705b30ab-53b0-42ee-bb98-6d80daae2e18	2121	0
705b30ab-53b0-42ee-bb98-6d80daae2e18	2297	0
705b30ab-53b0-42ee-bb98-6d80daae2e18	2298	0
705b30ab-53b0-42ee-bb98-6d80daae2e18	2299	0
705b30ab-53b0-42ee-bb98-6d80daae2e18	2805	0
705b30ab-53b0-42ee-bb98-6d80daae2e18	8501	0
705b30ab-53b0-42ee-bb98-6d80daae2e18	12004	0
705b30ab-53b0-42ee-bb98-6d80daae2e18	13266	0
705b30ab-53b0-42ee-bb98-6d80daae2e18	13282	0