Learning Center

Data / Find comment threads ​

Task in alpha phase

This Data Factory task is in phase. You can contact the Product-Live team at contact@product-live.com if you want more details and get an early access.

This task allows to find comment threads. Comment threads are conversations attached to suggestions, allowing suppliers and retailers to discuss proposed changes before they are applied.

Task name:

Examples ​

json
{
    "name": "data-comment-thread-find",
    "taskReferenceName": "find_comment_threads",
    "description": "Find all comment threads",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "findMode": "ALL",
        "request": {
            "method": "INLINE",
            "contentType": "application/json",
            "model": "default",
            "json": {
                "options": {
                    "limit": 100
                }
            }
        }
    }
}
json
{
    "name": "data-comment-thread-find",
    "taskReferenceName": "find_comment_threads",
    "description": "Find comment threads for a specific suggestion",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "findMode": "REQUEST",
        "request": {
            "method": "INLINE",
            "contentType": "application/json",
            "model": "default",
            "json": {
                "criteria": {
                    "type": "eq",
                    "field": "targetId",
                    "value": "${workflow.input.suggestionId}"
                }
            }
        }
    }
}
json
{
    "name": "data-comment-thread-find",
    "taskReferenceName": "find_comment_threads",
    "description": "Find open comment threads, most recent first",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "findMode": "REQUEST",
        "request": {
            "method": "INLINE",
            "contentType": "application/json",
            "model": "default",
            "json": {
                "criteria": {
                    "type": "eq",
                    "field": "isClosed",
                    "value": false
                },
                "options": {
                    "sort": "createdAt",
                    "sortOrder": "DESC",
                    "limit": 50
                }
            }
        }
    }
}

Definition ​

PropertyTypeRequiredDescription
The name (or type) of the task
The unique name of the task in your job. It is used to reference this task in the workflow.
The functional description of this task in your job.
The type of the task. It must be SUB_WORKFLOW.
:

true: the job continues if there is an error on this task.
false: the job fails.
Input parameters of the task. See below

Inputs Parameters ​

PropertyTypeRequiredDescription
The Product-Live API key
If not provided, an automaticaly generated API key will be used to perform the request on behalf of the current user. If provided, the given API key will be used to perform the request.
ALL: Fetch all elements. REQUEST: Fetch all elements matching certain criteria.
See below
To day, application/json and application/xml are supported.
INLINE: The request body is provided inline in the request object. ATTACHMENT: The request body is provided as an attachment in the request object.

If method == INLINE and contentType == application/json		The request body as a JSON object.
The options of the request. Available options are: limit, sort, sortOrder.
The maximum number of elements to be returned by the task. If not set, the task returns the maximum number of elements available. If the limit property is less than the maximum number of elements that can be returned, the task returns the number of elements specified by the limit property.
The field to sort the elements by.
The order to sort the elements by. Available orders are: ASC, DESC.
The criteria of the request. See examples below

If request.method == ATTACHMENT		The request body as a file.
Default: API. The model/format used in the request. To day, only 'API' is supported.
Default: [{"mediaType": "application/json", "outputMode": "INLINE", "outputKey": "json"}].
The media type of the output. To day, application/json and application/xml are supported.
INLINE: The output is provided inline in the output object. ATTACHMENT: The output is provided as an attachment in the output object. INLINE is only supported for mediaType=application/json
The key of the output.
Either json or xml
Default: DEFAULT. The model/format used in the output. To day, only 'DEFAULT' is supported.

JSON criteria examples ​

json
{
    "criteria": {
        "type": "eq",
        "field": "targetId",
        "value": "45678"
    }
}
json
{
    "criteria": {
        "type": "eq",
        "field": "isClosed",
        "value": false
    }
}
json
{
    "criteria": {
        "type": "eq",
        "field": "isClosed",
        "value": true
    }
}
json
{
    "options": {
        "sort": "createdAt",
        "sortOrder": "DESC",
        "limit": 100
    }
}

