25 May’17

OthersRetrieve records from NetSuite on basis of Custom field value


In this blog, we will have a look on how the records can be retrieved from NetSuite on basis of a custom field value.


We had a client with requirement to integrate their NetSuite environment to CRM environment. The integration process from NetSuite basically triggers on the scheduled time set on the server scheduler. One of the entity that gets integrated is “Customer”.

When Customer record is updated in NetSuite, a Boolean field known as “Dirty flag” is set as true in NetSuite.

While integration the records retrieved are based on the Boolean field “Dirty flag”. Only the records which have Dirty flag as true are retrieved.

The code that retrieves the updated records from NetSuite is as follows:

The search is done based on a Boolean custom field. The search value for this field should be set as true.

The above code is to search records from all the pages. The page size mentioned is 5 in the above code. Thus, each page will have maximum of 5 records on one page.


Written by

Krishna Bhanushali

Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Managing mailbox through Email Archiving

    20 March’ 2018

    Introduction: Email can fill your Outlook Inbox quickly – new messages, replies, and forwards. Before you know it, yo...

    Read more
  • Workaround to Report.SAVEASPDF in NAV 2018

    20 March’ 2018

    Objective: In NAV 2017 Emailing the PDF by running the report using Report.SAVEASPDF is now not allowed in NAV 2018. Th...

    Read more
  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more