Hi!
I’m trying to retrieve the result “Prestataire d’activités (coach sportif, prof de yoga…)” from an array. I’ve tried using the get/map functions, but I haven’t been successful…
Can anyone help me?
Thank you!
Hi again,
I have the same issue to extract that data :
This works well :
This don’t :
Thank you for your help !
Hi @Angelo_Blot
If you can share the output bundles, we can assist you further.
How to Share Input/Output bundles
To obtain the input and output bundles for each module:
- Run the scenario or retrieve it from the History tab.
- For each module, click the white speech bubble located at the top-right corner.
- Select “Download input/output bundles” from the dropdown menu.
This will allow you to download the necessary data for further analysis and sharing.
Method 1: Attach a Text File
- Copy the output data.
- Paste the data into a text file.
- Attach the text file to your ticket.
Method 2: Direct Sharing
- Use the direct sharing option available in the reply section. Please refer to the image below for guidance.
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
[
{
"eventId": "66dc24e10f6dfd708e460e09",
"eventType": "surveyFormAnswer",
"createdAt": "2024-09-07T10:03:13.775Z",
"data": [
{
"id": "66dc24cc78cb22965418d372",
"createdAt": "2024-09-07T10:02:52.846Z",
"kind": "SurveyAnswerChoice",
"question": {
"id": "668befdda74955b0fd400d0b",
"condition": false,
"content": [
{
"value": "Which profile are you?",
"language": "EN",
"_id": "66a4ad001d906559378f846e"
},
{
"value": "Quel profil es-tu ?",
"language": "FR",
"_id": "66a4ad001d906559378f846f"
}
],
"desc": [
{
"_id": "668befdda74955b0fd400d0f",
"value": "",
"language": "EN"
}
],
"options": {
"mandatory": false,
"multiple": false,
"otherChoice": true,
"shuffle": false
},
"position": 0,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionChoice",
"choices": [
{
"id": "668befdda74955b0fd400d17",
"position": 0,
"otherChoice": false,
"content": [
{
"value": "Influencer",
"language": "EN",
"_id": "66a4ad031d906559378f84aa"
},
{
"value": "Influenceur",
"language": "FR",
"_id": "66a4ad031d906559378f84ab"
}
]
},
{
"id": "668befdda74955b0fd400d24",
"position": 1,
"otherChoice": false,
"content": [
{
"value": "Activity provider (sports coach, yoga teacher...)",
"language": "EN",
"_id": "66a4ad0e1d906559378f852e"
},
{
"value": "Prestataire d'activités (coach sportif, prof de yoga...)",
"language": "FR",
"_id": "66a4ad0e1d906559378f852f"
}
]
},
{
"id": "668beff5da3d1ed856a4ac96",
"position": 2,
"otherChoice": false,
"content": [
{
"value": "Agent de voyage indépendant",
"language": "FR",
"_id": "66a4ad172dec9e3ede427b68"
},
{
"value": "Independent travel agent",
"language": "EN",
"_id": "66a4ad172dec9e3ede427b69"
}
]
}
]
},
"choices": [
{
"id": "668befdda74955b0fd400d24",
"position": 1,
"otherChoice": false,
"content": [
{
"value": "Activity provider (sports coach, yoga teacher...)",
"language": "EN",
"_id": "66a4ad0e1d906559378f852e"
},
{
"value": "Prestataire d'activités (coach sportif, prof de yoga...)",
"language": "FR",
"_id": "66a4ad0e1d906559378f852f"
}
]
}
],
"author": {
"id": "66dc24c90f6dfd708e460ceb",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #156",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-07T10:02:53.155Z",
"createdAt": "2024-09-07T10:02:49.825Z",
"updatedAt": "2024-09-07T10:03:13.752Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-07T10:03:13.752Z"
}
},
{
"id": "66dc24d650ce2cb9733dbc47",
"createdAt": "2024-09-07T10:03:02.415Z",
"content": "KJKJKJH",
"kind": "SurveyAnswerText",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66dc24c90f6dfd708e460ceb",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #156",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-07T10:02:53.155Z",
"createdAt": "2024-09-07T10:02:49.825Z",
"updatedAt": "2024-09-07T10:03:13.752Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-07T10:03:13.752Z"
}
},
{
"id": "66dc24d650ce2cb9733dbc20",
"createdAt": "2024-09-07T10:03:02.167Z",
"content": "https://test.com",
"kind": "SurveyAnswerText",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66dc24c90f6dfd708e460ceb",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #156",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-07T10:02:53.155Z",
"createdAt": "2024-09-07T10:02:49.825Z",
"updatedAt": "2024-09-07T10:03:13.752Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-07T10:03:13.752Z"
}
},
{
"id": "66dc24d550ce2cb9733dbbf9",
"createdAt": "2024-09-07T10:03:01.944Z",
"content": "https://www.instagram.com/ang3lblot/",
"kind": "SurveyAnswerText",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66dc24c90f6dfd708e460ceb",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #156",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-07T10:02:53.155Z",
"createdAt": "2024-09-07T10:02:49.825Z",
"updatedAt": "2024-09-07T10:03:13.752Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-07T10:03:13.752Z"
}
},
{
"id": "66dc24d550ce2cb9733dbbd2",
"createdAt": "2024-09-07T10:03:01.717Z",
"content": "angelo.blot@traveltribe.fr",
"kind": "SurveyAnswerText",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66dc24c90f6dfd708e460ceb",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #156",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-07T10:02:53.155Z",
"createdAt": "2024-09-07T10:02:49.825Z",
"updatedAt": "2024-09-07T10:03:13.752Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-07T10:03:13.752Z"
}
},
{
"id": "66dc24d550ce2cb9733dbbab",
"createdAt": "2024-09-07T10:03:01.454Z",
"content": "Angelo Blot",
"kind": "SurveyAnswerText",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66dc24c90f6dfd708e460ceb",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #156",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-07T10:02:53.155Z",
"createdAt": "2024-09-07T10:02:49.825Z",
"updatedAt": "2024-09-07T10:03:13.752Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-07T10:03:13.752Z"
}
},
{
"id": "66dc24d550ce2cb9733dbb82",
"createdAt": "2024-09-07T10:03:01.200Z",
"kind": "SurveyAnswerDefault",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66dc24c90f6dfd708e460ceb",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #156",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-07T10:02:53.155Z",
"createdAt": "2024-09-07T10:02:49.825Z",
"updatedAt": "2024-09-07T10:03:13.752Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-07T10:03:13.752Z"
}
},
{
"id": "66dc24e10f6dfd708e460dc2",
"createdAt": "2024-09-07T10:03:13.722Z",
"kind": "SurveyAnswerDefault",
"question": {
"id": "66a8a3f51d90655937ad6a1e",
"condition": false,
"content": [
{
"value": "Your registration has been successfully completed!",
"language": "EN",
"_id": "66a8a4091d90655937ad6c72"
},
{
"value": "Votre inscription a bien été prise en compte !",
"language": "FR",
"_id": "66a8a4091d90655937ad6c73"
}
],
"desc": [
{
"value": "Feel free to share around you!",
"language": "EN",
"_id": "66a8a4113374cc2d4a4b0a0d"
},
{
"value": "N'hésite pas à partager autour de toi !",
"language": "FR",
"_id": "66a8a4113374cc2d4a4b0a0e"
}
],
"options": {
"otherField": false
},
"button": {
"show": false,
"label": [
{
"_id": "66a8a3f51d90655937ad6a22",
"value": "",
"language": "EN"
}
]
},
"color": "",
"position": 2,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionMessage"
},
"author": {
"id": "66dc24c90f6dfd708e460ceb",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #156",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-07T10:02:53.155Z",
"createdAt": "2024-09-07T10:02:49.825Z",
"updatedAt": "2024-09-07T10:03:13.752Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-07T10:03:13.752Z"
}
}
]
}
]
remove double quotes from “Commentaires”
1 Like
if you are getting the data in the same format in every case then
you can do this
which will give this result
and using the value 1 in get function would give you the English value
1 Like
Hi @abhilash_naik,
Thank you for your answer, I’ve tried to remove the quotes, but still the same :
Here the data :
[
{
"cancel_url": "https://calendly.com/cancellations/c12fdb30-efe5-46f8-ac83-f19226a17fd5",
"created_at": "2024-09-11T08:47:41.985Z",
"email": "test@test",
"event": "https://api.calendly.com/scheduled_events/1de5b885-4a8f-400e-bea9-e306fb5bb468",
"first_name": "test",
"invitee_scheduled_by": "https://api.calendly.com/users/HCBCGCNTC365Y732",
"last_name": "test",
"name": "test",
"new_invitee": null,
"no_show": null,
"old_invitee": null,
"payment": null,
"questions_and_answers": [
{
"answer": "D000",
"position": 0,
"question": "Numéro d'appartement"
},
{
"answer": "+33 0 00 00 00 00",
"position": 1,
"question": "Numéro de téléphone"
},
{
"answer": "recylZLsvPSMQSIdQ",
"position": 2,
"question": "ID Résident (ne pas modifier)"
},
{
"answer": "recViws5gcNclys4U",
"position": 3,
"question": "ID Logement (ne pas modifier)"
},
{
"answer": "Je valide",
"position": 4,
"question": "Je confirme avoir une connexion internet ainsi que l'interrupteur arrivée/départ (cryptogramme d'une maison avec des flèches) le jour de la mise en service "
},
{
"answer": "RDV validé pour 16h30.",
"position": 5,
"question": "Commentaires"
}
],
"reconfirmation": null,
"reschedule_url": "https://calendly.com/reschedulings/c12fdb30-efe5-46f8-ac83-f19226a17fd5",
"rescheduled": false,
"routing_form_submission": null,
"scheduled_event": {
"created_at": "2024-09-10T16:32:37.685Z",
"end_time": "2024-09-18T17:00:00.000Z",
"event_guests": [],
"event_memberships": [
{
"user": "https://api.calendly.com/users/CABGGQJDMIWFNDPS",
"user_email": "test@test.com",
"user_name": "test@test"
}
],
"event_type": "https://api.calendly.com/event_types/2bc4cec5-17e0-424b-917d-be90e295857b",
"invitees_counter": {
"total": 2,
"active": 2,
"limit": 2
},
"location": {
"location": "Chez vous !",
"type": "custom"
},
"meeting_notes_html": null,
"meeting_notes_plain": null,
"name": "Mise en service de votre logement connecté (Ora)",
"start_time": "2024-09-18T12:00:00.000Z",
"status": "active",
"updated_at": "2024-09-10T16:32:39.823Z",
"uri": "https://api.calendly.com/scheduled_events/1de5b885-4a8f-400e-bea9-e306fb5bb468"
},
"scheduling_method": null,
"status": "active",
"text_reminder_number": "+33 0 00 00 00 00",
"timezone": "Europe/Berlin",
"tracking": {
"utm_campaign": null,
"utm_source": null,
"utm_medium": null,
"utm_content": null,
"utm_term": null,
"salesforce_uuid": null
},
"updated_at": "2024-09-11T08:47:41.985Z",
"uri": "https://api.calendly.com/scheduled_events/1de5b885-4a8f-400e-bea9-e306fb5bb468/invitees/c12fdb30-efe5-46f8-ac83-f19226a17fd5"
}
]
Unfortunately, the data changes…The only thing that doesn’t change is the ID of the question
question is in lowercase it should match the key in the JSON
and you can get the answers by just doing map function
would give this
3 Likes
Thank you @abhilash_naik, it worked !
I still don’t manage to make the other works 
[
{
"eventId": "66e1d74c78cb22965450c8a9",
"eventType": "surveyFormAnswer",
"createdAt": "2024-09-11T17:45:48.075Z",
"data": [
{
"id": "66e1d73650ce2cb97375a564",
"createdAt": "2024-09-11T17:45:26.290Z",
"kind": "SurveyAnswerChoice",
"question": {
"id": "668befdda74955b0fd400d0b",
"condition": false,
"content": [
{
"value": "Which profile are you?",
"language": "EN",
"_id": "66a4ad001d906559378f846e"
},
{
"value": "Quel profil es-tu ?",
"language": "FR",
"_id": "66a4ad001d906559378f846f"
}
],
"desc": [
{
"_id": "668befdda74955b0fd400d0f",
"value": "",
"language": "EN"
}
],
"options": {
"mandatory": false,
"multiple": false,
"otherChoice": true,
"shuffle": false
},
"position": 0,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionChoice",
"choices": [
{
"id": "668befdda74955b0fd400d17",
"position": 0,
"otherChoice": false,
"content": [
{
"value": "Influencer",
"language": "EN",
"_id": "66a4ad031d906559378f84aa"
},
{
"value": "Influenceur",
"language": "FR",
"_id": "66a4ad031d906559378f84ab"
}
]
},
{
"id": "668befdda74955b0fd400d24",
"position": 1,
"otherChoice": false,
"content": [
{
"value": "Activity provider (sports coach, yoga teacher...)",
"language": "EN",
"_id": "66a4ad0e1d906559378f852e"
},
{
"value": "Prestataire d'activités (coach sportif, prof de yoga...)",
"language": "FR",
"_id": "66a4ad0e1d906559378f852f"
}
]
},
{
"id": "668beff5da3d1ed856a4ac96",
"position": 2,
"otherChoice": false,
"content": [
{
"value": "Agent de voyage indépendant",
"language": "FR",
"_id": "66a4ad172dec9e3ede427b68"
},
{
"value": "Independent travel agent",
"language": "EN",
"_id": "66a4ad172dec9e3ede427b69"
}
]
}
]
},
"choices": [
{
"id": "668befdda74955b0fd400d24",
"position": 1,
"otherChoice": false,
"content": [
{
"value": "Activity provider (sports coach, yoga teacher...)",
"language": "EN",
"_id": "66a4ad0e1d906559378f852e"
},
{
"value": "Prestataire d'activités (coach sportif, prof de yoga...)",
"language": "FR",
"_id": "66a4ad0e1d906559378f852f"
}
]
}
],
"author": {
"id": "66e1d73378cb22965450c749",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #158",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-11T17:45:26.628Z",
"createdAt": "2024-09-11T17:45:23.592Z",
"updatedAt": "2024-09-11T17:45:48.046Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-11T17:45:48.046Z"
}
},
{
"id": "66e1d7460f6dfd708e7e29f7",
"createdAt": "2024-09-11T17:45:42.286Z",
"content": "KJKJKJH",
"kind": "SurveyAnswerText",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66e1d73378cb22965450c749",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #158",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-11T17:45:26.628Z",
"createdAt": "2024-09-11T17:45:23.592Z",
"updatedAt": "2024-09-11T17:45:48.046Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-11T17:45:48.046Z"
}
},
{
"id": "66e1d7460f6dfd708e7e29d0",
"createdAt": "2024-09-11T17:45:42.052Z",
"content": "https://test.com",
"kind": "SurveyAnswerText",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66e1d73378cb22965450c749",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #158",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-11T17:45:26.628Z",
"createdAt": "2024-09-11T17:45:23.592Z",
"updatedAt": "2024-09-11T17:45:48.046Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-11T17:45:48.046Z"
}
},
{
"id": "66e1d7450f6dfd708e7e29a9",
"createdAt": "2024-09-11T17:45:41.822Z",
"content": "https://www.instagram.com/test[Processing: Capture d’écran 2024-09-11 à 19.51.28.png…]()
/",
"kind": "SurveyAnswerText",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66e1d73378cb22965450c749",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #158",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-11T17:45:26.628Z",
"createdAt": "2024-09-11T17:45:23.592Z",
"updatedAt": "2024-09-11T17:45:48.046Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-11T17:45:48.046Z"
}
},
{
"id": "66e1d7450f6dfd708e7e2982",
"createdAt": "2024-09-11T17:45:41.559Z",
"content": "test.test@test.fr",
"kind": "SurveyAnswerText",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66e1d73378cb22965450c749",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #158",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-11T17:45:26.628Z",
"createdAt": "2024-09-11T17:45:23.592Z",
"updatedAt": "2024-09-11T17:45:48.046Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-11T17:45:48.046Z"
}
},
{
"id": "66e1d7450f6dfd708e7e295b",
"createdAt": "2024-09-11T17:45:41.308Z",
"content": "Angelo Blot",
"kind": "SurveyAnswerText",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66e1d73378cb22965450c749",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #158",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-11T17:45:26.628Z",
"createdAt": "2024-09-11T17:45:23.592Z",
"updatedAt": "2024-09-11T17:45:48.046Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-11T17:45:48.046Z"
}
},
{
"id": "66e1d7450f6dfd708e7e2932",
"createdAt": "2024-09-11T17:45:41.016Z",
"kind": "SurveyAnswerDefault",
"question": {
"id": "668bef6f3a40cc4751dade26",
"condition": false,
"content": [
{
"value": "Tell us about you",
"language": "EN",
"_id": "66a4ab583374cc2d4a2cfb25"
},
{
"value": "Parle-nous de toi",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb26"
},
{
"value": "Parlez-nous de vous",
"language": "FR",
"_id": "66a4ab583374cc2d4a2cfb27"
}
],
"desc": [
{
"value": "",
"language": "EN",
"_id": "64cbb5019ed46a0013ddca90"
},
{
"value": "",
"language": "FR",
"_id": "668bef763a40cc4751dadecf"
}
],
"options": {
"mandatory": false
},
"position": 1,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionContactInfo"
},
"author": {
"id": "66e1d73378cb22965450c749",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #158",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-11T17:45:26.628Z",
"createdAt": "2024-09-11T17:45:23.592Z",
"updatedAt": "2024-09-11T17:45:48.046Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-11T17:45:48.046Z"
}
},
{
"id": "66e1d74c78cb22965450c862",
"createdAt": "2024-09-11T17:45:48.007Z",
"kind": "SurveyAnswerDefault",
"question": {
"id": "66a8a3f51d90655937ad6a1e",
"condition": false,
"content": [
{
"value": "Your registration has been successfully completed!",
"language": "EN",
"_id": "66a8a4091d90655937ad6c72"
},
{
"value": "Votre inscription a bien été prise en compte !",
"language": "FR",
"_id": "66a8a4091d90655937ad6c73"
}
],
"desc": [
{
"value": "Feel free to share around you!",
"language": "EN",
"_id": "66a8a4113374cc2d4a4b0a0d"
},
{
"value": "N'hésite pas à partager autour de toi !",
"language": "FR",
"_id": "66a8a4113374cc2d4a4b0a0e"
}
],
"options": {
"otherField": false
},
"button": {
"show": false,
"label": [
{
"_id": "66a8a3f51d90655937ad6a22",
"value": "",
"language": "EN"
}
]
},
"color": "",
"position": 2,
"media": {
"image": "",
"video": "",
"link": "",
"fit": false
},
"kind": "SurveyQuestionMessage"
},
"author": {
"id": "66e1d73378cb22965450c749",
"survey": "668bef6f3a40cc4751dade1d",
"name": "Tester #158",
"resultNPS": -1,
"tags": [],
"hasStarted": true,
"hasAnswered": true,
"reachEnd": true,
"deviceType": "desktop",
"hiddenFields": [],
"language": "FR",
"confidentiality": {
"status": "accepted"
},
"archived": false,
"dateLastAction": "2024-09-11T17:45:26.628Z",
"createdAt": "2024-09-11T17:45:23.592Z",
"updatedAt": "2024-09-11T17:45:48.046Z",
"__v": 0,
"currentQuestion": null,
"dateReachEnd": "2024-09-11T17:45:48.046Z"
}
}
]
}
]
its bit difficult to extract data because of the irregularities
what i understand from the JSON and the picture is that we have 8 questions and we are extracting answers for each question
its okay for the first question “Quel profil es-tu ?” because we have only one answer “Prestataire d’activités (coach sportif, prof de yoga…)”
but for the second one there are two questions in French and the ids are different for questions and answers which would fail if we query by the id
here is the blue print i was testing the JSON on its not working as expected but you can import and try to change the filter values and see
xtractqna.json (36.0 KB)
Hi @abhilash_naik,
Again, thank you for your time, I’m still struggle with data but I have begun to exchange with the dev team of the product to improve their webhook structure 
Regards,
Angelo