Jobs endpoints
Jobs (projects), job tasks, planning lines and job ledger entries for project reporting such as budget versus actual.
All URLs on this page are relative to the company URL, https://api.businesscentral.dynamics.com/v2.0/{tenantId}/{environment}/api/datawareness/endpoints/v1.0/companies({companyId})/. See Construction of the URL.
Master data
| Endpoint | Description | Business key | Source table | Tier |
|---|---|---|---|---|
jobDimensions | Default dimensions assigned to jobs. | jobNo&&dimensionCode | Default Dimension | Premium |
jobPostingGroups | Job posting group definitions. | code | Job Posting Group | Premium |
jobs | Job/Project master data. | no | Job | Premium |
jobTasks | Job task definitions. | jobNo&&jobTaskNo | Job Task | Premium |
Transactional data
| Endpoint | Description | Business key | Source table | Tier |
|---|---|---|---|---|
jobLedgerEntries | Job ledger entries. | entryNo | Job Ledger Entry | Premium |
jobPlanningLines | Job planning lines (budget and billable lines per job task). | jobNo&&jobTaskNo&&lineNo | Job Planning Line | Premium |
Example queries
Actuals for one job
GET .../jobLedgerEntries?$filter=jobNo eq 'J00010'
&$select=entryNo,jobNo,jobTaskNo,postingDate,entryType,type,no,quantity,totalCostLCY,lineAmountLCY
Budget for one job
GET .../jobPlanningLines?$filter=jobNo eq 'J00010'
&$select=jobNo,jobTaskNo,lineNo,lineType,type,no,quantity,totalCostLCY,lineAmountLCY
Compare with the job ledger entries per jobTaskNo for budget versus actual.
Job list
GET .../jobs?$select=no,description,status,sellToCustomerNo,startingDate,endingDate,personResponsibleNo
Tips
- Fields: every endpoint's fields, with types, are listed by
properties— see Metadata discovery. The same list is on the endpoint's page under BI Endpoints in Business Central.