The files column represents files attached to a board. Our API partially supports this column, so you can read the files column via the API but cannot update it.

Reading the files column

You can return the data in a files column in two different formats. The text field will return the data as a simple string that displays the URL of the file. The value field will return the data as a JSON string that shows metadata about the files. You cannot select which metadata you want to return.

Therefore, we recommend querying the assets field instead of the file column to simplify your query. Doing so allows you to specify the exact information you want to return. You will also have additional fields to choose from that can return more metadata than querying the files column.

query {
  boards (ids:2973227049) {
    items (ids: 2973227079) {
      assets {
        id
        name
        url
      }
    }
  }
}

Clearing the files column

You can clear the files column using a change_column_value mutation like the one below.

mutation {
 change_column_value(board_id: 2973227049, item_id: 2973227079, column_id: "files", value: "{\"clear_all\": true}") {
  id
 }
}

You can also find the Postman request to clear the files column here.

📘

Have questions?

Join our developer community! You can share your questions and learn from fellow users and monday.com product experts.

Don’t forget to search before opening a new topic!