This example used the deprecated “JSON Path“ and will be updated soon.

Queries the Confluence search API to find all content created by a specific user.

Datasource Type

REST Basic

Datasource URL

<URL where Confluence is running>/rest/api
CODE

Datasource User

An existing (technical) Confluence user

Datasource Password

Password of the (technical) Confluence user

Query URL

/content/search?cql=creator=:creator
CODE

Parameter Values

Usernames of existing Confluence users

Query JSON Path

$.results
CODE

Converter Example

function convert(json) {
    var result = [];
    var parsedJsonObject = JSON.parse(json);
    var current, index;
    for (index in parsedJsonObject) {
        if (parsedJsonObject.hasOwnProperty(index)) {
            current = parsedJsonObject[index];
            result.push({
                'Title': current.title,
                'Page ID': current.id,
                'Content Type': current.type
            });
        }
    }
    return result;
}
JS