Query all groups and specific column values
I am having a difficult time figuring out how to configure my query to get the desirable information.
I have a board with about 500 groups. Each group can have any where between 1 to 100 items. I need my query to gather each groups “id” and “title”. Within that I need every item with it’s “id”, “name”, and a specific “column_values” based on a provided column id. Within the “column_values”, I need it’s “value” and “id”. A final return would look something like this:
{'group': {'id': '12345_y4321_00___nags_head_', 'title': '12345-R039177.00 - Nags Head', 'items_page': {'items': [{'id': '12345', 'name': 'Echo', 'column_values': [{'value': None, 'id': 'phase'}]}, {'id': '56789', 'name': '02 - Admin', 'column_values': [{'value': '"0001 - 0001 Project Management"', 'id': 'phase'}]}]}}}
I was hitting some query limits, and read that I should be use next_items_page and cursor. I can then append each query to
