JSON Parsing multiple arrays

Help Studio
, ,
1

Hi Folks,
I am relatively new to the UiPath Studio world. I am using a JSON file retrieved via an HTTP Request and getting the results through the studio fine, I am using JSON Deserialize Array as the JSON file contains multiple records, nested in arrays. Within each record there is another smaller array that contains 1 to many product records and I am getting an error “Object not set to instance of an object”, basically all other fields in the main array are being assigned correctly, but the “product_code” that exists within the “products_order” array are not being set at all.

Question is how do I assign variables to the contents of the “products_order” array within the main array?

[
{
“id”: “f3c4e99ae916acb2eee54c72a67e45f5”,
“document_id”: “e036aafff7b5a9913c7fb8ecd5c65a07”,
“remote_id”: “”,
“file_name”: “Attachment.pdf”,
“page_count”: 1,
“uploaded_at”: “2023-03-04T22:24:02+00:00”,
“processed_at”: “2023-03-10T18:11:53+00:00”,
“uploaded_at_utc”: “2023-03-04T22:24:02+00:00”,
“uploaded_at_user”: “2023-03-04T14:24:02+00:00”,
“processed_at_utc”: “2023-03-10T18:11:53+00:00”,
“processed_at_user”: “2023-03-10T10:11:53+00:00”,
“po_number”: “P371319”,
“po_date”: {
“match”: “01/03/23”,
“iso8601”: “2023-03-01”
},
“delivery_address”: “ANOTHER1\nGENERAL\n32 ANYSTREET\nSPRINGVALE INDUSTRIAL ESTATE\nL’DERRY\nBT12 0NA”,
“products_order”: [
{
“product_code”: “ABC1234”,
“qty”: “1”,
“product_desc”: “Angled Hinges”
}
],
“required_date”: {
“formatted”: “2023-01-03”
},
“delivery_postcode”: “BT12 0NA”,
“tag_doc_cust_name”: “Another1”
},
{
“id”: “93513ffd20ff3b791c26352035f718b0”,
“document_id”: “71e16e9d4ab34394b4af82845e88df50”,
“remote_id”: “”,
“file_name”: “Purchase Order Delivery Address(PUR001) - PO-123456.pdf”,
“media_link”:
“page_count”: 1,
“uploaded_at”: “2023-03-04T22:24:01+00:00”,
“processed_at”: “2023-03-10T18:11:52+00:00”,
“uploaded_at_utc”: “2023-03-04T22:24:01+00:00”,
“uploaded_at_user”: “2023-03-04T14:24:01+00:00”,
“processed_at_utc”: “2023-03-10T18:11:52+00:00”,
“processed_at_user”: “2023-03-10T10:11:52+00:00”,
“po_number”: “PO-123456”,
“po_date”: {
“match”: “24 February 2023”,
“iso8601”: “2023-02-24”
},
“delivery_address”: “ANOther2\nNorth Road\nLondon\nCo. London\nA92 B65\nUK”,
“products_order”: [
{
“product_code”: “ABC5432”,
“product_desc”: “BLACK DOOR 800x600”,
“qty”: “1.000”,
“price”: “180.00”
},
{
“product_code”: “ABC6548”,
“product_desc”: “Door 1230 x 600 Matt black”,
“qty”: “1.000”,
“price”: “150.00”
},
{
“product_code”: “HGTY6544”,
“product_desc”: “Green Door”,
“qty”: “1.000”,
“price”: “25.00”
},
{
“product_code”: “ABCD4356”,
“product_desc”: “Red Door”,
“qty”: “1.000”,
“price”: “100.00”
}
],
“required_date”: {
“formatted”: “24-02-23”
},
“delivery_postcode”: “A92 B65”,
“tag_doc_cust_name”: “Another2”,
“tag”: “”
}
]