Skip to main content

Unable to retrieve very first column using API

  • December 27, 2021
  • 4 replies
  • 844 views

I am new here and using your API v2 to try get a list of all of the columns and their values. Everything works great but I cannot seem to ever get the very first column and have no idea why.

I am using this as my query:

{
	boards(ids: xxxxxxx) {
		owner {
			id
		}
		items() {
			column_values {
				id,
				text,
				title
			}
		}
	}
}

The result is this
image

However in my table I have this:

The red arrow is what is missing in the response, the green arrow is what is first in the response.


d

How do I get it to show the values of the very first column? This makes no sense that it doesnt.

Thanks

This topic has been closed for replies.

4 replies

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • December 27, 2021

Hello @ugobey!

Welcome to the community. I hope you like it here 💪

It seems like you are trying to retrieve the items’ names.

You can do that like this:

{
  boards(ids: XXXXXXX) {
    owner {
      id
    }
    items {
      name
      column_values {
        id
        text
        title
      }
    }
  }
}

Please let me know if that works for you!

Cheers
-Matias


  • Author
  • New Participant
  • December 27, 2021

That worked 100% thank you
image

However I will be honest I didnt understand that I can do that from the documentation. Didnt know you can also combine queries.

Maybe you can provide more examples in your docs for others?

Basically how would we know to add name in the query if its assumed that name is just another column value, which it is?

Appreciated!


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • December 27, 2021

Hello again @ugobey!

I am glad that worked 🙂

I will make sure to pass this request to our team so that it can be reviewed 💪

Thank you for that feedback!

Cheers,
-Matias


  • January 3, 2022

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