When querying NetSuite by external id, Boomi gives you the option of using the "Any Of" operator. This name implies that you can specify a list of external ids. Does anyone have an example of how to specify a list of ids?
You can pass the ids by using "," as delimiter ....ex: 123,124 . It will return both the documents.
If you want to read from a flatfile. You need to use process property to concatenate each row and then pass that as input to the NS operation.
(let's assume the list of ids are specified in a flat file - one per row)
I found a easier way of doing this, by using search/replace functionality:
For example, if your flatfile has following as input:
the result will be 123,456,786 and this can be passed as input using "current data"
Thanks, that's a good solution. Had to make two small changes to get it to work:
1. Used [\r\n]+ instead of [\r\n] (If the document contains both newline and carriage return, it ends up putting two commas in)
2. Added an additional search/replace step to remove any trailing comma ( replace ,$ with empty string)
Retrieving data ...