Getting null value for specific column

[vivek (Vivek T)]

On Monday dashboard, we can clearly see values in CM Column but we are getting null value in API.

Link: https://northern-accountants.monday.com/boards/1831612862/

We are using below GraphQL query to fetch data:

{
    to_be_start : boards(ids: 1831612862) {
        groups(ids: "new_group81176") {
            ...boardFields
        }
    }
}

fragment boardFields on Group {
  items {
    column_values(ids: ["mirror26"]) {
        text
    }
  }       
}

Same issue exists with “formula_1” column in below link.
Link: https://northern-accountants.monday.com/boards/632285673

We are using below GraphQL query to fetch data:

{
    iyep_awaiting_further_client_info : boards(ids: 1831612862) {
        groups(ids: "new_group1835") {
            ...boardFields
        }
    }
}
fragment boardFields on Group {
    items {
        column_values(ids: ["date7","formula_1"]) {
            text
        }
    }
}

[Matias.Monday (Matias)]

Hello there @vivek!

You will not be able to retrieve the “value” of columns of type formula and mirror via API. This is not supported.

Having said that. you can get the “text” of the mirror column.

If you need to retrieve the information inside a formula column, you can build a workaround with the app General Caster (in our marketplace) which can perform a formula and cast the result in a column of a type that is supported by our API.

I hope this helps

Cheers,
Matias