How can we compare

Help Studio
, ,
1

hi
i have a payload now what i want to do is to check whether it is in correct format or not how to check that

also i might need to check the value whether they are correct or not as i have that data any guess how to achieve that

2

@mint,

Some sample payload and desired format would be really helpful here to understand the problem.

3

@ashokkarale

“invoice_extraction”: {
“Invoice_headers”: {
“remit_to_code”: null,
“vendor_code”: null,
“original_vendor_code”: null,
“original_vendor_name”: null,
“original_remit_name”: null,
“original_remit_to_address1”: null,
“original_remit_to_address2”: null,
“original_remit_to_city”: null,
“original_remit_to_state”: null,

    },
    "invoice_table": {
        "line1": {
            "line_number": "2",
            "line_number - Confidence": 0,
            "description": "CTB33, 11X100 Kii SH BLD ZTHR 6/BX",
            "description - Confidence": 98,
            "quantity": "1",
            "quantity - Confidence": 97,
            "unit_of_measure": "BOX",
            "unit_of_measure - Confidence": 99,
            "unit_price": "138.00",
            "unit_price - Confidence": 99,
            "line_amount": "138.00",
            "line_amount - Confidence": 98,
            "item_po_number": "",
            "item_po_number - Confidence": 0,
            "part_number": "101219501",
            "part_number - Confidence": 99,
        
        },
        "line3": {
            "line_number": "3",
            "line_number - Confidence": 0,
            "description": "CFF03, 5x100 Kii Fios ADVFIX 6/BX",
            "description - Confidence": 98,
            "quantity": "6",
             "quantity - Confidence": 95,
            "unit_of_measure": "EA",
            "unit_of_measure - Confidence": 96,
            "unit_price": "15.00",
            "unit_price - Confidence": 98,
            "line_amount": "90.00",
            "line_amount - Confidence": 98,
            "item_po_number": "",
            "item_po_number - Confidence": 0,

        }
    }
}

}

for all key value pair i have values with me in excel

  1. i need to check that format remains this way always
  2. value i need to check that for required key value should match
4

can someone help on this …