Unanswered

Need help pulling a variable out of a Json Parse with Bookings

(0) Share

Report

Posted on by lsullivandmc

I'm trying to pull a value from the custom question using the When an Event is Created in Bookings trigger. I can see the information in the JSON Parse, but it keeps returning a null error. Any help would be very much appreciated.

Screenshot 2023-05-16 at 3.43.01 PM.png

Screenshot 2023-05-16 at 3.43.14 PM.png

Here's my schema.

{

"type": "object",

"properties": {

"Answers": {

"type": "array",

"items": {

"type": "object",

"properties": {

"Answer": {

"type": "string"

"Question": {

"type": "string"

"QuestionID": {

"type": "string"

}

Categories:

General topics

All responses (5)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@lsullivandmc ,

Can you provide a sample input as well?
lsullivandmc 4 on at

Like
a
(0)

Report
Copy link

Link copied!

{
"AdditionalInfo": "",
"CustomQuestionAnswers": [],
"CustomerEmail": "",
"CustomerId": "00000000-0000-0000-0000-000000000000",
"CustomerName": "",
"CustomerPhone": "",
"CustomerTimeZone": "",
"Customers": [
{
"Answers": [
{
"Answer": "student@webdmc.delmar.edu",
"Question": "Del Mar Email Address",
"QuestionID": "8d4b80f1-2be1-42b7-b00f-dc193af04979"
},
{
"Answer": "1234",
"Question": "Del Mar ID#",
"QuestionID": "64625110-a9eb-43ad-b671-369012c8cafb"
},
{
"Answer": "12/31/23",
"Question": "Test Date",
"QuestionID": "3a6e45f4-6fdf-4bf9-afa3-9537e0e907e4"
},
{
"Answer": "2pm",
"Question": "Test Time",
"QuestionID": "d024db29-91ba-4771-a197-91354e042899"
},
{
"Answer": "BCIS1301",
"Question": "Course & Course number (ex: HIST 1301)",
"QuestionID": "81d83998-44ec-438b-bcdc-7b29b20b21ea"
},
{
"Answer": "2pm",
"Question": "Class Start/End time",
"QuestionID": "48358de3-6ef2-46d5-84ea-52b8eea45c48"
},
{
"Answer": "Joel Example,
"Question": "Instructor Name",
"QuestionID": "64a53ad1-7cba-40ef-bca3-f1c45a298e2e"
},
{
"Answer": "instructor@delmar.edu",
"Question": "Instructor Email",
"QuestionID": "88ac99f1-c34e-4ac3-a22d-dc6c3bd34163"
},
{
"Answer": "No",
"AnswerOptions": [
"Yes",
"No"
],
"Question": "Will you need a computer to take your exam?",
"QuestionID": "325ae4ef-e6e0-4d9c-aebe-b8489128aba2",
"SelectedOptions": [
1
]
},
{
"Answer": "NA",
"Question": "Aside from extended test time -Do you need any of your approved testing accommodations (scribe, reader, magnifier)",
"QuestionID": "5099fdde-a988-4caa-bcf4-e86e75731d93"
}
],
"Email": "example@delmar.edu",
"Id": "5ef15a93-9d3c-4130-a79f-03c6ca163aae",
"Location": {
"DisplayName": "",
"PhysicalAddress": {
"City": "",
"CountryOrRegion": "",
"PostalCode": "",
"State": "",
"Street": ""
}
},
"Name": "Lisa Example",
"Phone": "3611111111",
"TimeZone": "Central Standard Time"
}
],
"Duration": 900,
"EndTime": "5/31/2023 1:15:00 PM",
"FilledAttendeesCount": 1,
"Id": "FjM04YLu5ShAoQAsMFPSwk0AAMde4QhGAAAAAG/YqpMMY79AvPLgqlspLpAHADM04YLu5ShAoQAsMFPSwk0AAAAAAQ0AADM04YLu5ShAoQAsMFPSwk0AAMdZIE0AAE4=",
"JoinWebURL": "",
"MaxAttendeesCount": 75,
"SelfServiceAppointmentId": "aa95ddf4-9ee5-44ef-8a3f-40",
"ServiceId": "4b8077bf-f3e0-493c-9871-0ba65ab7b7c0",
"ServiceName": "Heritage & Windward- DSO Testing Request (TEST ADMINSTERED AT TESTING CENTER)",
"StaffMembers": [
{
"DisplayName": "DSO Testing East",
"EmailAddress": "dso@delmar.edu",
"Id": "913231b6-df9f-41b1-87ae-1f9c238dc76e"
}
],
"StartTime": "5/31/2023 1:00:00 PM",
"TrackingData": ""
}
Chriddle 8,729 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
After fixing the bug in your JSON I got the value with

first(skip(first(outputs('Compose')['customers'])['Answers'],7))['Answer']

or

outputs('Compose')['customers'][0]['Answers'][7]['Answer']

Don't forget to replace "outputs('Compose')" with your action output.
lsullivandmc 4 on at

Like
a
(0)

Report
Copy link

Link copied!

May I ask, what bug you found in the JSON?
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Double quote is missed on line 41.
Check yourself: https://jsonlint.com/