Skip to main content
Solved

Get connected TableRecords from Card

  • November 30, 2020
  • 1 reply
  • 325 views
Nigel O'connell
Pipefy Staff

I'm trying to use the property ""connectedRepoItems"" in ""fields"", but even my card has one or more public table records associated, I got null values.{
card(id: ""XXX"") {fields { connectedRepoItems }
}
}answer:{
""data"": {
""card"": {
""fields"": [
{
""connectedRepoItems"": null
},
{
""connectedRepoItems"": null
},
{
""connectedRepoItems"": null"

Best answer by Marcos Carvalho

Hey Nigel, 

 

To get the connected table records or cards, you need to query the child_relations, if it’s a child relation, or parent_relations, if it’s a parent relation :slight_smile: 

 

Like this: 

 

{
  card(id: 987654321) {
    fields {
      name
      value
    }
    child_relations {
      id
      cards {
        id
        title
        fields {
          name
          value
        }
      }
    } parent_relations {
      id
      cards {
        id
        title
        fields {
          name
          value
        }
      }
    }

  } 
}

 

    1 reply

    Marcos Carvalho
    Pipefy Staff
    Forum|alt.badge.img+6
    • Marcos CarvalhoPipefy Staff
    • Pipefy Staff
    • 55 replies
    • Answer
    • December 3, 2020

    Hey Nigel, 

     

    To get the connected table records or cards, you need to query the child_relations, if it’s a child relation, or parent_relations, if it’s a parent relation :slight_smile: 

     

    Like this: 

     

    {
      card(id: 987654321) {
        fields {
          name
          value
        }
        child_relations {
          id
          cards {
            id
            title
            fields {
              name
              value
            }
          }
        } parent_relations {
          id
          cards {
            id
            title
            fields {
              name
              value
            }
          }
        }

      } 
    }

     

    Marcos Carvalho


    Terms & ConditionsCookie settingsAccessibility statement