Extract data via APV v2

Hi Folks,

I have been tasked to extract data from 3 keys boards for MGMT reporting, I’m trying to extract all rows and columns from the board I’m using Python Request. I just started writing the script and it seem like this will be a very complex task.

Does anyone have an previous code they can share ? or is there an easier way to extract the data?
I also don’t mind the option of exported the board into excel or csv

Not sure how you would execute this query using Python, but this is what I query to get all items from a board:

{
	"query": "{boards(ids: XXXXXX, limit:100) {
items {
id
name
column_values {
text
title
value}
created_at}}}"

}
1 Like

Thanks I was able to use something similar. I have just seen online that we’re not able to extract column values for calculated columns? is there any other way of extracting this data?

query = """ query { boards (ids: %s limit: 20, page: 1) { id name columns { title id } items {name column_values { # id title # value text } group{title} } }}""" % ()