Solved

TABLE RECORD STATUS FIELD

  • 15 September 2021
  • 1 reply
  • 208 views

Userlevel 3

Hi! I’m trying to update the Status Field of a Table Record through integromat. My quesiton is: I couldn’t find the name of this field, what is it’s name. And also, wich values can be used to update it: Ativo e Concluído?

icon

Best answer by genietim 16 September 2021, 11:32

View original

1 reply

Userlevel 7
Badge +12

The issue is that the status is not a field. In Integromat, you will probably have to use a custom Pipefy GraphQL query/mutation. As can be seen in the API documentation, status can be passed in the `UpdateTableRecordInput` object of the `updateTableRecord` mutation.

 

The “Custom Pipefy GraphQL query/mutation” in Integromat

 

Note that what you actually pass is a “statusId”. This will be a database-specific id for the status. So, per table, you will have to query the id of the status some other way once, so you know them afterwards, as they will be constant for this table. The mutation would then look e.g. like this:

mutation {
updateTableRecord(input: { id: theIdOfTheTableRecordToUpdate, statusId: theIdOfTheStatus }) { clientMutationId }
}

 

To query the status id, I would recommend to use e.g. postman and then query the status like the following, once with a table record id of an activated and once with a table record id of a deactivated entry.

query {
table_record(id: enterYourTableEntryIdHere) {
title,
id,
status {
id, name
},
}
}

 

Reply