json outputs dissapear from flow

[Pstork1]

The problem is the JSON you are using.  All the keys are set to type.  That's why they are all named that. You need to change the key names to individual values in the JSON text before you Parse it.  Can you post an example of some of the JSON you are parsing?

[AJ71]

@Pstork1  firstly , thanks for responding, that has been a big hurdle getting help.

I have taught myself some thins but is taking days !

1. I have XML files coming into Dropbox.

2. Once I get content I am Replacing '<![CDATA[ & ending ]]>' from that XML. 

3. Compose to get the clean XML

4. I then use json(xml(outputs('Compose'))) to get the attached output.

I then Parse that json with the following schema to get Order Details  and Item Details  which are both arrays using the following schema.  I get really lost trying to simplify the schema as to which  {& } }, etc  to remove.

how do I attach a file here?  as  json and schema are quite long?

[AJ71]

message removed as irrelevant

[Pstork1]

How are you getting your Schema?  Are you using a sample of the output from a run to generate the schema?  or hand coding it?  The schema doesn't look correct to me.  The only references to arrays are in the required section.  There should be a couple arrays of objects from the way you describe the data.

[AJ71]

@Pstork1  did you get the json i sent , it is not showing in the thread?

[AJ71]

@Pstork1 If i use the payload fron the xml to json out put  get errors  as some orders have more than 1 Item. so if i use json from order that only has 1 items i get a fail for the items that have  more than one. and vice versa. 

[AJ71]

@Pstork1  not sure of location as i havent heard back from you in hours?  i am using json payload to create schema but the Parse json is return this schema every time?  i cant clear the type 

