Thanks for reply ptaylor!
I want to get list every vendor, accounts and other Netsuite objects with all possible fields described in object schema. If you are suggesting to use Netsuite search snap then use Get snap to get all the details, then how can I use the Search Snap to return all the records in given object?
With Netsuite Rest API, we can do something like <netsuite_url>/accounts to get all the accounts records by passing an offset value in the URL. I want to do same thing with available Netsuite Snaps.
No, I am suggesting that you first try using just the Search snap without using the Get snap at all. The Search snap has a checkbox setting called “Body Fields Only” that is checked by default. This will omit some details from the response such as certain computed fields and details of child objects. You can uncheck this box to tell the Search to return more details.
Here’s an example of one Vendor from a Search result, with Body Field Only unchecked (left side) and checked (right side). As you can see, the left side includes the balance, the addresses, and the currency details.
To configure a Search to return all of the objects of the given type, you need to give it empty search criteria. The way I do that is with a Mapper to provide the input like this:
So please try that first.
But I have a question. You said:
With Netsuite Rest API, we can do something like <netsuite_url>/accounts to get all the accounts records by passing an offset value in the URL. I want to do same thing with available Netsuite Snaps.
When you say the NetSuite REST API, are you talking about the RESTlet framework? Do you have RESTlets that return the data you want? If so, you should be aware that we have a new NetSuite snap, NetSuite Call RESTlet, that can be used to call RESTlets. It’s not officially released yet, but we’ve given a preview release to a couple of customers.
I’m guessing you are not talking about RESTlets; you are probably talking about NetSuite’s new REST API. That API has been available for less than a year and unfortunately, we don’t directly support it in our NetSuite snaps yet. Our new Call RESTlet snap will only work with RESTlets; it can’t be used to call their REST API. It’s possible that you could call the REST APIs using our REST Get snap, if you can use simple username/password-based authentication. If the REST calls require NetSuite Token Based Authentication (TBA), you would probably need direct support added to our NetSuite pack to enable these endpoints to be called with TBA, since that would be problematic with the REST Get snap.
Yes I am talking about REST web API. As per this document, we have 3 ways to get data.
From above 3, SOAP is used by existing NetSuite Snaps. For RESTlets, you mention that you have unreleased NetSuite RESTLets Snaps. As for REST Web Services, it supports OAuth 2.0 so I think we can use REST Snaps with OAuth 2.0 account to use this feature from NetSuite.
Let me try the method that you suggested which is to use Search Snap with {} to fetch all the records. If that doesn’t work as intended, I will check the REST Snaps with OAuth 2.0. I will let you (@ptaylor) know the results.
