@Rishikesh The fastest way that I know of is the SuiteQL https://timdietrich.me/blog/netsuite-suitetalk-rest-suiteql-example/

thanks But when "q":"select Item.id, Item.price from Item" then i am getting {     "type": "https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1",     "title": "Invalid search query Search error occurred: Field 'price' for record 'item' was not found. Reason: UNSUITABLE - Unsupported return field type 'SUBLIST' for channel SEARCH\n.",     "status": 400,     "o:errorCode": "INVALID_PARAMETER" } How can i filtre sublist field

@Rishikesh The query will depend on the type of items you're working with. For example, you would use something like this to get prices for non-inventory items.

SELECT

Item.ID,

Price.PriceLevelName,

Price.Price

FROM

Item

INNER JOIN NonInventoryResaleItemPrice AS Price ON

( Price.Item = Item.ID )

Great working thanks @tdietrich