'

 "type": "object",

    "properties": {

        "type": {

            "type": "string"

        },

        "properties": {

            "type": "object",

            "properties": {

                "?xml": {

                    "type": "object",

                    "properties": {

                        "type": {

                            "type": "string"

                        },

                        "properties": {

                            "type": "object",

                            "properties": {

                                "@@@version": {

                                    "type": "object",

                                    "properties": {

                                        "type": {

                                            "type": "string"

                                        }

                                    }

                                },

                                "@@@encoding": {

                                    "type": "object",

                                    "properties": {

                                        "type": {

                                            "type": "string"'

thgis is sample json

' {
"Order_ID": "315",
"Order_Status": "Awaiting Payment",
"Order_Date": "23/11/2021",
"Customer_Email": "accounts@automotiveobsession.com.au",
"Customer_Phone": "07 4774 3375",
"Total_Quantity": "21",
"Total_Shipped": "0",
"Date_Shipped": "",
"Order_Notes": "",
"Customer_Message": "",
"Billing_First_Name": "Automotive Obsession",
"Billing_Last_Name": "829",
"Billing_Street_1": "890 Ingham Road",
"Billing_Street_2": "",
"Billing_Suburb__State__Zip": "Bohle QLD 4818",
"Product_Details": {
"item": [
{
"Product_Qty": "1",
"Product_SKU": "R33121001087",
"Product_Name": "Cargo Pants",
"Product_Variation_Details": "Size: 87 Regular",
"Product_Unit_Price": "34.50"
},
{
"Product_Qty": "5",
"Product_SKU": "R33121001092",
"Product_Name": "Cargo Pants",
"Product_Variation_Details": "Size: 92 Regular",
"Product_Unit_Price": "34.50"
},
{
"Product_Qty": "5",
"Product_SKU": "R33121001077",
"Product_Name": "Cargo Pants",
"Product_Variation_Details": "Size: 77 Regular",
"Product_Unit_Price": "34.50"
},
{
"Product_Qty": "5",
"Product_SKU": "RMOTO-L",
"Product_Name": "Poly Cotton Moto Shirt",
"Product_Variation_Details": "Size: L",
"Product_Unit_Price": "33.00"
},
{
"Product_Qty": "5",
"Product_SKU": "RMOTO-M",
"Product_Name": "Poly Cotton Moto Shirt",
"Product_Variation_Details": "Size: M",
"Product_Unit_Price": "33.00"
}
]
}
}
]
}
}'

I have also taken the json into jasonformatter.org and everything works fine, i get all the  Orders, all the items  and all the data is there .  something is happening in the parse 

[AJ71]

@Pstork1  the schema above is he schema that keeps getting set by the parse process?  when I change it to the previous step output (Below) it just keeps coming back the same as above.

[Pstork1]

The Sample JSON you sent is invalid.  It includes some extra braces and brackets at the end.  But after I clean it up I get the following for a schema.

{
    "type": "object",
    "properties": {
        "Order_ID": {
            "type": "string"
        },
        "Order_Status": {
            "type": "string"
        },
        "Order_Date": {
            "type": "string"
        },
        "Customer_Email": {
            "type": "string"
        },
        "Customer_Phone": {
            "type": "string"
        },
        "Total_Quantity": {
            "type": "string"
        },
        "Total_Shipped": {
            "type": "string"
        },
        "Date_Shipped": {
            "type": "string"
        },
        "Order_Notes": {
            "type": "string"
        },
        "Customer_Message": {
            "type": "string"
        },
        "Billing_First_Name": {
            "type": "string"
        },
        "Billing_Last_Name": {
            "type": "string"
        },
        "Billing_Street_1": {
            "type": "string"
        },
        "Billing_Street_2": {
            "type": "string"
        },
        "Billing_Suburb__State__Zip": {
            "type": "string"
        },
        "Product_Details": {
            "type": "object",
            "properties": {
                "item": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "Product_Qty": {
                                "type": "string"
                            },
                            "Product_SKU": {
                                "type": "string"
                            },
                            "Product_Name": {
                                "type": "string"
                            },
                            "Product_Variation_Details": {
                                "type": "string"
                            },
                            "Product_Unit_Price": {
                                "type": "string"
                            }
                        },
                        "required": [
                            "Product_Qty",
                            "Product_SKU",
                            "Product_Name",
                            "Product_Variation_Details",
                            "Product_Unit_Price"
                        ]
                    }
                }
            }
        }
    }
}

The Parse JSON action then shows the following results.

Something about the JSON you are using to create the schema is invalid.  Try using the schema I generated.

[AJ71]

@Pstork1  data parses but get  error  for everything?

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['Order_ID']' is of type 'Null'. The result must be a valid array.

outputs from parse

{
  "?xml": {
    "@version": "1.0",
    "@encoding": "UTF-8"
  },
  "orders": {
    "order": {
      "Order_ID": {
        "#cdata-section": "343"
      },
      "Order_Status": {
        "#cdata-section": "Awaiting Payment"
      },
      "Order_Date": {
        "#cdata-section": "26/11/2021"
      },
      "Customer_Email": {
        "#cdata-section": "admin@griffosautomotive.com.au"
      },
      "Customer_Phone": {
        "#cdata-section": "02 6552 3874"
      },
      "Total_Quantity": {
        "#cdata-section": "6"
      },
      "Total_Shipped": {
        "#cdata-section": "0"
      },
      "Date_Shipped": {
        "#cdata-section": ""
      },
      "Order_Notes": {
        "#cdata-section": ""
      },
      "Customer_Message": {
        "#cdata-section": "Can we please include these as part of the New RAS Member welcome pack?"
      },
      "Billing_First_Name": {
        "#cdata-section": "Griffo's Automotive"
      },
      "Billing_Last_Name": {
        "#cdata-section": "1692"
      },
      "Billing_Street_1": {
        "#cdata-section": "3 Beeton Parade"
      },
      "Billing_Street_2": {
        "#cdata-section": ""
      },
      "Billing_Suburb__State__Zip": {
        "#cdata-section": "Taree  NSW  2430"
      },
      "Product_Details": {
        "item": [
          {
            "Product_Qty": {
              "#cdata-section": "3"
            },
            "Product_SKU": {
              "#cdata-section": "RPOLO-2XL"
            },
            "Product_Name": {
              "#cdata-section": "Poly Cotton Polo Shirt"
            },
            "Product_Variation_Details": {
              "#cdata-section": "Size: 2XLarge, Extra Decoration: Business Logo Only"
            },
            "Product_Unit_Price": {
              "#cdata-section": "36.90"
            }
          },
          {
            "Product_Qty": {
              "#cdata-section": "1"
            },
            "Product_SKU": {
              "#cdata-section": "R2146-CHILI-10"
            },
            "Product_Name": {
              "#cdata-section": "Ladies Ezylin Blouse"
            },
            "Product_Variation_Details": {
              "#cdata-section": "Colour: Red, Style: Short Sleeve, Size: 10, Embroidery: Business Name only"
            },
            "Product_Unit_Price": {
              "#cdata-section": "74.75"
            }
          },
          {
            "Product_Qty": {
              "#cdata-section": "1"
            },
            "Product_SKU": {
              "#cdata-section": "R2145-CHILI-10"
            },
            "Product_Name": {
              "#cdata-section": "Ladies Ezylin Blouse"
            },
            "Product_Variation_Details": {
              "#cdata-section": "Colour: Red, Style: 3/4 Sleeve, Size: 10, Embroidery: Business Name only"
            },
            "Product_Unit_Price": {
              "#cdata-section": "74.75"
            }
          },
          {
            "Product_Qty": {
              "#cdata-section": "1"
            },
            "Product_SKU": {
              "#cdata-section": "R6V1CNBX10"
            },
            "Product_Name": {
              "#cdata-section": "Ladies Crew Neck Vest"
            },
            "Product_Variation_Details": {
              "#cdata-section": "Color: Black, Size: 10, Embroidery: Business Name only"
            },
            "Product_Unit_Price": {
              "#cdata-section": "45.00"
            }
          }
        ]
      }
    }
  }
}

[Pstork1 · Accepted solution]

You are doing your parse at the wrong level.  You are trying to get orderID, but in the JSON you just posted OrderID is a property of Order which is a property of Orders.  The sample you gave me was for the Order object.  But you are doing a Parse Json on the whole thing.  If it worked and you had the right schema Order ID would be 

@body('Parse_JSON')?['Orders']?['Order']?['Order_ID']

[AJ71]

@Pstork1  hank you again for your response and My apologies for that, learning as I go that accurate data posting is a benefit here.  I did pick that up  and I Practiced on it and was able to did adjust my schema to include the Orders. Order scenario to my schema, and it is parsing Ok  But  It does roll into another situation with dealing with Objects and Arrays in the inputs causing the parse to fail again. (have raised another discussion on this, parse-Json-Failing-due-to-Objects-and-Array-in-same-XML-call so do you think it best close this discussion as the answer about  the disappearing Outputs?

{
  "type": "object",
  "properties": {
    "orders": {
      "type": "object",
      "properties": {
        "order": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "Order_ID": {
                "type": "string"
              },
              "Order_Status": {
                "type": "string"
              },
              "Order_Date": {
                "type": "string"
              },
              "Customer_Email": {
                "type": "string"
              },
              "Customer_Phone": {
                "type": "string"
              },
              "Total_Quantity": {
                "type": "string"
              },
              "Total_Shipped": {
                "type": "string"
              },
              "Date_Shipped": {
                "type": "string"
              },
              "Order_Notes": {
                "type": "string"
              },
              "Customer_Message": {
                "type": "string"
              },
              "Billing_Last_Name": {
                "type": "string"
              },
              "Billing_Street_1": {
                "type": "string"
              },
              "Billing_Street_2": {
                "type": "string"
              },
              "Billing_Suburb__State__Zip": {
                "type": "string"
              },
              "Product_Details": {
                "type": "object",
                "properties": {
                  "item": {
                    "type": "object",
                    "properties": {
                      "Product_Qty": {
                        "type": "string"
                      },
                      "Product_SKU": {
                        "type": "string"
                      },
                      "Product_Name": {
                        "type": "string"
                      },
                      "Product_Variation_Details": {
                        "type": "string"
                      },
                      "Product_Unit_Price": {
                        "type": "string"
                      }
                    }
                  }
                }
              }
            },
            "required": [
              "Order_ID",
              "Order_Status",
              "Order_Date",
              "Customer_Email",
              "Customer_Phone",
              "Total_Quantity",
              "Total_Shipped",
              "Date_Shipped",
              "Order_Notes",
              "Customer_Message",
              "Billing_Last_Name",
              "Billing_Street_1",
              "Billing_Street_2",
              "Billing_Suburb__State__Zip",
              "Product_Details"
            ]
          }
        }
      }
    }
  }
}