Solved

Accessing table_record "Record Infos" using graphql

  • 19 November 2022
  • 1 reply
  • 146 views
enrique.herbella
Userlevel 4

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

icon

Best answer by anggela-leiva 21 November 2022, 17:59

View original
This topic has been closed for comments

1 reply

anggela-leiva
Rank
Userlevel 6
Badge

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
  }
}

Terms & ConditionsCookie settings