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

Community site session details

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

Parse JSON - ValidationFailed: The schema validation failed

(0) ShareShare
ReportReport
Posted on by 12

Hi,

I have a flow which runs and works.  On occasion it fails when there is no data that a Get HTTP request API makes.

Is there a way to handle this error?

 

The error I see sometimes is: "Parse_get_alerts_api_response_in_JSON' failed"

  "status""Data is not present for the given query"
 
  {
    "message""Invalid type. Expected Array but got Object.",
 
I have tried modifying the schema to accept null values like this - but still it fails if there is no data - any suggestions please?
{
  "type""array",
  "items": {
    "type""object",
    "properties": {
      "severity": {
        "type": [
          "string",
          "null"
        ]
      },
      "siteName": {
        "type": [
          "string",
          "null"
        ]
      },
      "source": {
        "type": [
          "string",
          "null"
        ]
      },
      "eventType": {
        "type": [
          "string",
          "null"
        ]
      },
      "deviceId": {},
      "customerName": {
        "type": [
          "string",
          "null"
        ]
      },
      "createdAt": {
        "type": [
          "string",
          "null"
        ]
      },
      "customerId": {
        "type": [
          "string",
          "null"
        ]
      },
      "siteId": {
        "type": [
          "string",
          "null"
        ]
      },
      "eventName": {
        "type": [
          "string",
          "null"
        ]
      },
      "networkId": {
        "type": [
          "string",
          "null"
        ]
      },
      "id": {
        "type": [
          "string",
          "null"
        ]
      },
      "state": {
        "type": [
          "string",
          "null"
        ]
      },
      "userSeverity": {
        "type": [
          "string",
          "null"
        ]
      },
      "updatedAt": {
        "type": [
          "string",
          "null"
        ]
      },
      "eventDetails": {
        "type": [
          "string",
          "null"
        ]
      },
      "timeSinceEpoch": {
        "type": [
          "string",
          "null"
        ]
      }
    }
  }
}

 

Categories:
I have the same question (0)

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard