{{REST_SERVICES}}/record/v1/vendorbill { "externalId": "01057111", "tranDate": "2024-04-04", "memo": "API Multi PO", "tranId": "01057111", "entity": { "id": 5517 }, "item": { "items": [ { "line": 1, "rate": 37.04, "amount": 37.04, "quantity": 1.00, "location": { "id": 36 }, "item": { "id": 7377 }, "orderDoc": { "id": "138241887" }, "orderLine": 1 }, { "line": 2, "rate": 37.04, "amount": 37.04, "quantity": 1.00, "location": { "id": 36 }, "item": { "id": 7377 }, "orderDoc": { "id": "138241889" }, "orderLine": 1 } ] } } response { "type": "https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1", "title": "Bad Request", "status": 400, "o:errorDetails": [ { "detail": "There are multiple sublist lines with the same identifier. Make sure every line is unique.", "o:errorPath": "item.items[?(@.orderLine==1)]", "o:errorCode": "DUPLICATE_KEYS" } ] }

AI generated answer (using internal Slack threads):

The error message in the prompt indicates that there are multiple sublist lines with the same identifier. In NetSuite, each line in a sublist must have a unique identifier. In this case, the

orderLine

field is being used as the identifier, and there are two lines with the same

orderLine

value of 1. To resolve this issue, you should ensure that each line in the sublist has a unique

orderLine

value. For example, you could increment the

orderLine

value for each new line you add to the sublist. Here is an example of how you could modify the JSON payload to ensure each line has a unique

orderLine

value:

json
{
    "externalId": "01057111",
    "tranDate": "2024-04-04",
    "memo": "API Multi PO",
    "tranId": "01057111",
    "entity": {
        "id": 5517
    },
    "item": {
        "items": [
            {
                "line": 1,
                "rate": 37.04,
                "amount": 37.04,
                "quantity": 1.00,
                "location": {
                    "id": 36
                },
                "item": {
                    "id": 7377
                },
                "orderDoc": {
                    "id": "138241887"
                },
                "orderLine": 1
            },
            {
                "line": 2,
                "rate": 37.04,
                "amount": 37.04,
                "quantity": 1.00,
                "location": {
                    "id": 36
                },
                "item": {
                    "id": 7377
                },
                "orderDoc": {
                    "id": "138241889"
                },
                "orderLine": 2
            }
        ]
    }
}

In this modified payload, the

orderLine

value for the second line has been changed from 1 to 2, ensuring that each line in the sublist has a unique

orderLine

value. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******