Skip to main content
Solved

Error 3000 - Algo deu errado GraphQL


login7

Boa tarde a todos, estou tentando criar um card via graphql, só que a api está me retornando erro. Alguem sabe oque pode ser?

 

mutation {  
      createCard(  
        input: {
          pipe_id: {{pipe_code}}  
          fields_attributes: [
            {
            field_id:"c_digo_da_entrega_no_fornecedor",
            field_value:"""{{table4.selectedRow.data.freight_partner_external_id}}"""
          	},
            {
              field_id:"valor_do_frete",
            	field_value: """{{table4.selectedRow.data.freight_price?table4.selectedRow.data.freight_price:0}}"""
						},
            {
              field_id:"hor_rio_limite_de_chegada_para_carregamento_1",
              field_value:"""{{table4.selectedRow.data.freight_scheduled_delivey_datetime}}"""
            },

            {
              field_id:"link_de_acompanhamento_1",
              field_value:"""{{table4.selectedRow.data.freight_tracking_link}}"""
            },            
            {
              field_id:"nome_do_motorista_1",
              field_value:"""{{table4.selectedRow.data.freight_delivery_point_of_contact}}"""
            },
            {
              field_id:"contato_do_motorista_1",
              field_value:"""{{table4.selectedRow.data.freight_delivery_poc_phone}}"""
            },
            {
              field_id: "identify_autom_tico",
            	field_value: """{{table5.selectedRow.data.identify}}""" 
            },
            {
              field_id: "itens_da_retirada_1",
            	field_value:"""{{item_value.value}}"""
            },

            {
              field_id:"coment_rios",
              field_value:"""{{table4.selectedRow.data.client_delivery_notes}}"""
            },
            {
              field_id:"endere_o_de_retirada"
              field_value:"""{{table5.selectedRow.data.retirada}}"""
            },
            {
              field_id:"quantos_endere_os_de_retirada",
              field_value:"1"
            },
            {
              field_id:"contato_rdo_autom_tico",
              field_value:"""{{table5.selectedRow.data.name}}"""
            },
            {
              field_id:"respons_vel_da_obra_autom_tico",
              field_value:"""{{table5.selectedRow.data.phone_number}}"""
            },
            {
              field_id:"nome_da_obra",
              field_value:"""{{ table5.selectedRow.data.name }}"""
            }
          ]
        }   
      ){  
        card {  
          id
        }  
      }  
  }

O erro foi esse aqui:

 

{
  "data": {
    "createCard": null
  },
  "errors": [
    {
      "message": "Algo deu errado",
      "locations": [
        {
          "line": 2,
          "column": 7
        }
      ],
      "path": [
        "createCard"
      ],
      "code": 30000,
      "type": "ExecutionError"
    }
  ]
}

 

Best answer by Marcos Carvalho

hey @xp-hf ,

 

if you want to list all the records in a database to be used in your mutation, you can do something like this: 

 

{
  table(id: "4asda4w3") {
    table_records {
      edges {
        node {
          id
        }
      }
    }
  }
}

You’ll get in return:


 

{
  "data": {
    "table": {
      "table_records": {
        "edges": [
          {
            "node": {
              "id": "96385214"
            }
          },
          {
            "node": {
              "id": "74185296"
            }
          },
          {
            "node": {
              "id": "87456985"
            }
          },
          {
            "node": {
              "id": "87654321"
            }
          },
          {
            "node": {
              "id": "12345678"
            }
          }
        ]
      }
    }
  }
}

 

 

then you can use one of these ids in your mutation:

 

mutation{
  createCard(
    input: {
      pipe_id: 219739
      fields_attributes: [
        {field_id: "connector", field_value:[12345678]}
      ]
    }
  ) {

    card {
      id
      title
    }
  }
}

 

 

hope it helps you :smiley:

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

3 replies

Marcos Carvalho
Pipefy Staff
Forum|alt.badge.img+6

Hey @login7 , how are you?

It seems that some field value is being sent in a invalid format.

 

Please double check your fields types and inputs to make sure everything is ok. 

 

Here something to help you on it: 

 

 

 

 

If you need anything else, please let me know.

 

 

 


xp-hf
  • Regular Participant
  • 1 reply
  • August 11, 2021

@Marcos Carvalho, can u help me with another doubt?
I’m trying to create card via API, but one of fields of card is “connection fileds” and i don’t know where i find the integer value to use to select the right value i want in database. Do you know?


Marcos Carvalho
Pipefy Staff
Forum|alt.badge.img+6

hey @xp-hf ,

 

if you want to list all the records in a database to be used in your mutation, you can do something like this: 

 

{
  table(id: "4asda4w3") {
    table_records {
      edges {
        node {
          id
        }
      }
    }
  }
}

You’ll get in return:


 

{
  "data": {
    "table": {
      "table_records": {
        "edges": [
          {
            "node": {
              "id": "96385214"
            }
          },
          {
            "node": {
              "id": "74185296"
            }
          },
          {
            "node": {
              "id": "87456985"
            }
          },
          {
            "node": {
              "id": "87654321"
            }
          },
          {
            "node": {
              "id": "12345678"
            }
          }
        ]
      }
    }
  }
}

 

 

then you can use one of these ids in your mutation:

 

mutation{
  createCard(
    input: {
      pipe_id: 219739
      fields_attributes: [
        {field_id: "connector", field_value:[12345678]}
      ]
    }
  ) {

    card {
      id
      title
    }
  }
}

 

 

hope it helps you :smiley:


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

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