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

<@UK8V1Q1FE> I'd suggest using SuiteQL for this

Yes see <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_158394344595.html>

so in sql suite I can post any query to any object?

yes, did you look at the link i posted before?

yes I saw. as per my understanding the same rest api link can be used to call multiple objects by changing the query

correct. and you are not limited to one object per call either. it's a couple thousand rows per response if i recall correctly

Is there any limitation for size/records?

if I say select *
then which 1k will it return?

and also if I want to return latest 1000 for respective table/object?

add an `ORDER BY` to the end of the query

and to get the next x results add `offset=2` etc to the query string

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_157909186990.html>

ok. Is there any way to return all records in single rest api call?

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_156414087576.html>

i personally recommend just reading the entire documentation for rest web services

<https://timdietrich.me/blog/netsuite-suiteql-restlet/>

does it mean to return all records suitescript is the best choice instead of rest api?

I see this will also return max 5000 records

i believe you could add paging to the restlet to get more than 5k results, but depending on how big the result set is, a restlet might run out of governance or time limit as well

What are you actually trying to do? Put everything in a data warehouse? 

yes I am trying to put in my data warehouse