This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

```{
    "type": "<https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1>",
    "title": "Bad Request",
    "status": 400,
    "o:errorDetails": [
        {
            "detail":"Error while accessing a resource. You have entered an Invalid Field Value 104691110469121138415 for the following field: custrecord_allowed_blanks.",
            "o:errorCode": "USER_ERROR"
        }
    ]
}```
Is it possible to tell which item from the sublist is the bad guy?

the one that has Invalid Field Value 104691110469121138415

Inside the loop that is setting the line value do a log for the index and the value and you will see which line(index) is trying to set that value...
But this looks like a request to an external system maybe and the payload having an invalid value? maybe?

```PATCH /services/rest/record/v1/customrecord_property/2062?replace=custrecord_allowed_blanks HTTP/1.1

{
	"custrecord_allowed_blanks": {
		"items": [ { "id": "1046911" }, { "id": 1046912 }, { "id": 1138415 } ]
	}
}```

the problem is one of those object is inactive in netsuite so the whole thing fails

i just have no way of knowing WHICH is the offender

Ohh you are using the new RESTful API….
Well no ideal and no a solution for the long run but you could know by removing one of the values and you would know in a max of 3 tries…

You can go to that custom property record, open up the console and do the following for each ID you are questioning and see which one doesn't set:

nlapiSetFieldValue('customrecord_allowed_banks', 1046911);

sooo i'm trying to set thousands of custom records with a sublist of thousands of items

The docs mention an "errorPath" in the response

• o:errorPath (optional) – a machine-readable JSON path that points to the request body where the error occurred.

<https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_156570709583.html>

Im guessing this is actually a multiselect field, not a sublist

which means your ids should be separated by a `|`

it wont tell you which one is wrong, but it should be more helpful than one massive number

but it's the WHOLE list (equal to the one i submitted)

you would probably want to generate a list of all the valid values for the field beforehand

which hopefully is only a search/query on isinactive

yeah, we started down that route yesterday