Skip to main content
Solved

Accessing table_record "Record Infos" using graphql

  • November 19, 2022
  • 1 reply
  • 221 views

enrique.herbella

Hi!

I am new at using graphql with pipefy API.

I am trying to retrieve all the “Record Infos” of table rows using the pipefy API.

Using 

{"query":"{ table_records(table_id: 12345678) { edges { node { id title done table { id } created_at created_by { id } } } } }"}',

I am able to retrieve preliminary information about each row in the table. This is a sample result:

[0] => stdClass Object
    (
        [node] => stdClass Object
            (
                [id] => 99999999
                [title] => ROW TITLE
                [done] => 
                [table] => stdClass Object
                    (
                        [id] => AAA-BBBB
                    )

                [created_at] => 2022-02-10T09:19:48-05:00
                [created_by] => stdClass Object
                    (
                        [id] => 11111111
                    )

            )

    )

However I am struggling to find the proper method to retrieve the node’s complete content; Meaning all the fields and their content shown in the “Record Infos” section when using the pipefy app.

Thank you for your help

Enrique

Best answer by anggela-leiva

Hi Enrique! How you doing?

If you want the query to show the information on the card, you can use this one:

 

{
  table_record(id: 2193284) {
    assignees {
      id
      name
    }
    created_at
    created_by {
      id
      name
    }
    due_date
    finished_at
    id
    labels {
      id
      name
    }
    parent_relations {
      name
      source_type
    }
    record_fields {
      array_value
      date_value
      datetime_value
      filled_at
      float_value
      name
      required
      updated_at
      value
    }
    summary {
      title
      value
    }
    table {
      id
    }
    title
    updated_at
    url
  }
}

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

1 reply

anggela-leiva
Pipefy Staff
Forum|alt.badge.img
  • Pipefy Staff
  • 33 replies
  • Answer
  • November 21, 2022

Hi Enrique! How you doing?

If you want the query to show the information on the card, you can use this one:

 

{
  table_record(id: 2193284) {
    assignees {
      id
      name
    }
    created_at
    created_by {
      id
      name
    }
    due_date
    finished_at
    id
    labels {
      id
      name
    }
    parent_relations {
      name
      source_type
    }
    record_fields {
      array_value
      date_value
      datetime_value
      filled_at
      float_value
      name
      required
      updated_at
      value
    }
    summary {
      title
      value
    }
    table {
      id
    }
    title
    updated_at
    url
  }
}


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings