Forum Discussion

ssmith-nova's avatar
ssmith-nova
Contributor
4 days ago
Solved

Pass parameters through Rest API

Hi All, This is probably an easy one, but I am stuck. I have a Dashboard dataset rule that used FDX to run a query.  It takes two input values.  I have a data adapter that calls that BR and I can ...
Data Integration
REST Api
  • JoakimK's avatar
    JoakimK
    3 days ago

    In your original call, {_GetData}{GetDataSet}{ScenarioName=Actual, TimeName = 2024M3} replace the two values with parameter names (the parameters do not need to exist as parameters anywhere else) like this: 

    {_GetData}{GetDataSet}{ScenarioName=|!prm_ScenName!|, TimeName = |!prm_TimeName!|}

    And then in your CustomSubstVarsAsCommaSeparatedPairs simply reference those parameters, like this:
    "CustomSubstVarsAsCommaSeparatedPairs":"prm_ScenName=Budget, prm_TimeName=2025M12"

    Joakim

JoakimK's avatar
JoakimK
Contributor
3 days ago

In your original call, {_GetData}{GetDataSet}{ScenarioName=Actual, TimeName = 2024M3} replace the two values with parameter names (the parameters do not need to exist as parameters anywhere else) like this: 

{_GetData}{GetDataSet}{ScenarioName=|!prm_ScenName!|, TimeName = |!prm_TimeName!|}

And then in your CustomSubstVarsAsCommaSeparatedPairs simply reference those parameters, like this:
"CustomSubstVarsAsCommaSeparatedPairs":"prm_ScenName=Budget, prm_TimeName=2025M12"

Joakim