How do you get the linkedId value for use in a create_item mutation

monday Apps & Developers
,
1

I’m trying to figure out what the pulseId is and how I can query it via the API. I am executing the create_item mutation programatically and I need to be able to get the pulseId without hardcoding it. I first assumed it was the id of the item that column should link to, but that clearly isn’t correct. Below is the mutation query I’m running. It has been generated programatically.

mutation {
    create_item(
      item_name: "HW1: Schematic",
      board_id: 1602164146,
      group_id: "new_group72163",
      column_values: "{\"status0\":\"Low\",\"status\":\"Waiting for review\",\"date\":{\"date\":\"2022-01-22\",\"time\":\"06:59:59\"},\"numbers\":2,\"connect_boards\":{\"linkedPulseIds\":[{\"linkedPulseId\":\"2088579761\"}]},\"text\":\"10352612\"}"
    ) {
      id
    }
  }

The pulseId value is generated from this query

query {
  boards(ids: 1602164112) {
    items {
      id
      name
    }
  }
}

Running the mutation results in an error

{
  "error_code": "ColumnValueException",
  "status_code": 200,
  "error_message": "There are items that are not in the connected boards",
  "error_data": {}
}

If I create an item by hand with the value in the linked column I want, and running the query below, I am able to confirm that the pulseID is different.

query {
  boards(ids: 1602164146) {
    items {
      id
      name,
      column_values {
        id,
        value
      }
    }
  }
}

** Result of previous query **

{
                "id": "connect_boards",
                "value": "{\"changed_at\":\"2022-01-03T09:09:39.019Z\",\"linkedPulseIds\":[{\"linkedPulseId\":2088311736}]}"
              },

So what is the right way to get the linkedId?

2

I worked it out. The wrong ID was a red herring, the item I selected manually was different from the one being chosen automatically. The real issue was that the ID was in quotes, thus being treated as a string and not a numbeer.

3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.