Skip to main content
Solved

Help database

  • January 11, 2021
  • 1 reply
  • 114 views

Nigel O'connell
Pipefy Staff

I'm trying to see all the data related with my database (table) for all my organizations.I'm using this query bellow:

Can anyone support me with this? Because I can't see the record

 

{""query"": ""{ organizations { id tables{edges{node{id table_fields{id label {id name} } table_records{ edges {node {id title parent_relations {id repo }}}}}}}}}""}"

 

Best answer by Roberto Chavarria

Hello Nigel! Here is an example of how you should create the query. (There must be parameters added to specify what organization you want to look at) 

{ 
  organization (id:123456) {
    id
    tables {
      edges {
        node {
          id
          table_fields {
            id
            label
          }
          labels{
            name
            id
            color
          }
          table_records {
            edges {
              node {
                id
                title
                parent_relations {
                  id
                  repo
                }
              }
            }
          }
        }
      }
    }
  }
}

Also, the “label” attribute inside the “table_fields” object is the field’s name, and not actual color labels. I added that section below the table fields object so that you can see those as well.

View original
Did this topic help you find an answer to your question?

1 reply

Roberto Chavarria
Pipefy Staff
Forum|alt.badge.img+5

Hello Nigel! Here is an example of how you should create the query. (There must be parameters added to specify what organization you want to look at) 

{ 
  organization (id:123456) {
    id
    tables {
      edges {
        node {
          id
          table_fields {
            id
            label
          }
          labels{
            name
            id
            color
          }
          table_records {
            edges {
              node {
                id
                title
                parent_relations {
                  id
                  repo
                }
              }
            }
          }
        }
      }
    }
  }
}

Also, the “label” attribute inside the “table_fields” object is the field’s name, and not actual color labels. I added that section below the table fields object so that you can see those as well.


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