Power Automate

Answered

Help with Action 'Parse_JSON' failed error

(0) Share

Report

Posted on by cswanson22

My flow is failing at the Switch.

The schema is below

{

"type": "array",

"items": {

"type": "object",

"properties": {

"ItemInternalId": {

"type": "string"

"Billing Account Number": {

"type": "string"

"Product Family": {

"type": "string"

"Tax_x003a_ Federal": {

"type": "string"

"Tax_x003a_ State": {

"type": "string"

"Tax_x003a_ City": {

"type": "string"

"Tax_x003a_ County": {

"type": "string"

"Tax_x003a_ Other": {

"type": "string"

"Tax_x003a_ VAT": {

"type": "string"

"@odata.etag": {

"type": "string"

}

"required": [

"@odata.etag",

"ItemInternalId",

"Billing Account Number",

"Product Family",

"Tax_x003a_ Federal",

"Tax_x003a_ State",

"Tax_x003a_ City",

"Tax_x003a_ County",

"Tax_x003a_ Other",

"Tax_x003a_ VAT"

]

}

And the error - which is listed 3x's.

[
{
"message": "Required properties are missing from object: Tax_x003a_ Federal, Tax_x003a_ State, Tax_x003a_ City, Tax_x003a_ County, Tax_x003a_ Other, Tax_x003a_ VAT.",
"lineNumber": 0,
"linePosition": 0,
"path": "[0]",
"value": [
"Tax_x003a_ Federal",
"Tax_x003a_ State",
"Tax_x003a_ City",
"Tax_x003a_ County",
"Tax_x003a_ Other",
"Tax_x003a_ VAT"
],
"schemaId": "#/items",
"errorType": "required",
"childErrors": []
},

Since the error shows the required field three times, do I also need to add required objects 3'xs?

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (1)

AWorley 414 Super User 2024 Season 1 on at

Like (0)

Report

So the error " An action failed. No dependent actions succeeded" is a result of the Switch's argument execute but failing in the case block of the switch.

Are you able to provide a screenshot of the Lumen case block in your switch? Or did it go to "Default"?

Was this reply helpful? Yes No
cswanson22 49 on at

Like (0)

Report

variables("Vendor_Name")

Was this reply helpful? Yes No
cswanson22 49 on at

Like (0)

Report

The Apply action

Was this reply helpful? Yes No
AWorley 414 Super User 2024 Season 1 on at

Like (0)

Report

Okay, the case argument for Vendor name should be Lumen in your example.

If you tunnel to the ran flow and find that case block in the switch there should be an errored out action that you need to look at. If there is no error in the case blocks then it is likely a string mismatch. I would validate the output that you get when you assign the vendor variable.

Was this reply helpful? Yes No
cswanson22 49 on at

Like (0)

Report

The output errors
[
{
"message": "Required properties are missing from object: Tax_x003a_ Federal, Tax_x003a_ State, Tax_x003a_ City, Tax_x003a_ County, Tax_x003a_ Other, Tax_x003a_ VAT.",
"lineNumber": 0,
"linePosition": 0,
"path": "[0]",
"value": [
"Tax_x003a_ Federal",
"Tax_x003a_ State",
"Tax_x003a_ City",
"Tax_x003a_ County",
"Tax_x003a_ Other",
"Tax_x003a_ VAT"
],
"schemaId": "#/items",
"errorType": "required",
"childErrors": []
},

Was this reply helpful? Yes No
AWorley 414 Super User 2024 Season 1 on at

Like (0)

Report

In your schema change the "type": "object", to "type": "Array".

Was this reply helpful? Yes No
cswanson22 49 on at

Like (0)

Report

Do I keep the second "type": "object"?

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "@@odata.etag": {
                "type": "string"

Was this reply helpful? Yes No
AWorley 414 Super User 2024 Season 1 on at

Like (0)

Report

To test your JSON schema I reccommend you pop your JSON and Schema into Newtonsofts' validator. https://www.jsonschemavalidator.net/

{
"type": "object",
"items": {
"type": "array",
"properties": {
"ItemInternalId": {
"type": "string"
},
"Billing Account Number": {
"type": "string"
},
"Product Family": {
"type": "string"
},
"Tax_x003a_ Federal": {
"type": "string"
},
"Tax_x003a_ State": {
"type": "string"
},
"Tax_x003a_ City": {
"type": "string"
},
"Tax_x003a_ County": {
"type": "string"
},
"Tax_x003a_ Other": {
"type": "string"
},
"Tax_x003a_ VAT": {
"type": "string"
},
"@odata.etag": {
"type": "string"
}
},
"required": [
"@odata.etag",
"ItemInternalId",
"Billing Account Number",
"Product Family",
"Tax_x003a_ Federal",
"Tax_x003a_ State",
"Tax_x003a_ City",
"Tax_x003a_ County",
"Tax_x003a_ Other",
"Tax_x003a_ VAT"
]
}
}

Was this reply helpful? Yes No
cswanson22 49 on at

Like (0)

Report

I get the following error now:

[
{
"message": "Invalid type. Expected Object but got Array.",
"lineNumber": 0,
"linePosition": 0,
"path": "",
"schemaId": "#",
"errorType": "type",
"childErrors": []
},

Was this reply helpful? Yes No
AWorley 414 Super User 2024 Season 1 on at

Like (0)

Report

Okay. I used your original Schema and JSON input.

Just swap the two types and try again.

Was this reply helpful? Yes No