Logic App parse keeps failing

Question

With reference to my previous question -

https://learn.microsoft.com/en-us/answers/questions/2260999/set-default-value-for-handling-null-values-in-entr

I keep getting a schema validation failure on the output from the JavaScript -

 

I've downloaded the output and used this to create the schema but it still fails -

Does it need to be re-parsed, and if so, how do I create the correct schema for a large data output?

@RithwikBojja

Answer 1

Hi @Michael Fleet ,

Does it need to be re-parsed, and if so, how do I create the correct schema for a large data output?

It needs to be re-parsed, if you want to use the Json properties/key value pair. Else no need to parse it.

Below Json schema works for me:

{

  "type": "array",

  "items": {

    "type": "object",

    "properties": {

      "userPrincipalName": {

        "type": "string"

      },

      "id": {

        "type": "string"

      },

      "signInActivity": {

        "type": "object",

        "properties": {

          "lastSignInDateTime": {

            "type": "string",

            "format": "date-time"

          },

          "lastSignInRequestId": {

            "type": ["string", "null"]

          },

          "lastNonInteractiveSignInDateTime": {

            "type": ["string", "null"],

            "format": "date-time"

          },

          "lastNonInteractiveSignInRequestId": {

            "type": ["string", "null"]

          },

          "lastSuccessfulSignInDateTime": {

            "type": ["string", "null"],

            "format": "date-time"

          },

          "lastSuccessfulSignInRequestId": {

            "type": ["string", "null"]

          }

        },

        "required": [

          "lastSignInDateTime"

        ]

      }

    },

    "required": [

      "userPrincipalName",

      "id",

      "signInActivity"

    ]

  }

}

Output:

---

If this answer was helpful, please click "Accept the answer" and mark Yes, as this can help other community members.

If you have any other questions or are still experiencing issues, feel free to ask in the "comments" section, and I'd be happy to help.