Approvals
Query all of a job's approval flows.
SELECT
Note: Filters provided with one of the supported operators listed in the "Operators" column can be processed server-side, all the other filters are processed client-side.
SELECT * FROM Approvals WHERE Id = 45045175117;
SELECT * FROM Approvals WHERE JobId = 76125135117;
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int64 | = | The approval's unique identifier |
| JobId | Int64 | = | The job for which the approval is configured. |
| OfferId | Int64 | The specific offer for the approval. | |
| Sequential | Bool | True or false based on whether the groups in the flow must approve sequentially. | |
| Version | Int | The specific version of the flow. | |
| ApprovalType | String | One of: open_job, offer_job, offer_candidate. | |
| ApprovalStatus | String | One of: pending, approved, rejected. | |
| RequestedByUserId | Int64 | The user who requested the approval be started. | |
| ApproverGroups | String | Array of approver groups. |