@Alli Deacon Start with

SELECT * FROM item WHERE id = x

to get all the fields for one of those items, and hopefully you can identify the field you are after from the results

Yes, I did that with just

Select * from item

I cannot get

Select * from item where id = x

where x = any of those item ids to return any results. That is my issue, was curious if anyone had run into anything similar.

id

would be the internal id of the item

I understand. I've not been able to get the internal ID to return any results. For example the url for this item is:

<https://realm.app.netsuite.com/app/common/item/item.nl?id=69780>

When I'm doing my search:

{"q": "SELECT * FROM item  where id  = '69780'"}

Which I have done with and without quotes, I'm getting no results. Was curious if anyone had encountered this issue. Is there some other table / record type that might be storing the items that aren't showing in the item record?