Search and Read Records from the NetSuite Server

This example pipeline demonstrates how to search and read records from NetSuite server using Record ID.

  1. Configure the NetSuite REST Search Snap as follows:
    • Record type: customer.
    • Search filter: companyname CONTAIN "Snaplogic".
    • Pages with 1 to read a single pages from the NetSuite Server.
    • Pages size with 100 to retrieve 100 records per page.

    On validation, the Snap displays the customer record IDs that match the specified criteria.

    NetSuite REST Search Snap Configuration NetSuite REST Search Snap Output

    NetSuite REST Search Snap Configuration


    NetSuite Search Execute Snap Output

  2. Configure the NetSuite REST Read Snap as follows:
    • Record type: customer.
    • Internal ID (expression-enabled): $id to automatically input the Internal ID fetched from the Upstream Snap.
    • Output fields: companyName, email, entityId.

    On validation, the Snap displays the customer records based on the specifed Record ID.

    NetSuite REST Read Snap Configuration NetSuite REST Read Snap Output

    NetSuite REST Read Snap Configuration


    NetSuite Read Snap Output

  3. You can configure the Mapper Snap to transform data for further use.

    On validation, the Snap displays the output based on the specified mappings. On running the pipeline, the Snap fetches the records associated with the specified Internal ID from NetSuite.

To successfully reuse pipelines:
  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.