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 returning n...
Power Automate
Unanswered

Parse JSON returning null value for boolean

(0) ShareShare
ReportReport
Posted on by

I have a workflow that is pulling information about a Microsoft Bookings event for the property "IsSMSNotificationsEnabled". I used the original output as a sample to generate the schema for this, which is below. It populates values for all properties except for this one, not sure what the issue is with this property or if I am simply mishandling the boolean value it is trying to extract. I have highlighted this property in both the Schema and the Sample data. As you can see IsSMSNotificationsEnabled is set to true, however, when I reference it in a variable it reports that it is null.

 

JSON Schema:

{
    "type""object",
    "properties": {
        "headers": {
            "type""object",
            "properties": {
                "Connection": {
                    "type""string"
                },
                "Expect": {
                    "type""string"
                },
                "Host": {
                    "type""string"
                },
                "X-BEServer": {
                    "type""string"
                },
                "X-BEBuildNumber": {
                    "type""string"
                },
                "webhook-id": {
                    "type""string"
                },
                "Content-Length": {
                    "type""string"
                },
                "Content-Type": {
                    "type""string"
                }
            }
        },
        "body": {
            "type""object",
            "properties": {
                "AdditionalInfo": {
                    "type""string"
                },
                "CustomQuestionAnswers": {
                    "type""array"
                },
                "CustomerEmail": {
                    "type""string"
                },
                "CustomerId": {
                    "type""string"
                },
                "CustomerLocation": {
                    "type""object",
                    "properties": {
                        "PhysicalAddress": {
                            "type""object",
                            "properties": {
                                "City": {
                                    "type""string"
                                },
                                "CountryOrRegion": {
                                    "type""string"
                                },
                                "PostalCode": {
                                    "type""string"
                                },
                                "State": {
                                    "type""string"
                                },
                                "Street": {
                                    "type""string"
                                }
                            }
                        }
                    }
                },
                "CustomerName": {
                    "type""string"
                },
                "CustomerNotes": {
                    "type""string"
                },
                "CustomerPhone": {
                    "type""string"
                },
                "CustomerTimeZone": {
                    "type""string"
                },
                "Customers": {
                    "type""array",
                    "items": {
                        "type""object",
                        "properties": {
                            "Id": {
                                "type""string"
                            },
                            "Notes": {
                                "type""string"
                            }
                        },
                        "required": [
                            "Id",
                            "Notes"
                        ]
                    }
                },
                "Duration": {
                    "type""integer"
                },
                "EndTime": {
                    "type""string"
                },
                "FilledAttendeesCount": {
                    "type""integer"
                },
                "Id": {
                    "type""string"
                },
                "IsSMSNotificationsEnabled": {
                    "type": "boolean"
                },
                "JoinWebURL": {
                    "type""string"
                },
                "MaxAttendeesCount": {
                    "type""integer"
                },
                "SelfServiceAppointmentId": {
                    "type""string"
                },
                "ServiceId": {
                    "type""string"
                },
                "ServiceName": {
                    "type""string"
                },
                "ServiceNotes": {
                    "type""string"
                },
                "StaffMembers": {
                    "type""array",
                    "items": {
                        "type""object",
                        "properties": {
                            "DisplayName": {
                                "type""string"
                            },
                            "EmailAddress": {
                                "type""string"
                            }
                        },
                        "required": [
                            "DisplayName",
                            "EmailAddress"
                        ]
                    }
                },
                "StartTime": {
                    "type""string"
                },
                "TrackingData": {
                    "type""string"
                }
            }
        }
    }
}
 
Sample Data, removed sensitive information:
{
"headers": {
"Connection": "Keep-Alive",
"Expect": "100-continue",
"Host": "prod-16.westus.logic.azure.com",
"X-BEServer": "MN2PR19MB3678",
"X-BEBuildNumber": "15.20.6002.33",
"webhook-id": "436e75ca-c4d1-4cfe-a792-a169c19ca9f8",
"Content-Length": "1298",
"Content-Type": "application/json; charset=utf-8"
},
"body": {
"AdditionalInfo": "",
"CustomQuestionAnswers": [],
"CustomerEmail": "someguy@fakeemailaddress.fake",
"CustomerId": "473bb0e1-564d-465b-8181-cb0c25041cef",
"CustomerLocation": {
"PhysicalAddress": {
"City": "",
"CountryOrRegion": "",
"PostalCode": "",
"State": "",
"Street": ""
}
},
"CustomerName": "Jane Doe",
"CustomerNotes": "This is a test",
"CustomerPhone": "15555555555",
"CustomerTimeZone": "",
"Customers": [
{
"Id": "473bb0e1-564d-465b-8181-cb0c25041cef",
"Notes": "-----Note added by customer on Monday, January 23, 2023 10:53 AM-----\r\ntest"
}
],
"Duration": 1800,
"EndTime": "1/25/2023 4:30:00 PM",
"FilledAttendeesCount": 1,
"Id": "FjsTEcaNGO9DgZ9rObhaS3EAAAKrxj9GAAAAAP5aY3oysxVIqWRLd/GPudoHADsTEcaNGO9DgZ9rObhaS3EAAAAAAQ0AADsTEcaNGO9DgZ9rObhaS3EAAAKsYBoAAE4=",
"IsSMSNotificationsEnabled": true,
"JoinWebURL": "",
"MaxAttendeesCount": 1,
"SelfServiceAppointmentId": "f49767da-f614-4cc9-93e8-68e9a1d1bc66",
"ServiceId": "7b36dc25-1755-432b-8c45-6015ed7276f3",
"ServiceName": "Check-in for Repair",
"ServiceNotes": "This is where you can add notes about this service that only you and your staff see.\r\n-----Note added by customer on Monday, January 23, 2023 10:53 AM-----\r\ntest\r\n",
"StaffMembers": [
{
"DisplayName": "Generic Body Shop",
"EmailAddress": "thebodyshop@genericdomain.com"
}
],
"StartTime": "1/25/2023 4:00:00 PM",
"TrackingData": ""
}
}
 
 
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 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard