search

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
15.96k stars 4.1k forks source link

[source-monday] Missing column value `title` in `items` stream #34245

Open reso7373 opened 9 months ago

reso7373 commented 9 months ago

Connector Name

source-monday

Connector Version

2.0.0

What step the error happened?

Other

Relevant information

I noticed in one of the commit in the PR for the version 2.0.0 that they removed the field title in the item stream.

I just want to know if this is intended or not. And if yes, if I really need to use the post API migrated (2.x.x ++) version, which other field that I can use to retrieve this column title value

Relevant log output

No response

Contribute

marcosmarxm commented 9 months ago

Hello @reso7373 I tried to re-add the field to the items stream and got the following error from Monday API:

2024-01-19 18:38:43 platform > Validation failed: 
"{\"errors\":[{\"message\":\"Field 'title' doesn't exist on type 'ColumnValue'\",\"locations\":[{\"line\":1,\"column\":223}],\"path\":
[\"query\",\"boards\",\"items_page\",\"items\",\"column_values\",\"title\"],\"extensions\":
{\"code\":\"undefinedField\",\"typeName\":\"ColumnValue\",\"fieldName\":\"title\"}}],\"account_id\":..."}"

Probably the changed to Monday API v2.+ removed this field and it's not possible to retrieve anymore.

image image