Data / Create item links

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 create item links. An item link is a link between one of your items and one of your partner's items on the same table. It enables you, while collecting data, to easily retrieve the previously linked item and create a suggestion on it, even if its identifiers change.

Task name:

Examples

JSON input

{
    "name": "data-item-link-create",
    "taskReferenceName": "create_item_link",
    "description": "Create item links",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "request": {
            "method": "INLINE",
            "contentType": "application/json",
            "model": "default",
            "json": {
                "operations": [
                    {
                        "key": "a",
                        "element": {
                            "fromItemId": "90684",
                            "toItemId": "90688"
                        }
                    }
                ]
            }
        }
    }
}

XML input

{
    "name": "data-item-link-create",
    "taskReferenceName": "create_item_link",
    "description": "Create item links",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "request": {
            "method": "ATTACHMENT",
            "contentType": "application/xml",
            "model": "default",
            "file": "@my-request.xml"
        }
    }
}

Definition

Property	Type	Required	Description
			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

Property	Type	Required	Description
			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.
			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.
			The request body as a JSON object.
			See below
			A unique key to identify the element in the batch. This key will be associated to the element in the output.
			The element to create or update. See examples below
			Some element may require additional context to be created or updated.
			The request body as a file.
			The outputs of the request. 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.

contentType=application/json

• The expected elements are the entities described in the Product-Live API.
• See examples below for more details.

One element

{
    "operations": [
        {
            "key": "a",
            "element": {
                "...": "..."
            }
        }
    ]
}

Multiple elements

{
    "operations": [
        {
            "key": "a",
            "element": {
                  "...": "..."
            }
        }, {
            "key": "b",
            "element": {
              "...": "..."
            }
        }
    ]
}

Item link element properties

Property	Type	Required	Description
			The ID of the source item (typically the supplier's item)
			The ID of the target item (typically the retailer's item)

contentType=application/xml

• This XML representation follow the one used by the JSON query language of the Product-Live API.
• The expected elements are the entities described in the Product-Live API.
• See examples below for more details.

One element

<?xml version="1.0" encoding="UTF-8"?>
<map xmlns="http://www.w3.org/2005/xpath-functions">
  <array key="operations">
    <map>
      <string key="key">a</string>
      <map key="context"></map>
      <map key="element">
        <string key="...">...</string>
      </map>
    </map>
  </array>
</map>

Outputs

Property	Type	Description
		An object containing the outputs of the task. Each output key is the key of the output defined in the outputs[][outputKey] input parameter.

Example

If your input parameters is as follows:

{
    "...": "...",
    "outputs": [
        {
            "mediaType": "application/json", 
            "outputMode": "INLINE", 
            "outputKey": "json_inline"
        },        
        {
            "mediaType": "application/xml", 
            "outputMode": "ATTACHMENT", 
            "outputKey": "xml_attachment"
        }
    ]
}

The output will be as follows:

{
    "outputs": {
        "json_inline": {
            "...": "...",
            "...": "..."
        },
        "xml_attachment": {
            "url": "..."
        }
    }
}

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

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

Example output:

[
    {
        "key": "a",
        "response": {
            "object": "item-link",
            "id": "88",
            "updatedAt": "2024-07-17T15:42:11.000Z",
            "createdAt": "2024-07-17T15:42:11.000Z",
            "fromItemId": "90684",
            "toItemId": "90688"
        }
    }
]

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

Example output:

<?xml version="1.0" encoding="UTF-8"?>
<array xmlns="http://www.w3.org/2005/xpath-functions">
    <map>
        <string key="key">a</string>
        <map key="response">
            <string key="object">item-link</string>
            <string key="id">88</string>
            <string key="updatedAt">2024-07-17T15:42:11.000Z</string>
            <string key="createdAt">2024-07-17T15:42:11.000Z</string>
            <string key="fromItemId">90684</string>
            <string key="toItemId">90688</string>
        </map>
    </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.

• The creation of item links is limited to 50 requests per minute.

Additional examples

Create a single item link - XML input & output

job.json

{
    "name": "data-item-link-create",
    "taskReferenceName": "create_item_link",
    "description": "Create a single item link",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "request": {
            "method": "ATTACHMENT",
            "contentType": "application/xml",
            "model": "default",
            "file": "@my-request.xml"
        },
        "outputs": [
            {
                "mediaType": "application/xml",
                "outputMode": "ATTACHMENT",
                "outputKey": "xml"
            }
        ]
    }
}

my-request.xml

<?xml version="1.1" encoding="UTF-8"?>
<map xmlns="http://www.w3.org/2005/xpath-functions">
    <array key="operations">
        <map>
            <string key="key">a</string>
            <map key="element">
                <string key="fromItemId">90684</string>
                <string key="toItemId">90688</string>
            </map>
        </map>
    </array>
</map>

Create many item links - XML input & output

job.json

{
    "name": "data-item-link-create",
    "taskReferenceName": "create_item_links",
    "description": "Create many item links",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "request": {
            "method": "ATTACHMENT",
            "contentType": "application/xml",
            "model": "default",
            "file": "@my-request.xml"
        },
        "outputs": [
            {
                "mediaType": "application/xml",
                "outputMode": "ATTACHMENT",
                "outputKey": "xml"
            }
        ]
    }
}

