Page Comparison

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 String datatypes:

• For Contains criteria use STR_CONTAINS,

• For in use STR_IN,

• For Equals use STR_EQUALS.

If filterId is Date datatypes:

• For Equals Timestamp use TDT_EQUALS,

• For Equals use TDT_EQUALS_DATE,

• For Financial Year use TDT_FINANCIAL_YEAR,

• For Financial Year (w) Quarter use TDT_FINANCIAL_YEAR_QUARTER,

• For Greater than use TDT_GT,

• For Greater than or Equal to use TDT_GTEQUALTO,

• For Less than use TDT_LT,

• For Less than or Equal to use TDT_LTEQUALTO,

• For From use TDT_RANGE,

• For Relative Range use TDT_RELATIVE_RANGE,

For YTD use TDT_YTD.

If filterId is Long datatypes:

• For < use NUM_LONG_LT,

• For <= use NUM_LONG_LTEQUALTO,

• For != use NUM_LONG_NOTEQUALTO,

• For = use NUM_LONG_EQUALS,

• For > use NUM_LONG_GT,

• For >= use NUM_LONG_GTEQUALTO.

"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"}]        

}