Getting no text for column that has text on board

monday Apps & Developers Feature Requests - API and Apps Framework
1

Hi, hope someone can help me out with this query question. I’m running this query:

{ 
  boards(ids: 4035946526) { 
    groups(ids:["new_group"]) { 
      title 
      id
      items {
        id
        column_values (ids:["connect_boards", "long_text", "files", "formula"]) { 
          id
        	title
        	text
                value
        }
      }
    } 
  } 
}

which returns the expected results:

{
  "data": {
    "boards": [
      {
        "groups": [
          {
            "title": "Q3 2023 Projects",
            "id": "new_group",
            "items": [
              {
                "id": "4132114327",
                "column_values": [
                  {
                    "id": "long_text",
                    "title": "Short Description",
                    "text": "xxxxxxxxxxxxxxx\n",
                    "value": "{\"text\":\"xxxxxxxxxxxxxx\\n\",\"changed_at\":\"2023-03-13T19:06:47.226Z\"}"
                  },
                  {
                    "id": "connect_boards",
                    "title": "Themes / Investment Areas",
                    "text": "xxxxxxxxxxxxxxxxxxxxxxxxxx.",
                    "value": "{\"changed_at\":\"2023-06-21T19:14:14.442Z\",\"linkedPulseIds\":[{\"linkedPulseId\":4600317529}]}"
                  },
                  {
                    "id": "formula",
                    "title": "Total Pts",
                    "text": "",
                    "value": null
                  },...

except for the column “Total Pts”, which returns an empty string for every result. The results should be a number, either as an integer or string. I’ve confirmed each item in the board has a value. Is there something wrong with my query that is preventing these values from being returned?

image

2

Hello there @KargoTechComms,

The API does not return the text or value of formula columns since that value is calculated on the client side.

As a workaround, you can either use an app like General Caster to cast the result of a formula in a “text” or “numbers” column, and then query that column, or query for the structure of the formula in the “formula” column, and then performing the operations on your end:

{
  boards(ids: 1234567890) {
    columns(ids: "formula") {
      settings_str
    }
  }
}

Let me know if you have any other questions :slightly_smiling_face:

Cheers,
Matias