I have to pull list of marital status values from NetSuite. I cannot find the objects from the NetSuite Query Operation.
Any help is greatly appreciated.
Marital Status is not a separate object in NS. These details come along with the Employee object itselt. To access marital status you can query same Employee object, and check only what you required from the response. And ensure to include list fields. Or else you can write a saved search in NetSuite and access them using advanced search.
Screen showing marital status of an employee
Hope this helps!
I have used the above solution and I am getting "Null" in the output.
See the scenario here:
Source system is returning Married, Single as the values.
I have to pull all the marital statuses from NetSuite. Let's say It has Single, Divorced, Separated.
Now i have to compare if Married or Single exists in NetSuite. But before that, I need to get the full list from NS(that is Single, Divorced, Separated).
Is there a way to get the list?
I would suggest you to write a saved search in NS and apply the conditions in saved search it self. Then access the saved search using script ID using advanced search in Boomi. This would return the result set of saved search. Since this is a sub list, simple query may not return expected result.
Retrieving data ...