GOAL: Create a drop down list of "Leads" from Monday.com CRM board (via GraphQL query)
PROBLEM: Mapping multiple items to 'select' component, can select single item values, but can't figure out how to populate menu with all items.
CONTEXT, PROGRESS SO FAR:
I have successfully built the GraphQL query that fetches all items in specified board.
Returned response looks like this:
{
** "data": {**
** "boards": [**
** {**
** "items_page": {**
** "cursor": null,**
** "items": [**
** {**
** "id": "6924088206",**
** "name": "Watanabe Floral, Inc."**
** },**
** {**
** "id": "6924758558",**
** "name": "Dakine"**
** }**
ISSUE:
This JS Expression to bind data will work but only for one value, it looks like this:
{{ query1.data.boards[0].items_page.items[0].name }}
PROPOSED SOLUTION FROM AI
{{ query1.data.boards[0].items_page.items.map(item => item.name)}}
This appears to work to some extent, because when I hover over "Name" it displays: name: "Watanabe Floral, Inc" | "Dakine"
I understand this is due to it still being in array format so I tried:
{{ query1.data.boards[0].items_page.items.map(item => ({ label: item.name, value: item.id })) }}
and still get a blank output... it seems to be picking up the data find but having trouble getting it into the dropdown menu.
Only option I was thinking I have left is having a JS transformer, having the data sent to a table then running a SQL query on said table.
I've spent hours on this! I am at a bit of a lost, your time and consideration in helping me will be GREATLY appreciated!
Thank you!!!
