Versions Compared

Version Old Version 3 New Version 4
Changes made by

DevaDarshini.S

DevaDarshini.S

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Name

Description

Sample Values

action

  • String indicating the action to be executed. RUN_REPORT is the default action value for running eMACH-Sigma reports.

  • String indicating the action to be executed. EXEC_REPORT_GROUP is the default action value for generating group reports.

RUN_REPORT,

EXEC_REPORT_GROUP

reportId

  • Indicates the Report ID.

Note

When accessing To access the reports, the Report ID is mandatory, while the Group Report ID is optional.

  • Group Report ID.

Note

To access the report groups, a Group Report ID is mandatory.

  • sampel0925bccf-29f0-42f2-8896-77c57a-dde-ea2198

  • AccountTransaction

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

 }

...