Jeff Greene
03/29/2025, 8:49 PMCeligo AI
03/29/2025, 8:49 PMAI generated answer (using internal Slack threads):Based on the conversations, it appears that when using the SOAP API to run saved searches, NetSuite indeed returns only the internal ID of fields instead of their names. This is the default behavior and there isn't a direct way to change this to return the names instead of the internal IDs. However, there are a couple of workarounds you can consider: 1. Create a text field that sources the field you want: You can create a new custom field that uses a formula to default to the field you want to get. The formula should simply be a template expression with the script id of your original field inside. Then, have your search get that field instead. This way, you can get the text value of the field instead of the internal ID. 2. Perform another operation to lookup the text: If you have the internal ID, you can perform another operation to lookup the text associated with that ID. This could be another search or using the
getSelectValue
operation.
Remember to ensure that the user or role running the saved search has the necessary permissions to access the fields. If the fields are not returning any values, it could be due to permission issues.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
03/29/2025, 8:49 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838543296
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.836794794
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835970223
Celigo AI
03/29/2025, 8:49 PM