Skip to main content
Solved

Update a Table Record


Sérgio Moreira

I'm trying to update custom fields in the table record, but it seems the API only permits to update

the title and due date.

That mutation should work, isn't it?

mutation {

updateTableRecord(

input: {

id: %(id)s

fields_attributes: %(fields_attributes)s

}

The custom fields it is the field_attributes, in the follow way:

field_attributes = [

{"field_id": "field_id_1", "field_value": "field_value_1"}]

Any clues to update custom fields rather the title in Table Records?

Best answer by Nicole Chiroli

Hello, @Sérgio Moreira. How are you doing today?

You can update all of the fields, not only title and due date.  It would really depend on the types of fields you have, but you can search for the fields and how to use it in our documentation, inside the GraphiQl itself.
 


 


I hope this helps. If you have any other questions, I am here. 

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

4 replies

Nicole Chiroli
Pipefy Staff
Forum|alt.badge.img+10
  • Product Manager
  • 301 replies
  • Answer
  • October 7, 2020

Hello, @Sérgio Moreira. How are you doing today?

You can update all of the fields, not only title and due date.  It would really depend on the types of fields you have, but you can search for the fields and how to use it in our documentation, inside the GraphiQl itself.
 


 


I hope this helps. If you have any other questions, I am here. 


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

Hello @Sérgio Moreira! Just complementing @Nicole Chiroli’s answer, here is an example of how you can update a certain record’s specific field using this mutation. 

 

mutation{
  setTableRecordFieldValue(input:{
    table_record_id:1234567 #record's ID
    field_id:"field_id_here" #the field you want to update's field.
    value:"Field Value" # the field's new value you want to add to this record
  }) {
    clientMutationId
  }
}


In case you want to find the field’s ID, you can run this query


{
  table(id:"abc123"){
    table_fields{
      label
      id
    }
  }
}

 


jnihorimbere
Roberto Chavarria wrote:

Hello @Sérgio Moreira! Just complementing @Nicole Chiroli’s answer, here is an example of how you can update a certain record’s specific field using this mutation. 

 

mutation{
  setTableRecordFieldValue(input:{
    table_record_id:1234567 #record's ID
    field_id:"field_id_here" #the field you want to update's field.
    value:"Field Value" # the field's new value you want to add to this record
  }) {
    clientMutationId
  }
}


In case you want to find the field’s ID, you can run this query


{
  table(id:"abc123"){
    table_fields{
      label
      id
    }
  }
}

 

Hi, I’m trying to update/add assignee to a table record field using their contact ID but I’ve been struggling terribly. I can update/add other record fields, using the above code, such as email address and phone numbers but the assignee one is return empty value ({'data': {'setTableRecordFieldValue': {'table_record': {'id': 'record_id', 'title': 'record_name'}, 'table_record_field': {'value': '[]'}}}}).
I’m really new to this pipefy api, can anyone please help?


tsartori
Forum|alt.badge.img+4
  • Superuser
  • 157 replies
  • August 30, 2021

@jnihorimbere Open a new topic asking for help, here it will be harder for someone to help you :)


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