Parsing nested JSON data in a JSON schema in Logic Apps

Erika Salmon 0 Reputation points
2024-07-18T05:07:31.8133333+00:00

How can I parse nested JSON data in a JSON schema in Logic Apps? I am currently encountering an issue where all the data is being lumped under signInActivity instead of individual. Is there a way to parse it correctly? Here is the JSON and schema I am working with:

JSON:

"signInActivity": {
    "lastSignInDateTime": "2023-10-11T22:32:33Z",
    "lastSignInRequestId": "9d082b24-677e-4a09-b2cc-b81dac6b5400",
    "lastNonInteractiveSignInDateTime": "2024-07-16T21:31:33Z",
    "lastNonInteractiveSignInRequestId": "9249e6e7-6169-461f-b2cd-0ea703ac2200",
    "lastSuccessfulSignInDateTime": "2024-02-25T20:52:47Z",
    "lastSuccessfulSignInRequestId": "ef54f72b-cf52-4238-9837-2e814e9b2700"
}

Schema:

"signInActivity": {
    "type": "object",
    "properties": {
        "lastNonInteractiveSignInDateTime": {
            "type": [
                "string",
                "null"
            ]
        },
        "lastNonInteractiveSignInRequestId": {
            "type": [
                "string",
                "null"
            ]
        },
        "lastSignInDateTime": {
            "type": [
                "string",
                "null"
            ]
        },
        "lastSignInRequestId": {
            "type": [
                "string",
                "null"
            ]
        },
        "lastSuccessfulSignInDateTime": {
            "type": [
                "string",
                "null"
            ]
        },
        "lastSuccessfulSignInRequestId": {
            "type": [
                "string",
                "null"
            ]
        }
    }
}
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,981 questions
0 comments No comments
{count} votes