How to validate the API JSON result with screen table output?

Hello Team,

When I request my API I am getting below formatted JSON
{
“id1”: 4107504145,
“id2”: 856469,
“id3”: 7683665,
“id4”: 1028661,
“id5”: null,
“id6”: 1196746,
“id7”: 236031,
“id8”: 1028661,
“Flag”: 0,
“month”: “2023-01-01”,
“id9”: 266937,
“id10”: 1028661,
“id11”: 1,
“Flag2”: 0,
“Hours”: 0,
“Cost”: 0,
“Id12”: 11930,
“id13”: 12349,
“reportingWorkCost”: 0,
“value”: 102.37,
“id14”: 129,
“currencyCode”: “ABC”,
“hrperyear”: 1629,
“id15”: 2,
“id16”: 1,
“Flag3”: 0,
“id17”: 230530,
“baseIds”: [
0
]
},
{
“id1”: 4107504145,
“id2”: 856469,
“id3”: 7683665,
“id4”: 1028661,
“id5”: null,
“id6”: 1196746,
“id7”: 236031,
“id8”: 1028661,
“Flag”: 0,
“month”: “2023-02-01”,
“id9”: 266937,
“id10”: 1028661,
“id11”: 1,
“Flag2”: 0,
“Hours”: 0,
“Cost”: 0,
“Id12”: 11930,
“id13”: 12349,
“reportingWorkCost”: 0,
“value”: 110.37,
“id14”: 129,
“currencyCode”: “ABC”,
“hrperyear”: 1629,
“id15”: 2,
“id16”: 1,
“Flag3”: 0,
“id17”: 230530,
“baseIds”: [
0
]
}

So how I can effectively capture the JSON value return from API and read the table value and match the value for each month against the id8.

id8 2023-01-01 2023-02-01 2023-03-01 2023-04-01 2023-05-01 2023-06-01 2023-07-01 2023-08-01 2023-09-01 2023-10-01 2023-11-01 2023-12-01
1028661 102.37 110.37 110.37 110.37 110.37 110.37 110.37 110.37 110.37 110.37 110.37 110.37
1028662 110.12 110.12 110.12 110.12 110.12 110.12 110.12 110.12 110.12 110.12 110.12 110.12

Is the id8 data in a datasheet or text file our does it need to be validated against display on a screen?

Id8 is part of API Json output .
example simplified JSON (only required key value pair to valid against display on a screen)
id common for 12 months, unique value for each month

{“id8”: 1028661,
“month”: “2022-12-31T18:30:00Z”,
“value”: 102.37,
{
“id8”: 1028661,
“month”: “2023-01-31T18:30:00Z”,
“value”: 110.37,
}
{
“id8”: 1028661,
“month”: “2023-02-28T18:30:00Z”,
“value”: 110.37,
}
{
“id8”: 1028661,
“month”: “2023-03-31T18:30:00Z”,
“value”: 110.37,
}
.
.
.
.
.
.

{
“id8”: 1028662,
“month”: “2023-01-01”,
“value”: 110.12,
}
{
“id8”: 1028662,
“month”: “2023-02-01”,
“value”: 110.37,
}
.
.
.
.
.
{
“id8”: 1028663,
“month”: “2023-01-01”,
“value”: 120.37,
}
.
.
.
.
like wise may be around 2000 to 3000 id8 unique value.