...
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 and or String datatypes datatype: For Contains criteria operator use STR_CONTAINS, For in operator use STR_IN, For Equals operator use STR_EQUALS.
If filterId is Date datatypesdatatype: 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 datatypesdatatype: 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.
...