Reporting Json Data Provider macro allows reading of Json data from the attachment file for from the text field. The max number of issues may be specified, but cannot be higher than 1000 items. Data providers in Reporting return data in a form of an array of Json objects - one Json object per each report line. In case of Json Data Provider the data is read as is from the attachment file or from the text field. Then, in Reporting Table Item and Reporting List Item formulas these objects may be accessed via CurrentItem variable.

Reporting Json Data Provider macro has the following parameters:

Parameter Description
[Enum] Data content type (default='Text only')

Specifies, how to process the data, specified in the Json data parameter or the file data, read from the attachment file, which name is specified in the Json data attachment file name parameter - whether it is a plain text or a single formula. This parameter may have one of the following values:

  • Text only
    • Means, that the data will be processed as is. In this case no formulas are searched for in it.
    • Example Json data parameter content: "[{name='name 1'},{name='name 2'},{name='name 3'}]".
  • Single expression
    • Means, that the data is a formula, which should be pre-calculated and its result will be processed afterwards.
[String] Json data root (default=''(Empty value))

Specifies the root element path in the data. This parameter is convenient, when the input data is a result of some REST API call, where is a common case, when an array of Json objects is provided in an element, called 'results' or 'values'.
 [String] Filter (default=''(Empty value))

The formula, which filters out the values when it returns False. Ignored if empty.

Examples:

  • 'FIND("Report", CurrentItem.fields.summary) > 0' - Returns True for the issues with the summary, which contains a 'Report' word. So this formula helps to create a report with the issues, which have 'Report' word in its summary.
[Long] Max results (default=1000) The maximum amount of issues to be returned. This feature is convenient to create the lists of TOP Something, when the amount is limited with this parameter.