<p style="color:green"> <b> Any report can be generated over a date range. API support few in-built date ranges. StartDate and EndDate elements are ignored if user select built-in durations. It also provides flexibility to provide user's custom dates. In such scenario StartDate and EndDate elements are mandatory.</b></p> <p style="color:green"> <b> This element provides scheduling mechanism while creating a report template. User should specify API in-built frequency. DayOfMonth or day of week should be provided when specific day of month or week is selected respectively. Else it is ignored. A end date can be specified to stop recurrence of report generation. For say user provides: <br /> "schedule": { <br /> "frequency": "SPECIFIC_DAY_OF_MONTH", <br /> "dayOfTheMonth": "1" <br /> "endDate": ""2030-10-30" <br /> } <br /> This means the report will be triggered on 1st of every month till 30th of October 2030. </b></p> <p style="color:green"> <b> This element provides filtering mechanism while generating a report. User specified Columns will be filtered based on provided Operator element in the generated report. <br /> For say user provides: <br /> "filters": [{ <br /> "column": { <br /> "columnName": "RATE_PLAN", <br /> "value": "AER_10GB_PLAN" <br /> }, <br /> "operator": "EQUALS" <br /> }] <br /> <br /> This means the generated report will only have AER_10GB_PLAN rateplan details.</b></p> <p style="color:green"> <b> This element provides sorting mechanism while generating a report. User specified Columns will be sorted based on provided SortOrder element in the generated report. <br /> For say user provides: <br /> "sortBy": [{ <br /> "columnName": "STATUS", <br /> "order": "ASC" <br /> }] <br /> This means the generated report will be ascending sorted on status column.</b></p> <p style="color:green"> <b> User can select, to be filtered, column names and their values.</b></p>