I’m trying to iterate trough bundles from eventbrite (different attendees) but there is seems no option. Am I wrong?
Hello @MikeMS and welcome to the Make Community!
You should click the + symbol to expand each Bundle. It’s possible each bundle represents a specific attendee.
Any module(s) you put after that will run once for each bundle/attendee.
In that way the Eventbrite module itself acts as an Iterator so you don’t need a separate Iterator module.
If you don’t need to process each individually, use an array aggregator and you can create an array of attendees instead.
I hope that makes sense and hope it helps!
@Donald_Mitchell Thank you so much! It looks like it’s working now. However, as I dive deeper into custom questions, I’ve noticed an issue: the Airtable module doesn’t seem to pull answers from sub-bundles in Eventbrite. Have you encountered anything like this?
You’d need to use map() to retrieve the answers.
For example, to retrieve Gender, it’s something like this:
map(#.Answers; answer; Question; Gender)
Where #.Answers
is the array.
You have to use raw names (which aren’t shown, but you can get by hovering over each key (Answer, Question, Type, Question ID).
Here is how the output of Eventbrite breaks down…
- Output is Multiple bundles.
- Each bundle consists of a Questions collection (or array), Answers array (which is an array of collections), and Barcodes collection (or array), among other types of output.
- Each item of the Answers array, consists of Collections consisting of multiple key/value pairs.
- The keys are Answer, Question, Type, and Question ID. Hover over those to get their raw key names to use the map() and other functions.
If you want an example using your data, you can click this icon then click “Download output bundles”, then post the output here and we can send back a blueprint that can demonstrate how to access the answers and other bits of info from Eventbrite. Do you have test data you can generate and download?
@Donald_Mitchell thank you! should I just map it through airtable module like this?
Here is the test data that I’m using:
[
{
“id”: “184136654893”,
“tax”: “$0.00”,
“name”: “Mike”,
“email”: “test@test.com”,
“gross”: “$0.00”,
“status”: “Attending”,
“answers”: [
{
“answer”: “Test”,
“question”: “City/ State of Residence”,
“type”: “text”,
“question_id”: “252120413”
},
{
“answer”: “South Asian”,
“question”: “Ethnicity”,
“type”: “multiple_choice”,
“question_id”: “252120423”
},
{
“answer”: “Male”,
“question”: “Gender”,
“type”: “multiple_choice”,
“question_id”: “252120433”
},
{
“answer”: “50-64”,
“question”: “Age Range”,
“type”: “multiple_choice”,
“question_id”: “252120443”
},
{
“answer”: “Senior”,
“question”: “Job Title”,
“type”: “text”,
“question_id”: “252120453”
},
{
“answer”: “Global”,
“question”: “Company”,
“type”: “text”,
“question_id”: “252120463”
},
{
“answer”: “Business | Finance”,
“question”: “Industry”,
“type”: “multiple_choice”,
“question_id”: “252120473”
},
{
“answer”: “Senior”,
“question”: “Career Level”,
“type”: “multiple_choice”,
“question_id”: “252120483”
},
{
“answer”: “No”,
“question”: “Are you a founder?”,
“type”: “multiple_choice”,
“question_id”: “252120493”
},
{
“question”: “If yes, in 1-2 sentences, give us the name and a brief description of your business.”,
“type”: “text”,
“question_id”: “252120503”
},
{
“answer”: “Professionals in the same industry as me | Professionals in a different industry than me | New Friends”,
“question”: “Who do you want to connect with at this event?”,
“type”: “multiple_choice”,
“question_id”: “252120513”
},
{
“question”: “Submit a question for the panelists!”,
“type”: “text”,
“question_id”: “253759603”
},
{
“answer”: “Website”,
“question”: “How did you hear about this event?”,
“type”: “multiple_choice”,
“question_id”: “252120543”
},
{
“question”: “If you selected the community/partner organization or friend/colleague options, tell us who!”,
“type”: “text”,
“question_id”: “252120553”
}
],
“changed”: “2024-11-27T22:15:21.000Z”,
“created”: “2024-11-27T22:11:27.000Z”,
“profile”: {
“first_name”: “Mike”,
“last_name”: “Test”,
“addresses”: {},
“cell_phone”: “999111999111”,
“email”: “mike@test.com”,
“name”: “Mike Test”
},
“surname”: " Test",
“barcodes”: [
{
“status”: “unused”,
“barcode”: “1119394391222211893001”,
“created”: “2024-11-27T22:11:31.000Z”,
“changed”: “2024-11-27T22:11:31.000Z”,
“checkin_type”: 0,
“is_printed”: false
}
],
“event_id”: “107222144359”,
“order_id”: “11122243923”,
“quantity”: 1,
“refunded”: false,
“affiliate”: “ebdssbdestsearch”,
“cancelled”: false,
“base_price”: “$0.00”,
“cell_phone”: “999111999111”,
“checked_in”: false,
“invited_by”: null,
“payment_fee”: “$0.00”,
“guestlist_id”: null,
“eventbrite_fee”: “$0.00”,
“ticket_class_id”: “1918183493”,
“ticket_class_name”: “General Admission”
}
]
I also tried assigning variables to test different approach, but I’m getting the functions themselves as outputs instead of their results. And there is no errors unfortunately
Here is how the map() function should look:
Yours is text so it’s not converting the text into functions. When you type map, as soon as you type the open parenthesis it converts to a function.
Oh, I didn’t know that it’s a text! Thank you so much for the tip!
It’s working as a function now, but I’m getting empty results. Could this be a syntax issue? I set it up based on the function description
I think the syntax is good, but it might be looking for the question_id as a number when it is text. Try putting a toString() function around the question_id you’re searching on, or use the question text instead.
Donald, thanks again for your suggestion earlier! I tried wrapping the question_id in toString() like you mentioned, but I’m still getting empty results, even with question text. Here’s what I’m using:
I double-checked the setup, and it seems to match the data structure, but it’s not working. Do you think it might be an issue with how the Answers is being referenced, or am I missing something obvious?
Donald, I tried this approach and it worked! Hooray! Thank you a lot for your help and tips!