...
Name | Description | Sample Values |
action | String indicating the action to be executed. RUN_REPORT is the default action value for running Sigma reports. | RUN_REPORT |
reportId | Indicates the Report ID. | sampel0925bccf-29f0-42f2-8896-77c57a-dde-ea2198 |
accessToken | Indicates the access token. | sample61d74837-2e77-4ede-a967-2c84b30-dws-b3b4f 7 |
reportFilter | If filterId is Number or String datatype: For Contains operator use STR_CONTAINS For in operator use STR_IN For Equals operator use STR_EQUALS
If filterId is Date datatype: For Equals Timestamp operator use TDT_EQUALS For Equals operator use TDT_EQUALS_DATE For Financial Year operator use TDT_FINANCIAL_YEAR For Financial Year (w) Quarter operator use TDT_FINANCIAL_YEAR_QUARTER For Greater than operator use TDT_GT For Greater than or Equal to operatoruse TDT_GTEQUALTO For Less than operator use TDT_LT For Less than or Equal to operator use TDT_LTEQUALTO For From operator use TDT_RANGE For Relative Range operator use TDT_RELATIVE_RANGE For YTD operator use TDT_YTD
If filterId is Long datatype: For < operator use NUM_LONG_LT For <= operator use NUM_LONG_LTEQUALTO For != operator use NUM_LONG_NOTEQUALTO For = operator use NUM_LONG_EQUALS For > operator use NUM_LONG_GT For >= operator use NUM_LONG_GTEQUALTO
| | Code Block |
|---|
"reportFilter" : {
"preHookParams":{"NAME":["SIGMA"]},"procedureParams":{"NAME":["SIGMA"]},"additionalParams":{"ADD_INP":["DEMO1"]}, "bindParams":{"NAME":["DEMO1"]}, "filterDef": [{"columnId": "ACCOUNT_TYPE", "filterId": "STR_CONTAINS","filterDataType": "string" ,"filterValues": "savings","filterDescriptions":"savings"}]
} |
|
Note:
In order to obtain the Report ID log-on to Sigma application and right click the report on the left-hand side of the page and click Copy Report ID.
...