GET api/rptReportParameterOption/{id}

Return a single value from the ReportParameterOptions table using the primary key as ID.

Request Information

URI Parameters

NameDescriptionTypeAdditional information
id

The ReportParameterOptions Primary Key.

integer

Required

Body Parameters

None.

Response Information

Resource Description

rptReportParameterOptionDb
NameDescriptionTypeAdditional information
OptionsID

integer

None.

OptionsName

string

Required

Max length: 50

OptionsDescription

string

Max length: 600

SQLCode

string

Max length: 2000

OptionsValues

string

Max length: 600

CreatedBy

integer

None.

CreatedDate

date

None.

UpdatedBy

integer

None.

UpdatedDate

date

None.

results

Collection of ValidationResult

None.

Response Formats

application/json, text/json

Sample:
{
  "results": null,
  "OptionsID": 1,
  "OptionsName": "sample string 2",
  "OptionsDescription": "sample string 3",
  "SQLCode": "sample string 4",
  "OptionsValues": "sample string 5",
  "CreatedBy": 6,
  "CreatedDate": "2025-12-06T23:40:53.2486683+00:00",
  "UpdatedBy": 8,
  "UpdatedDate": "2025-12-06T23:40:53.2486683+00:00"
}

application/xml, text/xml

Sample:
<rptReportParameterOptionDb xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Tables">
  <results xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
  <CreatedBy>6</CreatedBy>
  <CreatedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:DateTime>2025-12-06T23:40:53.2486683Z</d2p1:DateTime>
    <d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
  </CreatedDate>
  <OptionsDescription>sample string 3</OptionsDescription>
  <OptionsID>1</OptionsID>
  <OptionsName>sample string 2</OptionsName>
  <OptionsValues>sample string 5</OptionsValues>
  <SQLCode>sample string 4</SQLCode>
  <UpdatedBy>8</UpdatedBy>
  <UpdatedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:DateTime>2025-12-06T23:40:53.2486683Z</d2p1:DateTime>
    <d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
  </UpdatedDate>
</rptReportParameterOptionDb>