my-request.xml

<?xml version="1.1" encoding="UTF-8"?>
<map xmlns="http://www.w3.org/2005/xpath-functions">
    <array key="operations">
        <map>
            <string key="key">a</string>
            <map key="element">
                <string key="fromItemId">90684</string>
                <string key="toItemId">90688</string>
            </map>
        </map>
        <map>
            <string key="key">b</string>
            <map key="element">
                <string key="fromItemId">90685</string>
                <string key="toItemId">90689</string>
            </map>
        </map>
    </array>
</map>

Create a single item link - JSON input & output

job.json

{
    "name": "data-item-link-create",
    "taskReferenceName": "create_item_link",
    "description": "Create a single item link",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "request": {
            "method": "ATTACHMENT",
            "contentType": "application/json",
            "model": "default",
            "file": "@my-request.json"
        },
        "outputs": [
            {
                "mediaType": "application/json",
                "outputMode": "ATTACHMENT",
                "outputKey": "json"
            }
        ]
    }
}

my-request.json

{
    "operations": [
        {
            "key": "a",
            "element": {
                "fromItemId": "90684",
                "toItemId": "90688"
            }
        }
    ]
}

Create many item links - JSON input & output

job.json

{
    "name": "data-item-link-create",
    "taskReferenceName": "create_item_links",
    "description": "Create many item links",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "request": {
            "method": "ATTACHMENT",
            "contentType": "application/json",
            "model": "default",
            "file": "@my-request.json"
        },
        "outputs": [
            {
                "mediaType": "application/json",
                "outputMode": "ATTACHMENT",
                "outputKey": "json"
            }
        ]
    }
}

my-request.json

{
    "operations": [
        {
            "key": "a",
            "element": {
                "fromItemId": "90684",
                "toItemId": "90688"
            }
        },
        {
            "key": "b",
            "element": {
                "fromItemId": "90685",
                "toItemId": "90689"
            }
        }
    ]
}

Create item link with inline JSON

job.json

{
    "name": "data-item-link-create",
    "taskReferenceName": "create_item_link",
    "description": "Create item link with inline JSON",
    "type": "SUB_WORKFLOW",
    "optional": false,
    "inputParameters": {
        "failOnError": true,
        "request": {
            "method": "INLINE",
            "contentType": "application/json",
            "model": "default",
            "json": {
                "operations": [
                    {
                        "key": "a",
                        "element": {
                            "fromItemId": "${create_item_on_supplier_side.output.json[0].response.id}",
                            "toItemId": "${create_item_on_retailer_side.output.json[0].response.id}"
                        }
                    }
                ]
            }
        }
    }
}