We are currently using ODBC to retrieve/report data from NetSuite and exploring SuiteTalk to do that (for optimization), right now we have a query of something like this in ODBC, basically the WHERE clause is what I am trying to reproduce via SuiteTalk, particularly the "a_custom_record.a_custom_record_id = vendors.a_custom_record". Do you think this is doable via SuiteTalk or should I have to create two request to get the a_custom_record_id(s) first and then perform another an add those IDs as a filter?

SELECT 
vendors.name, 
vendors.vendor_id, 
vendors.a_custom_record, 
a_custom_record.rec_id 
FROM 
vendors, 
a_custom_record
WHERE
a_custom_record.rec_id IS NOT NULL
AND
vendors.a_custom_record IS NOT NULL
AND
vendors.vendor_type_id = 3
AND
a_custom_record.a_custom_record_id = vendors.a_custom_record

mostly the same limits as a saved search (minus formulas)

thanks, @battk! appreciate the prompt response..

https://system.na0.netsuite.com/app/help/helpcenter.nl?fid=section_N3516862.html#bridgehead_4044945128 if you want to see the documentation about the differences between searches in the ui and soap

Will review that, thanks for the info!

Another option is to create the saved search using the UI in Netsuite and then load the saved search using SuiteTalk so that you don't need to deal with the complexity of crafting the saved search using SuiteTalk. At that point, all your SuiteTalk needs to do is to consume the dataset and process it.

Thanks @Eric B, I was actually reading about that through the article provided by battk, this is very helpful to know! thank you!

With this pattern you can have a generic reusable function that simply loads the saved search and then returns the dataset that can be consumed by other functions depending on the parameters you send to it. Are you writing this in C#?

No, not C#