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

1

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
2

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

3

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.

4

we can consider id8 is in the text file (store from the API result) and validate against the display on the screen.