Hi @Sundeep_Malik
Thanks for looking again. Here is further clarification of what I am attempting.
I have filled out every field in the form. And to clarify, what I am attempting to do, is when someone fills out a new SurveyMonkey survey, the information will update with that new info. The other compose actions we tried just kept the info given in compose. My goal is to have the question and the answer connected and extracted individually to add to a SharePoint list and also to provide logic so that the response is sent to the correct person. My other goal is to create an automated response to the person who completed the survey if they provided their information.
Currently can’t extract dynamic values out of the SurveyMonkey connector. IDs are not useful because they change every time as well.
I need to be able to associate all answers with their question headings.
I want to be able to send an email that says something like this and also add to columns in SharePoint:
Here are the details of the complaint:
Nature of the complaint: Health, Property, Spill
Date observed: 1/30/2023
Time: 5:00 AM
Is the problem still ongoing? The problem is ongoing.
Date if no longer ongoing: N/A
Address or description of the location where the problem is occurring: 100 Main St
Lat/Long: 28.41738° N, -97.74118° E
5-digit zip code of location where problem is occurring. 79721
County where the problem is occurring: Bee County
Source of the problem: Hatfield
A brief description of the problem: I believe Hatfield dumped his waste on my property.
File added: https://www.surveymonkey.com/analyze/files/download/?survey_id=405235562&files=SXWswWIGBMlw_2FlPD0qwQuji2ohY3NdLp3Go4PBJ_2F2IdlGHQ_2BLsmSsgc2haXWuWtZWM3PTadBd8qD1_2FV2gPRy0RelJbbMtpRX9IPdjQRFv9dVB824CLNVtcj6ibvubDcnpnN9r_2Fxlg28viHYxFahcsvczAGflEHopdgelY5XDcQo_3D
Contact me with updates.
If you are providing information, what is your preferred way of contact? By email
Contact Information
Name: Bess New
Email Address bess.new@somedomain.com
Address: 100 Main St
City/Town: Beeville
ZIP/Postal Code: 78102
Here is the Body return from Parse JSON.
{
"id": "114232525361",
"recipient_id": "",
"collection_mode": "default",
"response_status": "completed",
"custom_value": "",
"first_name": "",
"last_name": "",
"email_address": "",
"ip_address": ",
"logic_path": {},
"metadata": {
"respondent": {
"user_agent": {
"type": "number",
"value": 4357112
},
"language": {
"type": "string",
"value": "en"
}
},
"contact": {}
},
"page_path": [],
"collector_id": "424458087",
"survey_id": "405235562",
"custom_variables": {},
"edit_url": "https://www.surveymonkey.com/r/?sm=5P1AY8iqtZoPTDvbzRnkbjPGE76pm_2B9juiGnbvxzlGxUuG_2BrafyuIZZTa0Gki3VB",
"analyze_url": "https://www.surveymonkey.com/analyze/browse/WFYeH6abPZzlaL_2B40vl7W3Nff_2FPZ6BGuxbparZPU4uI_3D?respondent_id=114232525361",
"total_time": 335,
"date_modified": "2023-01-30T16:53:59+00:00",
"date_created": "2023-01-30T16:48:24+00:00",
"href": "https://api.surveymonkey.net/v3/surveys/405235562/responses/114232525361",
"questions": [
{
"id": "110494036",
"answers": [
{
"choice_id": "838349127",
"simple_text": "Health"
},
{
"choice_id": "838349130",
"simple_text": "Property"
},
{
"choice_id": "838349131",
"simple_text": "Spill"
}
],
"family": "multiple_choice",
"subtype": "vertical",
"heading": "Nature of the complaint affecting you? (Select one or more)"
},
{
"id": "110494028",
"answers": [
{
"row_id": "838348844",
"tag_data": [],
"text": "01/30/2023",
"simple_text": "Enter Date Observed | 01/30/2023"
}
],
"family": "datetime",
"subtype": "date_only",
"heading": "Date observed:"
},
{
"id": "113885909",
"answers": [
{
"row_id": "861338938",
"tag_data": [],
"text": "5:00 AM",
"simple_text": "Time | 5:00 AM"
}
],
"family": "datetime",
"subtype": "time_only",
"heading": "Approximate Time Observed"
},
{
"id": "110494035",
"answers": [
{
"choice_id": "838349122",
"simple_text": "The problem is ongoing"
},
{
"other_id": "838349148",
"text": "N/A",
"simple_text": "Other | N/A"
}
],
"family": "single_choice",
"subtype": "vertical",
"heading": "Is the problem still ongoing?"
},
{
"id": "110494029",
"answers": [
{
"tag_data": [],
"text": "101 Main St",
"simple_text": "101 Main St"
}
],
"family": "open_ended",
"subtype": "single",
"heading": "Address or description of the location where the problem is occurring:"
},
{
"id": "110494039",
"answers": [
{
"tag_data": [],
"text": "28.41738° N, -97.74118° E",
"simple_text": "28.41738° N, -97.74118° E"
}
],
"family": "open_ended",
"subtype": "single",
"heading": "Lat/Long"
},
{
"id": "113888061",
"answers": [
{
"row_id": "861352582",
"tag_data": [],
"text": "78102",
"simple_text": "\n ZIP/Postal Code\n | 78102"
}
],
"family": "demographic",
"subtype": "international",
"heading": "Please provide a 5-digit zipcode of location where problem is occurring."
},
{
"id": "113946971",
"answers": [
{
"choice_id": "861734686",
"simple_text": "Bee County"
}
],
"family": "single_choice",
"subtype": "menu",
"heading": "County where the problem is occurring:"
},
{
"id": "110494030",
"answers": [
{
"tag_data": [],
"text": "Hatfield",
"simple_text": "Hatfield"
}
],
"family": "open_ended",
"subtype": "essay",
"heading": "Who or what you believe is the source of the problem: If this is already a regulated entity, you may wish to reference the facility or customer name or number here: <a href=\"https://www15.tceq.texas.gov/crpub/\" rel=\"nofollow\" target=\"_blank\">TCEQ Central Registry Query (texas.gov)</a>"
},
{
"id": "110494031",
"answers": [
{
"tag_data": [],
"text": "I believe Hatfield dumped his waste on my property.",
"simple_text": "I believe Hatfield dumped his waste on my property."
}
],
"family": "open_ended",
"subtype": "essay",
"heading": "A brief description of the problem:"
},
{
"id": "110494032",
"answers": [
{
"content_type": "image/jpeg",
"tag_data": [],
"text": "waste.jpg",
"download_url": "https://sm-fileupload.s3.amazonaws.com/82de57f9-bb31-4eae-b5b9-d315aee4f222.jpg?response-content-disposition=attachment%3B%20filename%2A%3DUTF-8%27%27waste.jpg&response-content-type=image%2Fjpeg&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=ASIAQMVQNXI65NPPEJPY%2F20230130%2Fus-west-1%2Fs3%2Faws4_request&X-Amz-Date=20230130T165440Z&X-Amz-Expires=42300&X-Amz-SignedHeaders=host&X-Amz-Security-Token=FwoGZXIvYXdzECoaDJciQ8fTztukw4cGKyLCAXqT4DbH7HFmnZSQdI2C%2BS4I7niQEyTASWUkFqAx47tjmjAPszqTMcQr7LnC3UgGomL3aKZXpZWKYAfor5qFkLCK2VJPE6DCKl%2FzisQTCIqHk1JHq1JNyQgF%2BeDfPNRkiBcGj19SqlMPwDrw%2FvxcXHV%2BrPhcxUzOq6acTou8b7WryqcFOxj7UUdlu3mzrzswQdDzNaqKguu1AmvkQ9sjXxHHc74HIxIE5ZZyjMM0By8uIJ8QLY9NFRNpYrhbPeFwm9z4KM%2Fs354GMi3rakoccdWAuTi4SkmQFeH5dYEiGOst16%2FMb22mgVB3YZtvSyDPzDLJuB0KOGw%3D&X-Amz-Signature=e1d8a62c205a80c1ef7e46899b7382e3dac575b165a77c8ca3257a0f0444c7b5",
"human_download_url": "https://www.surveymonkey.com/analyze/files/download/?survey_id=405235562&files=SXWswWIGBMlw_2FlPD0qwQuji2ohY3NdLp3Go4PBJ_2F2IdlGHQ_2BLsmSsgc2haXWuWtZWM3PTadBd8qD1_2FV2gPRy0RelJbbMtpRX9IPdjQRFv9dVB824CLNVtcj6ibvubDcnpnN9r_2Fxlg28viHYxFahcsvczAGflEHopdgelY5XDcQo_3D",
"simple_text": "waste.jpg"
}
],
"family": "open_ended",
"subtype": "single",
"heading": "Are you providing information or evidence? Information can help us more effectively investigate your concern. In order for us to use information or evidence you submit in an enforcement action, you must follow strict agency procedures for gathering and preserving the information or evidence you submit. Please review this information: <a href=\"https://www.tceq.texas.gov/compliance/complaints/handle_complaint.html\" rel=\"nofollow\" target=\"_blank\"> How the TCEQ Handles Environmental Complaints - Texas Commission on Environmental Quality - www.tceq.texas.gov </a><br>Upload with the <em>Choose File</em> button below."
},
{
"id": "113906757",
"answers": [
{
"choice_id": "861477383",
"simple_text": "Contact me with updates."
}
],
"family": "single_choice",
"subtype": "vertical",
"heading": "Would you like to provide information for us to contact you?"
},
{
"id": "113899475",
"answers": [
{
"choice_id": "861428502",
"simple_text": "By email"
}
],
"family": "single_choice",
"subtype": "vertical",
"heading": "If you are providing information, what is your preferred way of contact?"
},
{
"id": "113918663",
"answers": [
{
"row_id": "861554269",
"tag_data": [],
"text": "Bess New",
"simple_text": "\n Name\n | Bess New"
},
{
"row_id": "861554271",
"tag_data": [],
"text": "100 Main St",
"simple_text": "\n Address\n | 100 Main St"
},
{
"row_id": "861554273",
"tag_data": [],
"text": "Beeville",
"simple_text": "\n City/Town\n | Beeville"
},
{
"row_id": "861554275",
"tag_data": [],
"text": "78102",
"simple_text": "\n ZIP/Postal Code\n | 78102"
},
{
"row_id": "861554277",
"tag_data": [],
"text": "bess@someDomain.com",
"simple_text": "\n Email Address\n | bess@someDomain.com"
},
{
"row_id": "861554278",
"tag_data": [],
"text": "5555555555",
"simple_text": "\n Phone Number\n | 5555555555"
}
],
"family": "demographic",
"subtype": "international",
"heading": "Contact Information"
}
]
}
