Report581DataRequest

GET {{base_url}}/Report581DataRequest

Retrieves data for Report 581 (Job Reconciliation Report).

API
Report Data API

Requires Authentication
Yes (Employee)

Returns
Object (ReportData)

Batch?
No

Request Params

HEADERS

RESPONSES

status: OK

[{"CustomerName":"Job Recon Client","ProjectName":"Jobs Job Recon Client","JobTypeName":"job type id 1","TeamName":"Streisand fans","DepartmentName":"Administrations (test)","CompanyInitials":"BBA","CompanyName":"Bluebird Agency","Currency":"DKK","JobName":"[PLS DO NOT TOUCH THIS JOB] Job Recon Report ","JobStatusID":1,"JobStatus":"In progress","JobStart":"2022-11-01T00:00:00.000Z","JobEndDate":"2023-12-01T00:00:00.000Z","ProjectManager":"*Macro* Mike McLean","AccountManager":"*Macro* Mike McLean","ActivityText":"Photo","ActivityId":13003,"PriceHours":0,"PriceHoursCost":0,"PriceMaterialSale":0,"PriceMaterialCost":0,"PriceExternalCost":22500,"PriceExternalSale":33750,"PriceHoursSale":0,"PriceExtraSale":0,"PriceDiscount":0,"OpenPurchaseOrderCost":0,"OpenPurchaseOrderSale":0,"TimeEntryHours":0,"TimeEntryHoursCost":0,"TimeEntryHoursSale":0,"EACHours":0,"EACHoursCost":0,"EACHoursSale":0,"ScheduledHours":0,"ScheduledHoursCost":0,"ScheduledHoursSale":0,"Invoiced":25312.5,"ExternalPurchasesCost":22750,"ExternalPurchasesSale":34125,"MaterialCost":0,"MaterialSale":0,"EstimatedRevenue":33750,"EstimatedPurchaseCost":-22500,"SysVar267":1,"ActualRevenue":34125,"ActualPurchaseCost":-22750},{"CustomerName":"Job Recon Client","ProjectName":"Jobs Job Recon Client","JobTypeName":"job type id 1","TeamName":"Streisand fans","DepartmentName":"Administrations (test)","CompanyInitials":"BBA","CompanyName":"Bluebird Agency","Currency":"DKK","JobName":"[PLS DO NOT TOUCH THIS JOB] Job Recon Report ","JobStatusID":1,"JobStatus":"In progress","JobStart":"2022-11-01T00:00:00.000Z","JobEndDate":"2023-12-01T00:00:00.000Z","ProjectManager":"*Macro* Mike McLean","AccountManager":"*Macro* Mike McLean","ActivityText":"Design","ActivityId":13001,"PriceHours":150,"PriceHoursCost":0,"PriceMaterialSale":0,"PriceMaterialCost":0,"PriceExternalCost":0,"PriceExternalSale":0,"PriceHoursSale":60000,"PriceExtraSale":0,"PriceDiscount":0,"OpenPurchaseOrderCost":0,"OpenPurchaseOrderSale":0,"TimeEntryHours":15,"TimeEntryHoursCost":750,"TimeEntryHoursSale":6000,"EACHours":321,"EACHoursCost":16208103,"EACHoursSale":128400,"ScheduledHours":306,"ScheduledHoursCost":16207353,"ScheduledHoursSale":122400,"Invoiced":45000,"ExternalPurchasesCost":0,"ExternalPurchasesSale":0,"MaterialCost":0,"MaterialSale":0,"EstimatedRevenue":60000,"EstimatedPurchaseCost":0,"SysVar267":1,"ActualRevenue":6000,"ActualPurchaseCost":0},{"CustomerName":"Job Recon Client","ProjectName":"Jobs Job Recon Client","JobTypeName":"job type id 1","TeamName":"Streisand fans","DepartmentName":"Administrations (test)","CompanyInitials":"BBA","CompanyName":"Bluebird Agency","Currency":"DKK","JobName":"[PLS DO NOT TOUCH THIS JOB] Job Recon Report ","JobStatusID":1,"JobStatus":"In progress","JobStart":"2022-11-01T00:00:00.000Z","JobEndDate":"2023-12-01T00:00:00.000Z","ProjectManager":"*Macro* Mike McLean","AccountManager":"*Macro* Mike McLean","ActivityText":"Music","ActivityId":13004,"PriceHours":0,"PriceHoursCost":0,"PriceMaterialSale":0,"PriceMaterialCost":0,"PriceExternalCost":50000,"PriceExternalSale":62500,"PriceHoursSale":0,"PriceExtraSale":0,"PriceDiscount":0,"OpenPurchaseOrderCost":50000,"OpenPurchaseOrderSale":62500,"TimeEntryHours":0,"TimeEntryHoursCost":0,"TimeEntryHoursSale":0,"EACHours":0,"EACHoursCost":0,"EACHoursSale":0,"ScheduledHours":0,"ScheduledHoursCost":0,"ScheduledHoursSale":0,"Invoiced":46875,"ExternalPurchasesCost":0,"ExternalPurchasesSale":0,"MaterialCost":0,"MaterialSale":0,"EstimatedRevenue":62500,"EstimatedPurchaseCost":-50000,"SysVar267":1,"ActualRevenue":0,"ActualPurchaseCost":0},{"CustomerName":"Job Recon Client","ProjectName":"Jobs Job Recon Client","JobTypeName":"job type id 1","TeamName":"Streisand fans","DepartmentName":"Administrations (test)","CompanyInitials":"BBA","CompanyName":"Bluebird Agency","Currency":"DKK","JobName":"[PLS DO NOT TOUCH THIS JOB] Job Recon Report ","JobStatusID":1,"JobStatus":"In progress","JobStart":"2022-11-01T00:00:00.000Z","JobEndDate":"2023-12-01T00:00:00.000Z","ProjectManager":"*Macro* Mike McLean","AccountManager":"*Macro* Mike McLean","ActivityText":"Development","ActivityId":13002,"PriceHours":240,"PriceHoursCost":0,"PriceMaterialSale":0,"PriceMaterialCost":0,"PriceExternalCost":0,"PriceExternalSale":0,"PriceHoursSale":30000,"PriceExtraSale":0,"PriceDiscount":0,"OpenPurchaseOrderCost":0,"OpenPurchaseOrderSale":0,"TimeEntryHours":15,"TimeEntryHoursCost":750,"TimeEntryHoursSale":1875,"EACHours":237,"EACHoursCost":12000,"EACHoursSale":29625,"ScheduledHours":222,"ScheduledHoursCost":11250,"ScheduledHoursSale":27750,"Invoiced":22500,"ExternalPurchasesCost":0,"ExternalPurchasesSale":0,"MaterialCost":0,"MaterialSale":0,"EstimatedRevenue":30000,"EstimatedPurchaseCost":0,"SysVar267":1,"ActualRevenue":1875,"ActualPurchaseCost":0},{"CustomerName":"Job Recon Client","ProjectName":"Jobs Job Recon Client","JobTypeName":"job type id 1","TeamName":"Streisand fans","DepartmentName":"Administrations (test)","CompanyInitials":"BBA","CompanyName":"Bluebird Agency","Currency":"DKK","JobName":"[PLS DO NOT TOUCH THIS JOB] Job Recon Report ","JobStatusID":1,"JobStatus":"In progress","JobStart":"2022-11-01T00:00:00.000Z","JobEndDate":"2023-12-01T00:00:00.000Z","ProjectManager":"*Macro* Mike McLean","AccountManager":"*Macro* Mike McLean","ActivityText":"Blame MS More","ActivityId":1,"PriceHours":0,"PriceHoursCost":0,"PriceMaterialSale":0,"PriceMaterialCost":0,"PriceExternalCost":0,"PriceExternalSale":0,"PriceHoursSale":0,"PriceExtraSale":0,"PriceDiscount":0,"OpenPurchaseOrderCost":0,"OpenPurchaseOrderSale":0,"TimeEntryHours":0,"TimeEntryHoursCost":0,"TimeEntryHoursSale":0,"EACHours":1136,"EACHoursCost":113600000,"EACHoursSale":1136,"ScheduledHours":1136,"ScheduledHoursCost":113600000,"ScheduledHoursSale":1136,"Invoiced":0,"ExternalPurchasesCost":0,"ExternalPurchasesSale":0,"MaterialCost":0,"MaterialSale":0,"EstimatedRevenue":0,"EstimatedPurchaseCost":0,"SysVar267":1,"ActualRevenue":0,"ActualPurchaseCost":0},{"CustomerName":"Job Recon Client","ProjectName":"Jobs Job Recon Client","JobTypeName":"job type id 1","TeamName":"Streisand fans","DepartmentName":"Administrations (test)","CompanyInitials":"BBA","CompanyName":"Bluebird Agency","Currency":"DKK","JobName":"[PLS DO NOT TOUCH THIS JOB] Job Recon Report ","JobStatusID":1,"JobStatus":"In progress","JobStart":"2022-11-01T00:00:00.000Z","JobEndDate":"2023-12-01T00:00:00.000Z","ProjectManager":"*Macro* Mike McLean","AccountManager":"*Macro* Mike McLean","ActivityText":"Music","ActivityId":202,"PriceHours":0,"PriceHoursCost":0,"PriceMaterialSale":0,"PriceMaterialCost":0,"PriceExternalCost":0,"PriceExternalSale":0,"PriceHoursSale":0,"PriceExtraSale":0,"PriceDiscount":0,"OpenPurchaseOrderCost":0,"OpenPurchaseOrderSale":0,"TimeEntryHours":0,"TimeEntryHoursCost":0,"TimeEntryHoursSale":0,"EACHours":8.5,"EACHoursCost":0,"EACHoursSale":8.36,"ScheduledHours":8.5,"ScheduledHoursCost":0,"ScheduledHoursSale":8.36,"Invoiced":0,"ExternalPurchasesCost":0,"ExternalPurchasesSale":0,"MaterialCost":0,"MaterialSale":0,"EstimatedRevenue":0,"EstimatedPurchaseCost":0,"SysVar267":1,"ActualRevenue":0,"ActualPurchaseCost":0},{"CustomerName":"Job Recon Client","ProjectName":"Jobs Job Recon Client","JobTypeName":"job type id 1","TeamName":"Streisand fans","DepartmentName":"Administrations (test)","CompanyInitials":"BBA","CompanyName":"Bluebird Agency","Currency":"DKK","JobName":"[PLS DO NOT TOUCH THIS JOB] Job Recon Report ","JobStatusID":1,"JobStatus":"In progress","JobStart":"2022-11-01T00:00:00.000Z","JobEndDate":"2023-12-01T00:00:00.000Z","ProjectManager":"*Macro* Mike McLean","AccountManager":"*Macro* Mike McLean","ActivityText":"ss","ActivityId":1000,"PriceHours":0,"PriceHoursCost":0,"PriceMaterialSale":0,"PriceMaterialCost":0,"PriceExternalCost":0,"PriceExternalSale":0,"PriceHoursSale":0,"PriceExtraSale":0,"PriceDiscount":0,"OpenPurchaseOrderCost":0,"OpenPurchaseOrderSale":0,"TimeEntryHours":0,"TimeEntryHoursCost":0,"TimeEntryHoursSale":0,"EACHours":17,"EACHoursCost":720000,"EACHoursSale":17,"ScheduledHours":17,"ScheduledHoursCost":720000,"ScheduledHoursSale":17,"Invoiced":0,"ExternalPurchasesCost":0,"ExternalPurchasesSale":0,"MaterialCost":0,"MaterialSale":0,"EstimatedRevenue":0,"EstimatedPurchaseCost":0,"SysVar267":1,"ActualRevenue":0,"ActualPurchaseCost":0}]