Hey, when I try to join the

item

table with the

classification

table I get

{
  "detail": "Invalid search query. Detailed unprocessed description follows. Invalid search type: class.",
  "o:errorCode": "INVALID_PARAMETER",
  "o:errorQueryParam": "q"
}

Are there some permissions I am missing or what I’m trying to do is not possible? How can I join the item with it’s class to get the class name?

Share your query. Assuming it was a straight suiteql query and not a rest-based one? They work differently

The query is

SELECT
i.itemId,
c.id
FROM item as i
LEFT JOIN classification AS c ON i.class = c.id
WHERE i.itemId = 'sku'

returns the error shared above when run via HTTP Post to

/services/rest/query/v1/suiteql

The query is valid, so it's probably a permission issue

I suspected that, thank you! Would anyone here by any chance know what’s the permission for that?

List - Classes

and

Lists - Items

, see: https://timdietrich.me/blog/netsuite-suiteql-tables-permissions-reference/

FYI you can see check permissions in the Records Catalog

Ahh great thanks!!