I am trying to request records from netsuite with condition internalID<100 using netsuite connector?
So I will get available record which have internalID less than 100.
How do I provide a condition?
I am able to fetch only 1 record e.g ID=10.
As per my knowledge you need get records based on condition then which condition you want to give that condition you can add filter condition.
Thanks for your effort!!
I am doing the same process but while adding a filter in Operation, I am getting operators as only "Any of" and "None of". I am not getting any comparison operator.
And if I want to provide array of elements as parameter or condition like "all records where savedSearchScriptid > 100", how can we do that?
None of means it will accepts/compare null values. Any of means it will accepts/compare fields.
NS Filter operators are loaded based on the filter field selection. Like InternalID, externalID, or be it Type, etc are limited to to Any Of or None Of. This will fetch the record that matches your condition ID. There is no way you can get records by setting "Get records that are less than this number or value". You can load a document of such values and get all the record details but not by setting in filter like less than and so on.
To fetch a group of records, we usually go by date (could be created, modified, etc). It has operator option of After, Before, etc. You can try this option. After all the technology is evolving
Correct, this is how NetSuite works.
Thanks, I already figured out the solution and yes, this was helpful too
What was your solution Akshay?
Retrieving data ...