Skip to main content
Feedback

2024-01 Monday API upgrade v2024-01

Starting January 15, 2024, the monday.com API will cease supporting version 2023-07. To maintain seamless feature, Data Integration has enhanced the integration to the current supported version, 2024-01, which includes a sub-upgrade to version 2023-10. Data Integration will deploy the update on January 8th, 2024, ensuring compatibility with downstream processes in your Data Flows ahead of the official Monday.com API version upgrade.

Modifications to columns within the existing reports

Boards report

Changes

  • Deprecated the Owner.id and Owner.name fields.
  • Deprecated the Columns.Pos field and pos column.

New fields

  • owners``{id} and owners``{name} (board owners)
  • creator``{id} and creator``{name} (board creator)
  • item_terminology (board nickname)
  • type (board object type)
  • updated_at (last update time)

Items report

Change

Deprecated the Column.Values.Title field.

New fields

  • assets {created_at} (asset creation date)
  • assets {file_extension} (asset file extension)
  • assets {file_size} (asset file size)
  • assets {id} (asset ID)
  • assets {name} (asset name)
  • assets {original_geometry} (asset original geometry)
  • assets {public_url} (asset public URL)
  • assets {uploaded_by{id name}} (asset uploader)
  • assets {url} (asset URL)
  • assets {url_thumbnail} (asset thumbnail URL)
  • parent_item``{id} (parent item ID)
  • parent_item``{name} (parent item name)
  • relative_link (item relative path)
  • subitems``{id} and subitems``{name} (item subitems)
  • subscribers``{id} and subscribers{name} (item subscribers)
  • updates``{id} and updates{updated_at} (item updates)
  • column_values``{column{title}} (column title)

Teams report

New field

users{id} and users{name} (team users)

Users report

New fields

  • current_language (user language)
  • is_verified (user email verification status)
  • last_activity (last user activity date)
  • out_of_office details (status, notifications, start/end date, type)
  • sign_up_product_kind (user sign up product)
  • teams{id} and teams{name} (user teams)

What actions should you take

To guarantee a seamless transition to the new API, you have different options:

  • This is the recommended option for optimal compatibility with the updated API.
  • Create a new Data Flow or clear and re-run the mapping process on the day of the integration upgrade.
  • Treat existing Boards and Items DWH tables as historical data and load the data to new tables with the same name.

2. Keep the original mapping structure

  • Possible but may result in data loss.
  • Data Integration fills deprecated columns with null values after the upgrade.
  • Highly recommend backing up data before choosing this option.

3. Add newly added fields

  • Preserve the existing mapping structure while adding new fields to your target table.
  • On the day of the upgrade, click on the “Auto Mapping” button, and newly added fields will be automatically added to your existing mapping structure.
note

Because of the structure and constraints of the Record datatype, clients who write data to Google BigQuery and Redshift need to execute the Refresh the Mapping or Create a New Data Flow option to make sure that changes will take effect as intended.

Additional information

  • Data Integration will align the Monday Kit to all changes mentioned above.
  • For more information on the Monday.com API upgrade, refer to the Migration topic.
On this Page