Skip to main content
Solved

TABLE RECORD STATUS FIELD

  • September 15, 2021
  • 1 reply
  • 228 views

diretoria101

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?

Best answer by genietim

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
        },
    }
}

 

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

1 reply

genietim
Forum|alt.badge.img+12
  • Pipefy Legend
  • 412 replies
  • Answer
  • September 16, 2021

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
        },
    }
}

 


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