Parse JSON, Raw output is correct, next step Blank

(1) Share

Report

Posted on by JH-16071008-0

Good Day all,

I'm having issue with building a simple flow that Parses JSON generated by an AI Worker.

The Input is simple:

"Invoice Status": "New Invoice",

"Company Name": "hooperhere.co.uk",

"Sender Forename": "Jon",

"Sender Surname": "Hooper"

}

and the Parse JSON tool looks like it has worked:

As each of the fields is filled.

However when I access or use any of the parsed fields, they are empty.

The Schema I'm using in Parsed JSON is:

{
    "type": "object",
    "properties": {
        "body": {
            "type": "object",
            "properties": {
                "Invoice Status": {
                    "type": "string"
                },
                "Company Name": {
                    "type": "string"
                },
                "Sender Forename": {
                    "type": "string"
                },
                "Sender Surname": {
                    "type": "string"
                }
            }
        }
    }
}

Any Ideas?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Tomac 4,061 Moderator on at

Like (2)

Report
Copy link

Link copied!

Can you please show more of your flow? Specifically, the actions where you're trying to used the outputs of the Parse JSON action. It's likely a formatting error in the expression to use the data, but without seeing what you're using we won't be able to know for sure.

Was this reply helpful? Yes No
Verified answer

Riyaz_riz11 4,150 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi,

The Problem

Your actual JSON input is:

json

{ "Invoice Status": "New Invoice", "Company Name": "hooperhere.co.uk", "Sender Forename": "Jon", "Sender Surname": "Hooper" }

But your schema expects the data to be nested under a "body" property:

json

{ "type": "object", "properties": { "body": { // ← This wrapper doesn't exist in your actual data "type": "object", "properties": { "Invoice Status": {"type": "string"}, // ... etc } } } }

The Solution

Update your Parse JSON schema to match your actual data structure:

json

{ "type": "object", "properties": { "Invoice Status": { "type": "string" }, "Company Name": { "type": "string" }, "Sender Forename": { "type": "string" }, "Sender Surname": { "type": "string" } } }

How to Access the Fields

After fixing the schema, you'll be able to access the parsed fields using:

outputs('Parse_JSON')?['Invoice Status']

outputs('Parse_JSON')?['Company Name']

outputs('Parse_JSON')?['Sender Forename']

outputs('Parse_JSON')?['Sender Surname']

Alternative Solutions

If you prefer to keep your current schema structure, you would need to modify your AI Worker to output JSON in this format:

json

{ "body": { "Invoice Status": "New Invoice", "Company Name": "hooperhere.co.uk", "Sender Forename": "Jon", "Sender Surname": "Hooper" } }

Then you'd access fields like: outputs('Parse_JSON')?['body']?['Invoice Status']

The first solution (updating the schema) is recommended since it's simpler and matches your current data structure.

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No
Suggested answer

stampcoin 5,153 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@JH-16071008-0 Hi,

To access the fields, add one Compose, then the fields will appear.

for example, use the info to create a csv. see below:

Was this reply helpful? Yes No
JH-16071008-0 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you all for your help- restructuring the Schema worked like a dream- I trusted the Schema generator in PA too much :)

Was this reply helpful? Yes No