Skip to main content
Solved

 How to get all fields (and custom columns from table) from a card

  • August 18, 2020
  • 2 replies
  • 1994 views


 [GraphQL] Hello Everyone.
 I want to take a card ID and get all the standard AND custom data that has relations with it, so i.e: Card ABC has: Assignee
 Due date
 Company (that's a custom table I have created and inside this table, there's a custom ID i need to use)
 Etc...
 I am having trouble to get these information because I think that it's a simple "Inner Join" solution but after seeing all the reference APIs I couldnt understand the relationship between the tables. Someone ever did something like it and could help? Thanks!

Best answer by Roberto Chavarria

Hi there Thiago, hope all is well!

Our API is built on GraphQL, and it doesn’t accept SQL commands like Inner Joins or the likes.

Here is a query that can help you out with getting the value of the fields of the card you’ve inputted, and the value of the fields (along with the id and title of) the child cards that are connected to the card you’re searching from. If you need to look for the parent cards that are connected, simply replace the child_relations commando for parent_relations command.  

{
  card(id:11111111){
    fields{
      value
    }
    child_relations{
      source_type
      cards{
        id
        title
        fields{
          name
          value
        }
      }
    }
  }
}

You can think of this everything as a hierarchy of objects and their attributes, where the attributes are nested in each object. 

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

2 replies

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

Hi there Thiago, hope all is well!

Our API is built on GraphQL, and it doesn’t accept SQL commands like Inner Joins or the likes.

Here is a query that can help you out with getting the value of the fields of the card you’ve inputted, and the value of the fields (along with the id and title of) the child cards that are connected to the card you’re searching from. If you need to look for the parent cards that are connected, simply replace the child_relations commando for parent_relations command.  

{
  card(id:11111111){
    fields{
      value
    }
    child_relations{
      source_type
      cards{
        id
        title
        fields{
          name
          value
        }
      }
    }
  }
}

You can think of this everything as a hierarchy of objects and their attributes, where the attributes are nested in each object. 


tiago-fernandes

Você pode pesquisar por um card usando o find cards

{
  findCards(
    pipeId: 301145047
    search: {
      fieldId: "control_code"
      fieldValue: "815890.2022-05-24.6.10.New"
    }
  ) {
    edges {
      node {
        id
        title
      }
    }
  }
}

 

 

 


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