Hi there,
We created advanced reports to have live values from our projects’ custom fields in different sections. As my search resulted, it’s not possible to pull these values via API or similar to have them updated daily into a Google Sheet.
But is it possible to pull the column aggregated values from different sections to Google Sheets? Or are there any workarounds for this?
Cheers
Dan
Can you say more about this specifically? It’s possible to get the custom field values from tasks in a project, so I’m not sure what you’re looking to get that you were not able to?
Best case scenario we could pull the Data from the Dashboard we created which would be these:
The screenshot above shows the aggregated column values, which the dashboard is based on. But the dashboard values would be better
Ah I see, you’re wanting the aggregate values. As you’ve noted , that info is not available via the API. Your only option using the API is to pull the individual task values and do the aggregation in your code.
