Replies posted by vitoria36

2 Replies

Sérgio Moreira
Sérgio MoreiraNew Participant
asked in Ask the Community

createTableRecord

Hello Sérgio, hope all is well!  You’d need to use the user’s ID instead of text. Here is an example of how to execute this query correctly:    mutation {createTableRecord(input: { table_id: "pWRuu4qV" title:"Title of record" fields_attributes:[ {field_id: "assignee_field", field_value: [123456, 654321]} {field_id:"short_text_field", field_value:"text here"} ]})} I added another field “short_text_field”, but it’s just for demonstration’s sake of how you would fill out multiple fields. Note: In this example, “ {field_id: "assignee_field", field_value: [123456, 654321]} ” will add the users with the IDs 123456 and 654321 as the field assignees for this record. So 2 users will be added.  This isn't working anymore. I got the following error:{"errors":[{"message":"Field must have selections (field \'createTableRecord\' returns CreateTableRecordPayload but has no selections. Did you mean \'createTableRecord { ... }\'?)","locations":[{"line":2,"column":11}],"path":["mutation","cr

2
vitoria36
2 years ago
vitoria36
vitoria36Regular Participant
asked in API

Get all records from a table

I managed to solve using pagination. Basically, each query returns a maximum of 50 objects, so it is necessary to make several queries to get all the records. I managed to do this with the answers to this question. If someone ever needs to query all the records from a table and store them in a DataFrame in Python, here is my code:import requestsimport jsonimport pandas as pdtable_id = TABLE_IDpipefy_token = TOKENtable_field = TABLE_FIELDSurl = "https://api.pipefy.com/graphql"headers = { "authorization": f"Bearer {pipefy_token}", "content-type": "application/json"}records_df = pd.DataFrame(columns=table_fields)has_next_page = Truefirst_query = Truewhile(has_next_page): if first_query: payload = {"query": "{ table_records(table_id:\""+table_id+"\") {edges {node {id title record_fields {name value}}} pageInfo {endCursor hasNextPage}}}"} first_query = False else: payload = {"query": "{ table_records(table_id:\""+table_id+"\",after:\""+end_cursor+"\") {edg

2
william-kliemann
2 years ago

Community Experts Leaderboard

Terms & ConditionsCookie settings