| | | |
---|
path | <required> | Path to an array field | Simple form is a dot separated list of field names to reach the specific array field within the JSON string. Reference is: http://goessner.net/articles/JsonPath/ |
fieldPaths | all fields | Paths to fields to be included | Comma separated list of path references to fields (simple or array) to be included. If not specified, all fields for the array element will be included. |
sortPaths | | Paths used to determine sort order | Comma separated list of path references to fields (simple only) to be used to determine how rows will be initially sorted. Note that the JSON specification does not define any specific order of elements. The sort direction is determined by the sortDescending parameter. |
output | html | Output format | Determines how the output is formatted. Use wiki to have the data in the table rendered by the wiki renderer. |
script | macro body | Location of CSV data | If a location of data is specified, the included data will follow the body data. - #filename - Data is read from the file located in confluence home directory/script/filename. Subdirectories can be specified.
- global page template name - Data is read from a global page template. Special note: How to deal with templates on Confluence 4.3 and later.
- space:page template name - Data is read from a space template.
- ^attachment - Data is read from an attachment to the current page.
- page^attachment - Data is read from an attachment to the page name provided.
- space:page^attachment - Data is read from an attachment to the page name provided in the space indicated.
|
url | | URL to CSV data | Specifies the URL of an csv file. If specified, the included data will follow the body and script data. Use of this parameter may be restricted for security reasons. See your administrator for details. |
user | | URL user | User name for URL access via basic authentication. |
password | | URL user password | User password for URL access via basic authentication. |
timeout | | URL connection timeout | Allows setting the wait time for URL access for slower connections. Time in milliseconds. |
encoding | | File encoding | File encoding for an external file if different from the system default handling. Since 4.1.0. Example: UTF-8. More ... |
columns | | Columns to show | Comma separated list of column names or numbers in any order. Defaults to all columns in existing order. Columns are enumerated starting at 1. |
showWiki | false | Show non-formatted version of generated wiki | Use true to show a non-formatted version of the wiki table following the formatted table. This is used to help resolve formating issues. It can also be used to convert CSV to Confluence markup by cut and paste. |
escape | false | Escape special wiki characters | When wiki output is requested (output=wiki), some special characters (like '|', '[', ']', '{', '}') in data may cause undesirable formatting of the table. Use true to allow these special characters to be escaped so that it will not affect the formatting. The default is false so that data that has wiki markup will be handled correctly. |
macros | false | Render wiki markup macros in body | Set to true to render wiki markup macros found in the body prior to processing as JSON. This is useful to run macros from SCRP, CCLI, SQL, or similar that can produce CSV output. |