Get Parameters "HasOutstandingDependencies"

Get Parameters "HasOutstandingDependencies"

Posted by: andy.beaulieu on 19 November 2018, 4:43 pm EST

• 

  andy.beaulieu

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 November 2018, 4:43 pm EST

  I would like to get all of the Parameters for a Report including the AvailableValues.

  So, I call the REST method /api/reports/{id}/parameters

  However, some of the Parameters come back with State=“HasOutstandingDependencies” (since they are dependent on some of the other parameters in their DataSource).

  How can I get all of the Parameters with AvailableValues for a Report? Is there any way to request Parameters and pass in the dependent parameter values?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 20 November 2018, 2:31 am EST

  Hello,

  You can use the “POST” command (/api/reports/{id}/parameters/validateValues) to get report parameter after passing the required parameter value like below:

  [
  
  {
  
  “Name”: “ReportParameter”,
  
  “Domain”: “SpecifiedValues”,
  
  “Values”: [
  
  “Rock”
  
  ]
  
  },

  {
  
  “Name”: “ReportParameter1”,
  
  “Domain”: “SpecifiedValues”,
  
  “Values”: [
  
  “Accept”
  
  ]
  
  }
  
  ]

  Also, you can refer to the following link:
  
  http://help.grapecity.com/activereports/webhelp/AR12ServerAPI/index.html#!/reports/post_api_reports_id_parameters_validateValues

  Hope it helps.

  Thanks

• 

  andy.beaulieu

  • Post Options:
  • Link
    Copy

  Posted 20 November 2018, 11:37 am EST

  Thanks, that was it!