POST api/upsert-issues-excel

Request Information

URI Parameters

None.

Body Parameters

Collection of IssuesVM

Name	Type	Additional information
IssueId	integer	None.
ProjectId	integer	None.
ProjectName	string	None.
ProjectCode	string	None.
TractorId	integer	None.
TractorNumber	string	None.
Config	string	None.
IssueDescription	string	None.
FailureHours	integer	None.
UpdationHours	integer	None.
HoursAfterUpdation	integer	None.
Implement	string	None.
IssueReportingDate	date	None.
PartDescription	string	None.
PartCode	string	None.
Photograph	string	None.
L1RCA	string	None.
ConcernedAcknowledgement	boolean	None.
IsNew	boolean	None.
ORCStatus	string	None.
ResponsibleSectionId	integer	None.
ResponsibleSectionName	string	None.
SubGroupId	integer	None.
SubGroupName	string	None.
ResponsibleSectionLeadId	integer	None.
UserName	string	None.
CategoryId	integer	None.
CategoryName	string	None.
ScoreMatrix	integer	None.
ScoreMatrixName	string	None.
Severity	integer	None.
Probability	integer	None.
Detection	integer	None.
DetectionName	string	None.
RPN	integer	None.
AgingSinceReported	string	None.
Aging	integer	None.
RelevantDoc	string	None.
FinalRCA	string	None.
InterimAction	string	None.
PermanentAction	string	None.
TargetDate	date	None.
IsDeleted	boolean	None.
IsArchived	boolean	None.
CreatedBy	integer	None.
CreatedDate	date	None.
ModifiedBy	integer	None.
ModifiedDate	date	None.
DeletedBy	integer	None.
DeletedDate	date	None.
ImagePathRelevant	string	None.
ImagePathPhoto	string	None.
IsTesting	boolean	None.

Request Formats

application/json, text/json

Sample:

[
  {
    "IssueId": 1,
    "ProjectId": 1,
    "ProjectName": "sample string 1",
    "ProjectCode": "sample string 2",
    "TractorId": 1,
    "TractorNumber": "sample string 3",
    "Config": "sample string 4",
    "IssueDescription": "sample string 5",
    "FailureHours": 1,
    "UpdationHours": 1,
    "HoursAfterUpdation": 1,
    "Implement": "sample string 6",
    "IssueReportingDate": "2024-11-26T17:58:44.7590718+05:30",
    "PartDescription": "sample string 7",
    "PartCode": "sample string 8",
    "Photograph": "sample string 9",
    "L1RCA": "sample string 10",
    "ConcernedAcknowledgement": true,
    "IsNew": true,
    "ORCStatus": "sample string 11",
    "ResponsibleSectionId": 1,
    "ResponsibleSectionName": "sample string 12",
    "SubGroupId": 1,
    "SubGroupName": "sample string 13",
    "ResponsibleSectionLeadId": 1,
    "UserName": "sample string 14",
    "CategoryId": 1,
    "CategoryName": "sample string 15",
    "ScoreMatrix": 1,
    "ScoreMatrixName": "sample string 16",
    "Severity": 1,
    "Probability": 1,
    "Detection": 1,
    "DetectionName": "sample string 17",
    "RPN": 1,
    "AgingSinceReported": "sample string 18",
    "Aging": 1,
    "RelevantDoc": "sample string 19",
    "FinalRCA": "sample string 20",
    "InterimAction": "sample string 21",
    "PermanentAction": "sample string 22",
    "TargetDate": "2024-11-26T17:58:44.7590718+05:30",
    "IsDeleted": true,
    "IsArchived": true,
    "CreatedBy": 1,
    "CreatedDate": "2024-11-26T17:58:44.7590718+05:30",
    "ModifiedBy": 1,
    "ModifiedDate": "2024-11-26T17:58:44.7590718+05:30",
    "DeletedBy": 1,
    "DeletedDate": "2024-11-26T17:58:44.7590718+05:30",
    "ImagePathRelevant": "sample string 25",
    "ImagePathPhoto": "sample string 26",
    "IsTesting": true
  },
  {
    "IssueId": 1,
    "ProjectId": 1,
    "ProjectName": "sample string 1",
    "ProjectCode": "sample string 2",
    "TractorId": 1,
    "TractorNumber": "sample string 3",
    "Config": "sample string 4",
    "IssueDescription": "sample string 5",
    "FailureHours": 1,
    "UpdationHours": 1,
    "HoursAfterUpdation": 1,
    "Implement": "sample string 6",
    "IssueReportingDate": "2024-11-26T17:58:44.7590718+05:30",
    "PartDescription": "sample string 7",
    "PartCode": "sample string 8",
    "Photograph": "sample string 9",
    "L1RCA": "sample string 10",
    "ConcernedAcknowledgement": true,
    "IsNew": true,
    "ORCStatus": "sample string 11",
    "ResponsibleSectionId": 1,
    "ResponsibleSectionName": "sample string 12",
    "SubGroupId": 1,
    "SubGroupName": "sample string 13",
    "ResponsibleSectionLeadId": 1,
    "UserName": "sample string 14",
    "CategoryId": 1,
    "CategoryName": "sample string 15",
    "ScoreMatrix": 1,
    "ScoreMatrixName": "sample string 16",
    "Severity": 1,
    "Probability": 1,
    "Detection": 1,
    "DetectionName": "sample string 17",
    "RPN": 1,
    "AgingSinceReported": "sample string 18",
    "Aging": 1,
    "RelevantDoc": "sample string 19",
    "FinalRCA": "sample string 20",
    "InterimAction": "sample string 21",
    "PermanentAction": "sample string 22",
    "TargetDate": "2024-11-26T17:58:44.7590718+05:30",
    "IsDeleted": true,
    "IsArchived": true,
    "CreatedBy": 1,
    "CreatedDate": "2024-11-26T17:58:44.7590718+05:30",
    "ModifiedBy": 1,
    "ModifiedDate": "2024-11-26T17:58:44.7590718+05:30",
    "DeletedBy": 1,
    "DeletedDate": "2024-11-26T17:58:44.7590718+05:30",
    "ImagePathRelevant": "sample string 25",
    "ImagePathPhoto": "sample string 26",
    "IsTesting": true
  }
]

