POST lineItems/processScheduleReportExcel

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
ReportId	string	None.
CreatedById	integer	None.
CreatedBy	string	None.
ShowAccountId	integer	None.
FunctionalAreaId	integer	None.
FunctionalAreas	Collection of integer	None.
VendorId	integer	None.
StatusId	LineItemStatusType	None.
ShowLocationId	integer	None.
ShowLocations	Collection of integer	None.
IncludeSetup	boolean	None.
IncludeTurnover	boolean	None.
IncludeTeardown	boolean	None.
SetUpStart	date	None.
TearDownEnd	date	None.
CurrentSortAscending	boolean	None.
CurrentSortType	ScheduleViewSortType	None.
Xlsx	boolean	None.
ShowId	integer	None.
AllActive	boolean	None.
Output	ScheduleOutputDto	None.
InvoicedType	string	None.
IsSalesUser	boolean	None.

Request Formats

application/json, text/json

Sample:

{
  "ReportId": "sample string 1",
  "CreatedById": 2,
  "CreatedBy": "sample string 3",
  "ShowAccountId": 4,
  "FunctionalAreaId": 1,
  "FunctionalAreas": [
    1,
    2
  ],
  "VendorId": 1,
  "StatusId": 1,
  "ShowLocationId": 1,
  "ShowLocations": [
    1,
    2
  ],
  "IncludeSetup": true,
  "IncludeTurnover": true,
  "IncludeTeardown": true,
  "SetUpStart": "2025-12-14T22:10:02.6670478+00:00",
  "TearDownEnd": "2025-12-14T22:10:02.6670478+00:00",
  "CurrentSortAscending": true,
  "CurrentSortType": 1,
  "Xlsx": true,
  "ShowId": 10,
  "AllActive": true,
  "Output": {
    "AccountLogoFileId": "f414d5b1-e00c-423d-919f-afc4fbf2c2af",
    "AccountLogoFileName": "sample string 1",
    "ProjectName": "sample string 2",
    "ProjectNumber": 1,
    "ProjectOpenDate": "2025-12-14T22:10:02.6670478+00:00",
    "ProjectCloseDate": "2025-12-14T22:10:02.6670478+00:00",
    "GeneratedBy": "sample string 3",
    "FacilityLocations": [
      {
        "Facility": "sample string 1",
        "Location": "sample string 2",
        "FacilityId": 1,
        "LocationId": 1,
        "Sessions": [
          {
            "StartTime": "2025-12-14T22:10:02.6670478+00:00",
            "EndTime": "2025-12-14T22:10:02.6670478+00:00",
            "FilterStartTime": "2025-12-14T22:10:02.6670478+00:00",
            "FilterEndTime": "2025-12-14T22:10:02.6826636+00:00",
            "LineItems": [
              {
                "Id": 1,
                "Task": "sample string 2",
                "Vendor": "sample string 3",
                "Description": "sample string 4",
                "Quantity": "sample string 5",
                "FunctionalArea": "sample string 6",
                "Status": "sample string 7",
                "TicketNumber": "sample string 8",
                "Men": "sample string 9",
                "Hours": "sample string 10",
                "VendorComments": "sample string 11",
                "Turnover": "sample string 12",
                "TurnoverComments": "sample string 13",
                "FunctionalAreaComments": "sample string 14",
                "TaskSort": 999
              },
              {
                "Id": 1,
                "Task": "sample string 2",
                "Vendor": "sample string 3",
                "Description": "sample string 4",
                "Quantity": "sample string 5",
                "FunctionalArea": "sample string 6",
                "Status": "sample string 7",
                "TicketNumber": "sample string 8",
                "Men": "sample string 9",
                "Hours": "sample string 10",
                "VendorComments": "sample string 11",
                "Turnover": "sample string 12",
                "TurnoverComments": "sample string 13",
                "FunctionalAreaComments": "sample string 14",
                "TaskSort": 999
              }
            ]
          },
          {
            "StartTime": "2025-12-14T22:10:02.6670478+00:00",
            "EndTime": "2025-12-14T22:10:02.6670478+00:00",
            "FilterStartTime": "2025-12-14T22:10:02.6670478+00:00",
            "FilterEndTime": "2025-12-14T22:10:02.6826636+00:00",
            "LineItems": [
              {
                "Id": 1,
                "Task": "sample string 2",
                "Vendor": "sample string 3",
                "Description": "sample string 4",
                "Quantity": "sample string 5",
                "FunctionalArea": "sample string 6",
                "Status": "sample string 7",
                "TicketNumber": "sample string 8",
                "Men": "sample string 9",
                "Hours": "sample string 10",
                "VendorComments": "sample string 11",
                "Turnover": "sample string 12",
                "TurnoverComments": "sample string 13",
                "FunctionalAreaComments": "sample string 14",
                "TaskSort": 999
              },
              {
                "Id": 1,
                "Task": "sample string 2",
                "Vendor": "sample string 3",
                "Description": "sample string 4",
                "Quantity": "sample string 5",
                "FunctionalArea": "sample string 6",
                "Status": "sample string 7",
                "TicketNumber": "sample string 8",
                "Men": "sample string 9",
                "Hours": "sample string 10",
                "VendorComments": "sample string 11",
                "Turnover": "sample string 12",
                "TurnoverComments": "sample string 13",
                "FunctionalAreaComments": "sample string 14",
                "TaskSort": 999
              }
            ]
          }
        ]
      },
      {
        "Facility": "sample string 1",
        "Location": "sample string 2",
        "FacilityId": 1,
        "LocationId": 1,
        "Sessions": [
          {
            "StartTime": "2025-12-14T22:10:02.6670478+00:00",
            "EndTime": "2025-12-14T22:10:02.6670478+00:00",
            "FilterStartTime": "2025-12-14T22:10:02.6670478+00:00",
            "FilterEndTime": "2025-12-14T22:10:02.6826636+00:00",
            "LineItems": [
              {
                "Id": 1,
                "Task": "sample string 2",
                "Vendor": "sample string 3",
                "Description": "sample string 4",
                "Quantity": "sample string 5",
                "FunctionalArea": "sample string 6",
                "Status": "sample string 7",
                "TicketNumber": "sample string 8",
                "Men": "sample string 9",
                "Hours": "sample string 10",
                "VendorComments": "sample string 11",
                "Turnover": "sample string 12",
                "TurnoverComments": "sample string 13",
                "FunctionalAreaComments": "sample string 14",
                "TaskSort": 999
              },
              {
                "Id": 1,
                "Task": "sample string 2",
                "Vendor": "sample string 3",
                "Description": "sample string 4",
                "Quantity": "sample string 5",
                "FunctionalArea": "sample string 6",
                "Status": "sample string 7",
                "TicketNumber": "sample string 8",
                "Men": "sample string 9",
                "Hours": "sample string 10",
                "VendorComments": "sample string 11",
                "Turnover": "sample string 12",
                "TurnoverComments": "sample string 13",
                "FunctionalAreaComments": "sample string 14",
                "TaskSort": 999
              }
            ]
          },
          {
            "StartTime": "2025-12-14T22:10:02.6670478+00:00",
            "EndTime": "2025-12-14T22:10:02.6670478+00:00",
            "FilterStartTime": "2025-12-14T22:10:02.6670478+00:00",
            "FilterEndTime": "2025-12-14T22:10:02.6826636+00:00",
            "LineItems": [
              {
                "Id": 1,
                "Task": "sample string 2",
                "Vendor": "sample string 3",
                "Description": "sample string 4",
                "Quantity": "sample string 5",
                "FunctionalArea": "sample string 6",
                "Status": "sample string 7",
                "TicketNumber": "sample string 8",
                "Men": "sample string 9",
                "Hours": "sample string 10",
                "VendorComments": "sample string 11",
                "Turnover": "sample string 12",
                "TurnoverComments": "sample string 13",
                "FunctionalAreaComments": "sample string 14",
                "TaskSort": 999
              },
              {
                "Id": 1,
                "Task": "sample string 2",
                "Vendor": "sample string 3",
                "Description": "sample string 4",
                "Quantity": "sample string 5",
                "FunctionalArea": "sample string 6",
                "Status": "sample string 7",
                "TicketNumber": "sample string 8",
                "Men": "sample string 9",
                "Hours": "sample string 10",
                "VendorComments": "sample string 11",
                "Turnover": "sample string 12",
                "TurnoverComments": "sample string 13",
                "FunctionalAreaComments": "sample string 14",
                "TaskSort": 999
              }
            ]
          }
        ]
      }
    ]
  },
  "InvoicedType": "sample string 12",
  "IsSalesUser": true
}

Response Information

Resource Description

globally unique identifier

Response Information

Response body formats

application/json, text/json

Sample:

"4e7f8025-d8b4-4dff-a64a-750fdff426bd"