Skip to main content

How to read column value by pulseId

  • May 31, 2021
  • 6 replies
  • 2617 views
S

I have activated “Developer Mode” in my account. I found phone number column name is 1_phone95
col-name

Using webhook, I receive pulseId which is row id(i guess). webhook doesn’t send all column values. So i try to read 1_phone95 column values by the following code snippet

$query = ‘query { pulse (ids: 1339686138) { column_values { id type } } }’;
But i get the following error:
{“errors”:[{“message”:“Field ‘pulse’ doesn’t exist on type ‘Query’”,“locations”:[{“line”:1,“column”:9}],“fields”:[“query”,“pulse”]}],“account_id”:8374454}

Now my question is, how do i read all columns or a single column(1_phone95) value? Is it by pulseId or is there are any further technique?

I am highly interested to study query in detail. May i have study/documentation link please.

Thanks in advance.

This topic has been closed for replies.

6 replies

AlexSavchuk
Forum|alt.badge.img
  • AlexSavchuk
  • monday.com Team Member
  • May 31, 2021

Hey @sumonci 👋

That’s a great question! Your query seems almost right! To be transparent with you, we do not have a “pulse” object in our API, and you will need to query “items” instead. I also noticed you are only querying for the ID and Type of the column, and you’ll need to add either “value” or “text” as the field you are querying as well.

This query should work:

$query = ‘query { items (ids: 1339686138) { column_values { id type value text } } }’;

I hope this helps clarify 🙂

-Alex

    S
    • sumonci
    • Author
    • New Participant
    • May 31, 2021

    Thanks a lot @AlexSavchuk
    i have one more questions, can i get only 1_phone95 column value instead of all column values?

    H
    Forum|alt.badge.img
    • Helen
    • monday.com Team Member
    • June 1, 2021

    Hi @sumonci!

    Yes absolutely, you can specify the ID of the column that you want to retrieve. Is your column ID “phone95”?

    If so, you can include the ID in the argument for column_values like so:

    image

    This query will return only the column values for the “phone95” column for all of your items on that board.

    I hope this helps!

      S
      • sumonci
      • Author
      • New Participant
      • June 2, 2021

      Thanks @Helen
      May i have a query documentation page link please.

      AlexSavchuk
      Forum|alt.badge.img
      • AlexSavchuk
      • monday.com Team Member
      • June 2, 2021

      @sumonci

      Sure thing! You can find more info in our documentation page below:

      API Documentation - v2

      I hope this helps 🙂

      -Alex

        A
        • Anonymous
        • June 10, 2021

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

        Terms & ConditionsCookie settingsAccessibility statement