So, in short, I’m trying to create a scenario where the first step is to pull a list of data from Monday.com (a project management platform, our company use it like a database), and then the second step is to map that list of data to google form as dropdown options.
For context, the data from Monday looks like this:
{
"body": {
"data": {
"boards": [
{
"items_page": {
"items": [
{
"column_values": [
{
"text": "Aliyah Malik",
"column": {
"title": "Coachee"
}
},
{
"text": "AR_Friendship Aspire Academy",
"column": {
"title": "District Name"
}
},
{
"text": "FAA Garland Elementary",
"column": {
"title": "School Name"
}
}
]
},
{
"column_values": [
{
"text": "Aarathi George",
"column": {
"title": "Coachee"
}
},
{
"text": "AR_Friendship Aspire Academy",
"column": {
"title": "District Name"
}
},
{
"text": "Osceola North Elementary",
"column": {
"title": "School Name"
}
}
]
},
{
"column_values": [
{
"text": "Abdulgafar Jaji",
"column": {
"title": "Coachee"
}
},
{
"text": "AR_Friendship Aspire Academy",
"column": {
"title": "District Name"
}
},
{
"text": "Hope High",
"column": {
"title": "School Name"
}
}
]
}
...
I only want to map the text value whose column title equals Coachee
- I’ve tried GPT, this is what it gave me
{{map(6.body.data.boards[].items_page.items[].column_values[?(@.column.title == 'Coachee')].text; "value")}}But I got this error “Failed to map ‘question.options’: Function ‘map’ finished with error! Function ‘?’ not found!”. This query seems to be too advanced for Make to comprehend. Anyone has any insights/tips on this?
Or is there any module I can add in between the Monday and Google Form module that will help me process the data better before feeding it to the form