Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,981 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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"
]
}
}
}