Bring data from Pipefy to your Lakehouse.
https://app.pipefy.com/organizations/{YourOrganizationID}
).Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
All Cards
all_cards_PIPE_ID
).Key Fields:id
: Unique identifier for the cardtitle
: Title of the cardcreated_at
: When the card was createdupdated_at
: When the card was last updatedfinished_at
: When the card was finisheddone
: Whether the card is completedage
: Age of the card in secondsassignees
: Users assigned to the cardcreated_by
: User who created the cardcomments
: Comments on the cardcomments_count
: Number of comments on the cardcurrent_phase
: The current phase of the cardcurrent_phase_age
: Age in the current phase in secondsdue_date
: Due date for the cardexpired
: Whether the card is expiredfields
: Custom fields on the cardphases_history
: History of phases the card has been throughchild_relations
: Child cards related to this cardparent_relations
: Parent cards related to this cardlabels
: Labels on the cardlate
: Whether the card is lateoverdue
: Whether the card is overduestarted_current_phase_at
: When the card started its current phaseurl
: URL of the carduuid
: UUID of the cardPhases
pipe_id
: ID of the pipe this phase belongs toid
: Unique identifier for the phasename
: Name of the phasedescription
: Description of the phasecreated_at
: When the phase was createdPhase Fields
phase_id
: ID of the phase this field belongs toid
: Unique identifier for the fieldlabel
: Label of the fielddescription
: Description of the fieldis_multiple
: Whether the field can have multiple valuesoptions
: Options for the field (if applicable)required
: Whether the field is requiredsettings
: Field-specific settingstype
: Type of the fieldTables
id
: Unique identifier for the tablename
: Name of the tableinternal_id
: Internal ID of the tabledescription
: Description of the tablepublic
: Whether the table is publictable_records_count
: Number of records in the tableusers_count
: Number of users with access to the tabletype
: Type of the tablestatuses
: Statuses defined for the tablelabels
: Labels defined for the tablemembers
: Members with access to the tabletable_fields
: Fields in the tableTable Records
table_records_TABLE_ID
).Key Fields:id
: Unique identifier for the recordtitle
: Title of the recordcreated_at
: When the record was createdupdated_at
: When the record was last updatedcreated_by
: User who created the recordtable
: The table this record belongs torecord_fields
: Fields in the record