Skip to main content

Configuring Source as Netsuite

Configuring Netsuite as the Source: A Comprehensive Guide 

This guide provides a comprehensive walkthrough for setting up Netsuite as the source. By following these steps, you will be able to configure Netsuite as the source smoothly and efficiently. 

Data Source :

Step 11: :

Choose

·       In the Data Source Typepage, Select the source type as 'API'.API

TStep1.png

Step 82 : Enter 'OracleNow NetSuite' inselect the target name field and select '“Oracle NetSuite'NetSuite” fromas theyour dropdown options.product

TStep2.png

Step 93:

:

·       According toChoose the requirements, pick the Oracle NetSuiteappropriate business object frombased theon availableyour dropdownneeds.

menu.



image.png




Note

:

Note: In casethe event the desired product or business object isn't listedavailable, in the dropdown, usersyou have the option to createselect both'Create aNew' in the product name field. Provide the necessary details for the new product and a newthe business object byyou selectingintend to configure as the source.

Note: Opting for 'Create New' option withinrequires the targetuser nameto dropdownfurnish menu.
all necessary details essential for configuring the API as the source.



Step 104:

:

·       After selecting the business object, all relevant details pertaining to the Oracle NetSuite API corresponding to the chosen business object will populate across the required fields within the API section.

Forfor example, upon selecting 'Customer'Customer Retrieve API (Version: v1) (Method: GET)' as the designated business object, all pertinent information linked to the Oracle NetSuite API specifically tailored for the 'Customer' category will populate within the respective fields (Headers and Pre-request script are populated in this case)


image.png



From the image above, it's evident that the HTTP method is configured as POST,GET, and the API endpoint URL field is populated with a value :
























































Please include all the important information about the instance you want to connect to Oracle NetSuite in the API endpoint URL.



Note : In the Headers tab, please observe that the value "{%signature%}" undergoes string interpolation. Avoid making any modifications to this value.




image.png

In
Step body,5: Pagination (Offset Pagination)

This pagination we passwill theapply payloadwhen whichwe createhave "hasMore":true in theour DataAPI operations section.

salesforce 9.png




response.


image.pngimage.png


Select offset pagination from the dropdown and fill these values there.


Oracle NetSuite typically utilizes offset pagination.


image.png






 






    

  • In the above example hasMore key helps to identify upto which page the pagination will be completed , so it will come in User Key
    • 

  • As we are using Offset pagination so Key Name to Update will be offset
    • 

  • Data Collection Key holds the data from the API and we will get the response in that key for example here it is ['items'].
    • 







 






Step 6: Pre-Request Script

In Pre-request Script tab, ensure to input all necessary details including url, oauth_consumer_id, oauth_consumer_key, oauth_consumer_secret, oauth_token, oauth_token_secret.



pre-request scripts


After completing all the required details, the user can establish the connection to Oracle NetSuite.

    
        

    


            

        


        

            
        

    


    


    

    

        

            
    
    
 Back to top