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

**URL:** <https://forums.eggplantsoftware.com/t/how-to-validate-the-api-json-result-with-screen-table-output/8692>\
**Category:** Uncategorized\
**Created:** [January 8, 2024, 6:59am UTC](https://forums.eggplantsoftware.com/t/how-to-validate-the-api-json-result-with-screen-table-output/8692 "2024-01-08T06:59:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thanagaraj](https://forums.eggplantsoftware.com/letter_avatar_proxy/v4/letter/t/e495f1/32.png) [@Thanagaraj](https://forums.eggplantsoftware.com/u/Thanagaraj)\
**Post date:** [January 8, 2024, 6:59am UTC](https://forums.eggplantsoftware.com/t/how-to-validate-the-api-json-result-with-screen-table-output/8692/1 "2024-01-08T06:59:21Z")

</div>

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 |

---

<div class="post-metadata">

**Author:** ![DaveHester](https://forums.eggplantsoftware.com/user_avatar/forums.eggplantsoftware.com/davehester/32/104_2.png) [@DaveHester](https://forums.eggplantsoftware.com/u/DaveHester)\
**Post date:** [January 8, 2024, 4:25pm UTC](https://forums.eggplantsoftware.com/t/how-to-validate-the-api-json-result-with-screen-table-output/8692/2 "2024-01-08T16:25:16Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Thanagaraj](https://forums.eggplantsoftware.com/letter_avatar_proxy/v4/letter/t/e495f1/32.png) [@Thanagaraj](https://forums.eggplantsoftware.com/u/Thanagaraj)\
**Post date:** [January 9, 2024, 5:51am UTC](https://forums.eggplantsoftware.com/t/how-to-validate-the-api-json-result-with-screen-table-output/8692/3 "2024-01-09T05:51:34Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Thanagaraj](https://forums.eggplantsoftware.com/letter_avatar_proxy/v4/letter/t/e495f1/32.png) [@Thanagaraj](https://forums.eggplantsoftware.com/u/Thanagaraj)\
**Post date:** [April 10, 2024, 7:51am UTC](https://forums.eggplantsoftware.com/t/how-to-validate-the-api-json-result-with-screen-table-output/8692/4 "2024-04-10T07:51:18Z")

</div>

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