Hello community!
So I have being around monday for almost 2 years and I work with the API for reporting a lot. We have a lot of information in the company and some boards have about 1000 items, but inside the items we can have around |0 subitems happening and we would love to export them filtered, if we export everything it takes forever, almost one hour.
In this scence we have our own Python parses that pull out all the information using pagination and the larger the information the slower is the straction. How can I create a more detailed query using pagination (cursor) and query_params at the same time?
One example is this:
{
boards(ids: “board_id”) {
items_count
items_page(
limit: 500
query_params: {rules: [{column_id: “COLUMN_ID”, compare_value: [“sample”], operator: contains_text}]},
) {
cursor
items {
id
name
column_values(
ids: [“COLUMN_ID_01”, “COLUMN_ID_02”, “COLUMN_ID_03”, “COLUMN_ID_04”, “COLUMN_ID_05”]
) {
column {
title
id
}
… on BoardRelationValue {
linked_item_ids
display_value
}
}
subitems {
id
name
}
}
}
}
}
So first things first, every time I run the query in monday playground it returns a lot of info, not all the info, but cursor returns null, meaning I cannot go any further. Has anyone faced this situation?