XML criteria examples ​

xml
<?xml version="1.0" encoding="UTF-8"?>
<map xmlns="http://www.w3.org/2005/xpath-functions">
    <map key="criteria">
        <string key="field">targetId</string>
        <string key="type">eq</string>
        <string key="value">45678</string>
    </map>
</map>
xml
<?xml version="1.0" encoding="UTF-8"?>
<map xmlns="http://www.w3.org/2005/xpath-functions">
    <map key="options">
        <string key="sort">createdAt</string>
        <string key="sortOrder">desc</string>
        <string key="limit">100</string>
    </map>
</map>

Outputs ​

PropertyTypeDescription
The total number of elements exported by the task
An object containing the result of the task. Each output key is the key of the output defined in the outputs[].outputKey input parameter.

Json output - outputs[].outputMode=INLINE and outputs[].mediaType=application/json ​

  • output.json is an array of objects as defined in the comment threads API.
  • json is the default output key but may be changed by setting the outputKey property.

Example output:

json
[
    {
        "object": "comment_thread",
        "id": "5276",
        "createdAt": "2024-05-17T10:30:00.000Z",
        "updatedAt": "2024-05-17T14:45:00.000Z",
        "targetType": "suggestion",
        "targetId": "45678",
        "isClosed": false,
        "comments": [
            {
                "id": "8901",
                "createdAt": "2024-05-17T10:30:00.000Z",
                "message": "Could you provide more details about this product?",
                "authorName": "Retailer A"
            },
            {
                "id": "8902",
                "createdAt": "2024-05-17T14:45:00.000Z",
                "message": "Here are the additional specifications.",
                "authorName": "Supplier B"
            }
        ]
    }
]

XML output - outputs[].outputMode=ATTACHMENT and outputs[].mediaType=application/xml ​

Example output:

xml
<?xml version="1.0" encoding="UTF-8"?>
<array xmlns="http://www.w3.org/2005/xpath-functions">
    <map>
        <string key="object">comment_thread</string>
        <string key="id">5276</string>
        <string key="createdAt">2024-05-17T10:30:00.000Z</string>
        <string key="updatedAt">2024-05-17T14:45:00.000Z</string>
        <string key="targetType">suggestion</string>
        <string key="targetId">45678</string>
        <boolean key="isClosed">false</boolean>
        <array key="comments">
            <map>
                <string key="id">8901</string>
                <string key="createdAt">2024-05-17T10:30:00.000Z</string>
                <string key="message">Could you provide more details about this product?</string>
                <string key="authorName">Retailer A</string>
            </map>
        </array>
    </map>
</array>

Limits and additional notes ​

  • When the outputMode=INLINE is selected, the maximum number of elements returned by this task is limited to 1000. If more elements are to be returned, the task ends with an error. To export up to the maximum of elements, use the limit input parameter to limit the number of elements return.

Additional examples ​

Find comment thread by ID ​

job.json

json
{
    "name": "data-comment-thread-find",
    "taskReferenceName": "find_comment_thread",
    "description": "Find a specific comment thread by ID",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "findMode": "REQUEST",
        "request": {
            "method": "INLINE",
            "contentType": "application/json",
            "model": "default",
            "json": {
                "criteria": {
                    "type": "eq",
                    "field": "id",
                    "value": "${workflow.input.commentThreadId}"
                }
            }
        }
    }
}

Find comment threads with API key ​

job.json

json
{
    "name": "data-comment-thread-find",
    "taskReferenceName": "find_comment_threads",
    "description": "Find comment threads using an API key",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "apiKey": "${workflow.input.apiKey}",
        "findMode": "ALL",
        "request": {
            "method": "INLINE",
            "contentType": "application/json",
            "model": "default",
            "json": {
                "options": {
                    "sort": "createdAt",
                    "sortOrder": "DESC",
                    "limit": 100
                }
            }
        }
    }
}