Jobs
Retrieve job records from JobNimbus including site address, status, financial summaries, parent contact details, and related metadata.
Columns
| Name | Type | References | |
| JobNimbusId [KEY] | String | ||
| RecordId | Integer | ||
| Type | String | ||
| CustomerId | String | ||
| JobName | String | ||
| RecordNumber | String | ||
| RecordTypeId | Integer | ||
| RecordTypeName | String | ||
| StatusId | Integer | ||
| StatusName | String | ||
| SourceId | String | ||
| SourceName | String | ||
| SalesRepId | String | ||
| SalesRepName | String | ||
| CreatedById | String | ||
| CreatedByName | String | ||
| Description | String | ||
| AddressLine1 | String | ||
| AddressLine2 | String | ||
| City | String | ||
| StateText | String | ||
| CountryName | String | ||
| Zip | String | ||
| CreatedDate | Datetime | ||
| UpdatedDate | Datetime | ||
| StatusChangeDate | Datetime | ||
| DateStart | Datetime | ||
| DateEnd | Datetime | ||
| IsActive | Boolean | ||
| IsArchived | Boolean | ||
| IsLead | Boolean | ||
| IsClosed | Boolean | ||
| ExternalId | String | ||
| AttachmentCount | Integer | ||
| TaskCount | Integer | ||
| IsEventAllDay | Boolean | ||
| AllDayEventStartDate | Date | ||
| AllDayEventEndDate | Date | ||
| ActualTime | Integer | ||
| EstimatedTime | Integer | ||
| ApprovedEstimateTotal | Decimal | ||
| ApprovedInvoiceTotal | Decimal | ||
| ApprovedInvoiceDue | Decimal | ||
| LastEstimate | Decimal | ||
| LastEstimateJobNimbusId | String |
Estimates.JobNimbusId | |
| LastEstimateNumber | String | ||
| LastEstimateDateCreated | Datetime | ||
| LastEstimateDateEstimate | Datetime | ||
| LastInvoice | Decimal | ||
| LastInvoiceJobNimbusId | String |
Invoices.JobNimbusId | |
| LastInvoiceNumber | String | ||
| LastInvoiceDateCreated | Datetime | ||
| LastInvoiceDateInvoice | Datetime | ||
| LastBudgetGrossProfit | Decimal | ||
| LastBudgetGrossMargin | Decimal | ||
| LastBudgetRevenue | Decimal | ||
| ParentApprovedEstimateTotal | Decimal | ||
| ParentApprovedInvoiceTotal | Decimal | ||
| ParentApprovedInvoiceDue | Decimal | ||
| ParentLastEstimate | Decimal | ||
| ParentLastInvoice | Decimal | ||
| ParentHomePhone | String | ||
| ParentMobilePhone | String | ||
| ParentWorkPhone | String | ||
| ParentFaxNumber | String | ||
| ClassId | String | ||
| ClassName | String | ||
| OpenEdgeId | String | ||
| ImageId | String | ||
| MergedIntoId | String | ||
| Miscellaneous | String | ||
| SunlightEvents | String | ||
| SunlightStatusAndId | String | ||
| LocationId | Integer | ||
| GeographicCoordinates | String | ||
| OwnerIds | String | ||
| RelatedRecords | String | ||
| Subcontractors | String | ||
| FieldAssistEntries | String | ||
| AutomationRules | String | ||
| Tags | String | ||
| PrimaryRecord | String | ||
| StageDatesOverrides | String | ||
| StageDatesOverridesOn | String |