web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parse JSON validation ...
Power Automate
Unanswered

Parse JSON validation failed - error- "message": "Invalid type. Expected Object but got Array.",

(1) ShareShare
ReportReport
Posted on by 4
Hello Community, I need your help.
My flow has failed and I am not sure why. I have tried a lot of things with parse json but none seems to be working.
I created a JSON schema by using the output from execute SQL action in logic apps. but still I get the following error!
 
[
{
"message": "Invalid type. Expected Object but got Array.",
"lineNumber": 0,
"linePosition": 0,
"path": "",
"schemaId": "#",
"errorType": "type",
"childErrors": []
}
]
 
 
Attached are my JSON schemas
 
Categories:
I have the same question (0)
  • CU05081318-0 Profile Picture
    4 on at
    For context I have used the "Generate from sample" functionality to generate this schema

    Here is my JSON Schema - 

    {
        "type": "object",
        "properties": {
            "Primary EA": {
                "type": "string"
            },
            "Account Type": {
                "type": "string"
            },
            "Client Status": {
                "type": "string"
            },
            "Marketing Status": {
                "type": "string"
            },
            "Contact Name": {
                "type": "string"
            },
            "Account Name": {
                "type": "string"
            },
            "Main Industry": {
                "type": "string"
            },
            "Client Group": {
                "type": "string"
            },
            "Client Group Firm Priority": {
                "type": "string"
            },
            "Job Title": {
                "type": "string"
            },
            "Job Level": {
                "type": "string"
            },
            "Primary Email": {
                "type": "string"
            },
            "OwnerId": {
                "type": "string"
            },
            "Guardian": {
                "type": "string"
            },
            "IntroHive__Top_Connected_Colleague__c": {
                "type": "string"
            },
            "IntroHive__Last_Interaction__c": {
                "type": "string"
            },
            "CreatedById": {
                "type": "string"
            },
            "Created By": {
                "type": "string"
            },
            "Created From Introhive By": {
                "type": "string"
            },
            "Created Date": {
                "type": "string"
            },
            "Contact ID": {
                "type": "string"
            },
            "Language": {
                "type": "string"
            },
            "username": {
                "type": "string"
            },
            "EA Email ID": {
                "type": "string"
            }
        }
    }
  • lbendlin Profile Picture
    8,479 Super User 2025 Season 2 on at
    can you show the raw data of the failed step?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard