GET api/rptReport/expanded/{id}

Return a fully epxanded Report item using the primary key as ID. This will include all parameters and expanded options (if any)

Request Information

URI Parameters

Name	Description	Type	Additional information
id	The Report Primary Key.	integer	Required

Body Parameters

None.

Response Information

Resource Description

rptReportEx

Name	Type	Additional information
CreatedByName	string	None.
ExecCount	integer	None.
Parameters	Collection of rptReportParameterEx	None.
Groups	Collection of secGroupDb	None.
ReportID	integer	None.
SSRSName	string	Required Max length: 50
Name	string	Required Max length: 50
Description	string	None.
CategoryID	integer	Required
ClientCategoryID	integer	None.
VisibleToClient	boolean	None.
IsActive	boolean	None.
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,
  "CreatedByName": "sample string 1",
  "ExecCount": 2,
  "Parameters": [
    {
      "results": null,
      "Options": {
        "results": null,
        "UseCount": 1,
        "SelectOptions": [
          {
            "label": "sample string 1",
            "value": "sample string 2"
          },
          {
            "label": "sample string 1",
            "value": "sample string 2"
          }
        ],
        "OptionsID": 2,
        "OptionsName": "sample string 3",
        "OptionsDescription": "sample string 4",
        "SQLCode": "sample string 5",
        "OptionsValues": "sample string 6",
        "CreatedBy": 7,
        "CreatedDate": "2025-12-06T23:42:54.2789099+00:00",
        "UpdatedBy": 9,
        "UpdatedDate": "2025-12-06T23:42:54.2789099+00:00"
      },
      "ParameterValue": {},
      "ParameterID": 2,
      "ReportID": 3,
      "SSRSName": "sample string 4",
      "Name": "sample string 5",
      "Description": "sample string 6",
      "ParameterTypeID": 7,
      "ParameterSourceID": 8,
      "IsClientID": true,
      "AllowNull": true,
      "DoNotPass": true,
      "ClientOmit": true,
      "OptionsID": 1,
      "DependentOnParameterIDs": "sample string 13",
      "DisplayOrder": 14,
      "CreatedBy": 15,
      "CreatedDate": "2025-12-06T23:42:54.2789099+00:00",
      "UpdatedBy": 17,
      "UpdatedDate": "2025-12-06T23:42:54.2789099+00:00"
    },
    {
      "results": null,
      "Options": {
        "results": null,
        "UseCount": 1,
        "SelectOptions": [
          {
            "label": "sample string 1",
            "value": "sample string 2"
          },
          {
            "label": "sample string 1",
            "value": "sample string 2"
          }
        ],
        "OptionsID": 2,
        "OptionsName": "sample string 3",
        "OptionsDescription": "sample string 4",
        "SQLCode": "sample string 5",
        "OptionsValues": "sample string 6",
        "CreatedBy": 7,
        "CreatedDate": "2025-12-06T23:42:54.2789099+00:00",
        "UpdatedBy": 9,
        "UpdatedDate": "2025-12-06T23:42:54.2789099+00:00"
      },
      "ParameterValue": {},
      "ParameterID": 2,
      "ReportID": 3,
      "SSRSName": "sample string 4",
      "Name": "sample string 5",
      "Description": "sample string 6",
      "ParameterTypeID": 7,
      "ParameterSourceID": 8,
      "IsClientID": true,
      "AllowNull": true,
      "DoNotPass": true,
      "ClientOmit": true,
      "OptionsID": 1,
      "DependentOnParameterIDs": "sample string 13",
      "DisplayOrder": 14,
      "CreatedBy": 15,
      "CreatedDate": "2025-12-06T23:42:54.2789099+00:00",
      "UpdatedBy": 17,
      "UpdatedDate": "2025-12-06T23:42:54.2789099+00:00"
    }
  ],
  "Groups": [
    {
      "results": null,
      "GroupID": 1,
      "GroupName": "sample string 2",
      "GroupTypeID": 64,
      "IsActive": true,
      "IsRestricted": true,
      "IsClientAssignable": true,
      "CreatedBy": 7,
      "CreatedDate": "2025-12-06T23:42:54.2789099+00:00",
      "UpdatedBy": 9,
      "UpdatedDate": "2025-12-06T23:42:54.2789099+00:00",
      "P3PLGroupID": 1
    },
    {
      "results": null,
      "GroupID": 1,
      "GroupName": "sample string 2",
      "GroupTypeID": 64,
      "IsActive": true,
      "IsRestricted": true,
      "IsClientAssignable": true,
      "CreatedBy": 7,
      "CreatedDate": "2025-12-06T23:42:54.2789099+00:00",
      "UpdatedBy": 9,
      "UpdatedDate": "2025-12-06T23:42:54.2789099+00:00",
      "P3PLGroupID": 1
    }
  ],
  "ReportID": 3,
  "SSRSName": "sample string 4",
  "Name": "sample string 5",
  "Description": "sample string 6",
  "CategoryID": 7,
  "ClientCategoryID": 1,
  "VisibleToClient": true,
  "IsActive": true,
  "CreatedBy": 10,
  "CreatedDate": "2025-12-06T23:42:54.2789099+00:00",
  "UpdatedBy": 12,
  "UpdatedDate": "2025-12-06T23:42:54.2789099+00:00"
}

application/xml, text/xml

Sample:

<rptReportEx 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" />
  <CategoryID>7</CategoryID>
  <ClientCategoryID>1</ClientCategoryID>
  <CreatedBy>10</CreatedBy>
  <CreatedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:DateTime>2025-12-06T23:42:54.2789099Z</d2p1:DateTime>
    <d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
  </CreatedDate>
  <Description>sample string 6</Description>
  <IsActive>true</IsActive>
  <Name>sample string 5</Name>
  <ReportID>3</ReportID>
  <SSRSName>sample string 4</SSRSName>
  <UpdatedBy>12</UpdatedBy>
  <UpdatedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:DateTime>2025-12-06T23:42:54.2789099Z</d2p1:DateTime>
    <d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
  </UpdatedDate>
  <VisibleToClient>true</VisibleToClient>
  <CreatedByName>sample string 1</CreatedByName>
  <ExecCount>2</ExecCount>
  <Groups>
    <secGroupDb>
      <results xmlns:d4p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
      <CreatedBy>7</CreatedBy>
      <CreatedDate xmlns:d4p1="http://schemas.datacontract.org/2004/07/System">
        <d4p1:DateTime>2025-12-06T23:42:54.2789099Z</d4p1:DateTime>
        <d4p1:OffsetMinutes>0</d4p1:OffsetMinutes>
      </CreatedDate>
      <GroupID>1</GroupID>
      <GroupName>sample string 2</GroupName>
      <GroupTypeID>64</GroupTypeID>
      <IsActive>true</IsActive>
      <IsClientAssignable>true</IsClientAssignable>
      <IsRestricted>true</IsRestricted>
      <P3PLGroupID>1</P3PLGroupID>
      <UpdatedBy>9</UpdatedBy>
      <UpdatedDate xmlns:d4p1="http://schemas.datacontract.org/2004/07/System">
        <d4p1:DateTime>2025-12-06T23:42:54.2789099Z</d4p1:DateTime>
        <d4p1:OffsetMinutes>0</d4p1:OffsetMinutes>
      </UpdatedDate>
    </secGroupDb>
    <secGroupDb>
      <results xmlns:d4p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
      <CreatedBy>7</CreatedBy>
      <CreatedDate xmlns:d4p1="http://schemas.datacontract.org/2004/07/System">
        <d4p1:DateTime>2025-12-06T23:42:54.2789099Z</d4p1:DateTime>
        <d4p1:OffsetMinutes>0</d4p1:OffsetMinutes>
      </CreatedDate>
      <GroupID>1</GroupID>
      <GroupName>sample string 2</GroupName>
      <GroupTypeID>64</GroupTypeID>
      <IsActive>true</IsActive>
      <IsClientAssignable>true</IsClientAssignable>
      <IsRestricted>true</IsRestricted>
      <P3PLGroupID>1</P3PLGroupID>
      <UpdatedBy>9</UpdatedBy>
      <UpdatedDate xmlns:d4p1="http://schemas.datacontract.org/2004/07/System">
        <d4p1:DateTime>2025-12-06T23:42:54.2789099Z</d4p1:DateTime>
        <d4p1:OffsetMinutes>0</d4p1:OffsetMinutes>
      </UpdatedDate>
    </secGroupDb>
  </Groups>
  <Parameters>
    <rptReportParameterEx>
      <results xmlns:d4p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
      <AllowNull>true</AllowNull>
      <ClientOmit>true</ClientOmit>
      <CreatedBy>15</CreatedBy>
      <CreatedDate xmlns:d4p1="http://schemas.datacontract.org/2004/07/System">
        <d4p1:DateTime>2025-12-06T23:42:54.2789099Z</d4p1:DateTime>
        <d4p1:OffsetMinutes>0</d4p1:OffsetMinutes>
      </CreatedDate>
      <DependentOnParameterIDs>sample string 13</DependentOnParameterIDs>
      <Description>sample string 6</Description>
      <DisplayOrder>14</DisplayOrder>
      <DoNotPass>true</DoNotPass>
      <IsClientID>true</IsClientID>
      <Name>sample string 5</Name>
      <OptionsID>1</OptionsID>
      <ParameterID>2</ParameterID>
      <ParameterSourceID>8</ParameterSourceID>
      <ParameterTypeID>7</ParameterTypeID>
      <ReportID>3</ReportID>
      <SSRSName>sample string 4</SSRSName>
      <UpdatedBy>17</UpdatedBy>
      <UpdatedDate xmlns:d4p1="http://schemas.datacontract.org/2004/07/System">
        <d4p1:DateTime>2025-12-06T23:42:54.2789099Z</d4p1:DateTime>
        <d4p1:OffsetMinutes>0</d4p1:OffsetMinutes>
      </UpdatedDate>
      <Options>
        <results xmlns:d5p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
        <CreatedBy>7</CreatedBy>
        <CreatedDate xmlns:d5p1="http://schemas.datacontract.org/2004/07/System">
          <d5p1:DateTime>2025-12-06T23:42:54.2789099Z</d5p1:DateTime>
          <d5p1:OffsetMinutes>0</d5p1:OffsetMinutes>
        </CreatedDate>
        <OptionsDescription>sample string 4</OptionsDescription>
        <OptionsID>2</OptionsID>
        <OptionsName>sample string 3</OptionsName>
        <OptionsValues>sample string 6</OptionsValues>
        <SQLCode>sample string 5</SQLCode>
        <UpdatedBy>9</UpdatedBy>
        <UpdatedDate xmlns:d5p1="http://schemas.datacontract.org/2004/07/System">
          <d5p1:DateTime>2025-12-06T23:42:54.2789099Z</d5p1:DateTime>
          <d5p1:OffsetMinutes>0</d5p1:OffsetMinutes>
        </UpdatedDate>
        <SelectOptions xmlns:d5p1="http://schemas.datacontract.org/2004/07/WebAPI.Data.Models">
          <d5p1:SelectItem>
            <d5p1:label>sample string 1</d5p1:label>
            <d5p1:value>sample string 2</d5p1:value>
          </d5p1:SelectItem>
          <d5p1:SelectItem>
            <d5p1:label>sample string 1</d5p1:label>
            <d5p1:value>sample string 2</d5p1:value>
          </d5p1:SelectItem>
        </SelectOptions>
        <UseCount>1</UseCount>
      </Options>
      <ParameterValue />
    </rptReportParameterEx>
    <rptReportParameterEx>
      <results xmlns:d4p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
      <AllowNull>true</AllowNull>
      <ClientOmit>true</ClientOmit>
      <CreatedBy>15</CreatedBy>
      <CreatedDate xmlns:d4p1="http://schemas.datacontract.org/2004/07/System">
        <d4p1:DateTime>2025-12-06T23:42:54.2789099Z</d4p1:DateTime>
        <d4p1:OffsetMinutes>0</d4p1:OffsetMinutes>
      </CreatedDate>
      <DependentOnParameterIDs>sample string 13</DependentOnParameterIDs>
      <Description>sample string 6</Description>
      <DisplayOrder>14</DisplayOrder>
      <DoNotPass>true</DoNotPass>
      <IsClientID>true</IsClientID>
      <Name>sample string 5</Name>
      <OptionsID>1</OptionsID>
      <ParameterID>2</ParameterID>
      <ParameterSourceID>8</ParameterSourceID>
      <ParameterTypeID>7</ParameterTypeID>
      <ReportID>3</ReportID>
      <SSRSName>sample string 4</SSRSName>
      <UpdatedBy>17</UpdatedBy>
      <UpdatedDate xmlns:d4p1="http://schemas.datacontract.org/2004/07/System">
        <d4p1:DateTime>2025-12-06T23:42:54.2789099Z</d4p1:DateTime>
        <d4p1:OffsetMinutes>0</d4p1:OffsetMinutes>
      </UpdatedDate>
      <Options>
        <results xmlns:d5p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
        <CreatedBy>7</CreatedBy>
        <CreatedDate xmlns:d5p1="http://schemas.datacontract.org/2004/07/System">
          <d5p1:DateTime>2025-12-06T23:42:54.2789099Z</d5p1:DateTime>
          <d5p1:OffsetMinutes>0</d5p1:OffsetMinutes>
        </CreatedDate>
        <OptionsDescription>sample string 4</OptionsDescription>
        <OptionsID>2</OptionsID>
        <OptionsName>sample string 3</OptionsName>
        <OptionsValues>sample string 6</OptionsValues>
        <SQLCode>sample string 5</SQLCode>
        <UpdatedBy>9</UpdatedBy>
        <UpdatedDate xmlns:d5p1="http://schemas.datacontract.org/2004/07/System">
          <d5p1:DateTime>2025-12-06T23:42:54.2789099Z</d5p1:DateTime>
          <d5p1:OffsetMinutes>0</d5p1:OffsetMinutes>
        </UpdatedDate>
        <SelectOptions xmlns:d5p1="http://schemas.datacontract.org/2004/07/WebAPI.Data.Models">
          <d5p1:SelectItem>
            <d5p1:label>sample string 1</d5p1:label>
            <d5p1:value>sample string 2</d5p1:value>
          </d5p1:SelectItem>
          <d5p1:SelectItem>
            <d5p1:label>sample string 1</d5p1:label>
            <d5p1:value>sample string 2</d5p1:value>
          </d5p1:SelectItem>
        </SelectOptions>
        <UseCount>1</UseCount>
      </Options>
      <ParameterValue />
    </rptReportParameterEx>
  </Parameters>
</rptReportEx>