# Struggling to extract data from an array with get/map **URL:** \ **Category:** Questions\ **Tags:** get-map-function\ **Created:** [September 7, 2024, 10:12am UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304 "2024-09-07T10:12:06Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Angelo\_Blot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/angelo_blot/32/48412_2.png) [@Angelo\_Blot](https://community.make.com/u/Angelo_Blot)\ **Post date:** [September 7, 2024, 10:12am UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/1 "2024-09-07T10:12:06Z")
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! ![Capture d’écran 2024-09-07 à 11.59.30](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/e/7e4b0b647d0f90036c58a369bec12ab5515e5df4.png) ![Capture d’écran 2024-09-07 à 12.10.59](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/1/61674bce5c551db19b9391437a89c144d21f7338.png) ---
**Author:** ![Angelo\_Blot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/angelo_blot/32/48412_2.png) [@Angelo\_Blot](https://community.make.com/u/Angelo_Blot)\ **Post date:** [September 10, 2024, 9:04am UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/2 "2024-09-10T09:04:53Z")
Hi again, I have the same issue to extract that data : ![Capture d’écran 2024-09-09 à 19.05.35](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/8/6858d87b43d3e04ff84a0553e273f2cb1ae9ed80.png) This works well : ![Capture d’écran 2024-09-10 à 11.03.44](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/6/c670a55729c2ae4647288afc518e8da93a9c745c.png) This don’t : ![Capture d’écran 2024-09-10 à 10.58.10](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/f/aff0dc4c712918a65e8520e0ae126ded176f89d2.png) Thank you for your help ! ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [September 10, 2024, 9:23am UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/3 "2024-09-10T09:23:21Z")
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: 1. Run the scenario or retrieve it from the [History tab](https://www.make.com/en/help/scenarios/scenario-execution-history?_gl=1*13m3m9l*_gcl_au*MTIyODA1MDYzMy4xNzE3NjU0NjMw*_ga*MTEzMzkxNjg3My4xNzE3NjU0NjI5*_ga_MY0CJTCDSF*MTcxODY4MzE3OC4zNi4xLjE3MTg2ODU2MjkuNjAuMC4w). 2. For each module, click the white speech bubble located at the top-right corner. 3. Select “Download input/output bundles” from the dropdown menu. This will allow you to download the necessary data for further analysis and sharing. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/a/2a63ffecac19a934a220f3a9877e3f2fa83a4781.jpeg) ### Method 1: Attach a Text File 1. Copy the output data. 2. Paste the data into a text file. 3. Attach the text file to your ticket. ### Method 2: Direct Sharing 1. Use the direct sharing option available in the reply section. Please refer to the image below for guidance. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/a/0ae2509b27f938d9b066f90c5e40ed9b2fe875e8.png) **Best regards,** **Msquare Automation** _Gold Partner of Make_ @Msquare_Automation ---
**Author:** ![Angelo\_Blot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/angelo_blot/32/48412_2.png) [@Angelo\_Blot](https://community.make.com/u/Angelo_Blot)\ **Post date:** [September 10, 2024, 1:38pm UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/4 "2024-09-10T13:38:14Z")
```auto [ { "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" } } ] } ] ``` ---
**Author:** ![Angelo\_Blot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/angelo_blot/32/48412_2.png) [@Angelo\_Blot](https://community.make.com/u/Angelo_Blot)\ **Post date:** [September 10, 2024, 1:39pm UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/5 "2024-09-10T13:39:49Z")
And the last module doesn’t have output, just this message : ![Capture d’écran 2024-09-10 à 15.38.51](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/9/795ee78a84ca4f1d62a305fb9802e3b0268ab2e0.jpeg) Thanks again ---
**Author:** ![abhilash\_naik](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/abhilash_naik/32/48563_2.png) [@abhilash\_naik](https://community.make.com/u/abhilash_naik)\ **Post date:** [September 10, 2024, 11:54pm UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/6 "2024-09-10T23:54:38Z")
remove double quotes from “Commentaires” ---
**Author:** ![abhilash\_naik](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/abhilash_naik/32/48563_2.png) [@abhilash\_naik](https://community.make.com/u/abhilash_naik)\ **Post date:** [September 11, 2024, 12:35am UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/7 "2024-09-11T00:35:22Z")
if you are getting the data in the same format in every case then you can do this ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/3/133d9a54dabec799972437215283635f11c93d66.png) which will give this result ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/e/ce6c01c7dd669fff5a9b4b4864f07fa295c564f8.png) and using the value 1 in get function would give you the English value ---
**Author:** ![Angelo\_Blot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/angelo_blot/32/48412_2.png) [@Angelo\_Blot](https://community.make.com/u/Angelo_Blot)\ **Post date:** [September 11, 2024, 8:59am UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/8 "2024-09-11T08:59:55Z")
Hi @abhilash_naik, Thank you for your answer, I’ve tried to remove the quotes, but still the same : ![Capture d’écran 2024-09-11 à 10.56.47](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/6/769b5713eda562cae94242aed0e2a36c0edc0cad.png) Here the data : ```auto [ { "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" } ] ``` ---
**Author:** ![Angelo\_Blot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/angelo_blot/32/48412_2.png) [@Angelo\_Blot](https://community.make.com/u/Angelo_Blot)\ **Post date:** [September 11, 2024, 9:00am UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/9 "2024-09-11T09:00:47Z")
Unfortunately, the data changes…The only thing that doesn’t change is the ID of the question ---
**Author:** ![abhilash\_naik](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/abhilash_naik/32/48563_2.png) [@abhilash\_naik](https://community.make.com/u/abhilash_naik)\ **Post date:** [September 11, 2024, 11:52am UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/10 "2024-09-11T11:52:11Z")
question is in lowercase it should match the key in the JSON and you can get the answers by just doing map function ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/c/2c4498d9f24cad5c5f277cb427f370f1ad11d36e.png) would give this ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/2/12239a7e62f9e44b7e95403c049a8e362a255b43.png) ---
**Author:** ![Angelo\_Blot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/angelo_blot/32/48412_2.png) [@Angelo\_Blot](https://community.make.com/u/Angelo_Blot)\ **Post date:** [September 11, 2024, 5:53pm UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/11 "2024-09-11T17:53:27Z")
Thank you @abhilash_naik, it worked ! I still don’t manage to make the other works 🥲 ```auto [ { "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" } } ] } ] ``` ![Capture d’écran 2024-09-11 à 19.52.47](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/1/3176ed5877edef9d4a6231895068960b2b16ddb2.png) ---
**Author:** ![abhilash\_naik](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/abhilash_naik/32/48563_2.png) [@abhilash\_naik](https://community.make.com/u/abhilash_naik)\ **Post date:** [September 12, 2024, 3:23am UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/12 "2024-09-12T03:23:53Z")
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](https://community.make.com/uploads/short-url/hYmZbAEVEHi5DZWEMGGwkHu7T1t.json) (36.0 KB) ---
**Author:** ![Angelo\_Blot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/angelo_blot/32/48412_2.png) [@Angelo\_Blot](https://community.make.com/u/Angelo_Blot)\ **Post date:** [September 18, 2024, 8:02pm UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/13 "2024-09-18T20:02:15Z")
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 ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [September 25, 2024, 8:06pm UTC](https://community.make.com/t/struggling-to-extract-data-from-an-array-with-get-map/54304/14 "2024-09-25T20:06:18Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.