application/xml, text/xml

Sample:

<ArrayOfIssuesVM xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Sonalika_Api.CustomViewModel.IssuesVM">
  <IssuesVM>
    <Aging>1</Aging>
    <AgingSinceReported>sample string 18</AgingSinceReported>
    <CategoryId>1</CategoryId>
    <CategoryName>sample string 15</CategoryName>
    <ConcernedAcknowledgement>true</ConcernedAcknowledgement>
    <Config>sample string 4</Config>
    <CreatedBy>1</CreatedBy>
    <CreatedDate>2024-11-26T17:58:44.7590718+05:30</CreatedDate>
    <DeletedBy>1</DeletedBy>
    <DeletedDate>2024-11-26T17:58:44.7590718+05:30</DeletedDate>
    <Detection>1</Detection>
    <DetectionName>sample string 17</DetectionName>
    <FailureHours>1</FailureHours>
    <FinalRCA>sample string 20</FinalRCA>
    <HoursAfterUpdation>1</HoursAfterUpdation>
    <ImagePathPhoto>sample string 26</ImagePathPhoto>
    <ImagePathRelevant>sample string 25</ImagePathRelevant>
    <Implement>sample string 6</Implement>
    <InterimAction>sample string 21</InterimAction>
    <IsArchived>true</IsArchived>
    <IsDeleted>true</IsDeleted>
    <IsNew>true</IsNew>
    <IsTesting>true</IsTesting>
    <IssueDescription>sample string 5</IssueDescription>
    <IssueId>1</IssueId>
    <IssueReportingDate>2024-11-26T17:58:44.7590718+05:30</IssueReportingDate>
    <L1RCA>sample string 10</L1RCA>
    <ModifiedBy>1</ModifiedBy>
    <ModifiedDate>2024-11-26T17:58:44.7590718+05:30</ModifiedDate>
    <ORCStatus>sample string 11</ORCStatus>
    <PartCode>sample string 8</PartCode>
    <PartDescription>sample string 7</PartDescription>
    <PermanentAction>sample string 22</PermanentAction>
    <Photograph>sample string 9</Photograph>
    <Probability>1</Probability>
    <ProjectCode>sample string 2</ProjectCode>
    <ProjectId>1</ProjectId>
    <ProjectName>sample string 1</ProjectName>
    <RPN>1</RPN>
    <RelevantDoc>sample string 19</RelevantDoc>
    <ResponsibleSectionId>1</ResponsibleSectionId>
    <ResponsibleSectionLeadId>1</ResponsibleSectionLeadId>
    <ResponsibleSectionName>sample string 12</ResponsibleSectionName>
    <ScoreMatrix>1</ScoreMatrix>
    <ScoreMatrixName>sample string 16</ScoreMatrixName>
    <Severity>1</Severity>
    <SubGroupId>1</SubGroupId>
    <SubGroupName>sample string 13</SubGroupName>
    <TargetDate>2024-11-26T17:58:44.7590718+05:30</TargetDate>
    <TractorId>1</TractorId>
    <TractorNumber>sample string 3</TractorNumber>
    <UpdationHours>1</UpdationHours>
    <UserName>sample string 14</UserName>
  </IssuesVM>
  <IssuesVM>
    <Aging>1</Aging>
    <AgingSinceReported>sample string 18</AgingSinceReported>
    <CategoryId>1</CategoryId>
    <CategoryName>sample string 15</CategoryName>
    <ConcernedAcknowledgement>true</ConcernedAcknowledgement>
    <Config>sample string 4</Config>
    <CreatedBy>1</CreatedBy>
    <CreatedDate>2024-11-26T17:58:44.7590718+05:30</CreatedDate>
    <DeletedBy>1</DeletedBy>
    <DeletedDate>2024-11-26T17:58:44.7590718+05:30</DeletedDate>
    <Detection>1</Detection>
    <DetectionName>sample string 17</DetectionName>
    <FailureHours>1</FailureHours>
    <FinalRCA>sample string 20</FinalRCA>
    <HoursAfterUpdation>1</HoursAfterUpdation>
    <ImagePathPhoto>sample string 26</ImagePathPhoto>
    <ImagePathRelevant>sample string 25</ImagePathRelevant>
    <Implement>sample string 6</Implement>
    <InterimAction>sample string 21</InterimAction>
    <IsArchived>true</IsArchived>
    <IsDeleted>true</IsDeleted>
    <IsNew>true</IsNew>
    <IsTesting>true</IsTesting>
    <IssueDescription>sample string 5</IssueDescription>
    <IssueId>1</IssueId>
    <IssueReportingDate>2024-11-26T17:58:44.7590718+05:30</IssueReportingDate>
    <L1RCA>sample string 10</L1RCA>
    <ModifiedBy>1</ModifiedBy>
    <ModifiedDate>2024-11-26T17:58:44.7590718+05:30</ModifiedDate>
    <ORCStatus>sample string 11</ORCStatus>
    <PartCode>sample string 8</PartCode>
    <PartDescription>sample string 7</PartDescription>
    <PermanentAction>sample string 22</PermanentAction>
    <Photograph>sample string 9</Photograph>
    <Probability>1</Probability>
    <ProjectCode>sample string 2</ProjectCode>
    <ProjectId>1</ProjectId>
    <ProjectName>sample string 1</ProjectName>
    <RPN>1</RPN>
    <RelevantDoc>sample string 19</RelevantDoc>
    <ResponsibleSectionId>1</ResponsibleSectionId>
    <ResponsibleSectionLeadId>1</ResponsibleSectionLeadId>
    <ResponsibleSectionName>sample string 12</ResponsibleSectionName>
    <ScoreMatrix>1</ScoreMatrix>
    <ScoreMatrixName>sample string 16</ScoreMatrixName>
    <Severity>1</Severity>
    <SubGroupId>1</SubGroupId>
    <SubGroupName>sample string 13</SubGroupName>
    <TargetDate>2024-11-26T17:58:44.7590718+05:30</TargetDate>
    <TractorId>1</TractorId>
    <TractorNumber>sample string 3</TractorNumber>
    <UpdationHours>1</UpdationHours>
    <UserName>sample string 14</UserName>
  </IssuesVM>
</ArrayOfIssuesVM>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

HttpResponseMessage

Name	Type	Additional information
Version	Version	None.
Content	HttpContent	None.
StatusCode	HttpStatusCode	None.
ReasonPhrase	string	None.
Headers	Collection of Object	None.
RequestMessage	HttpRequestMessage	None.
IsSuccessStatusCode	boolean	None.