I have been successful in querying a Saved Search from NetSuite but have been unable to get it to a variant data type. That can then be used in a Extract Nested Data component or Flatten Variant component.
After the "saved_search_testing" component runs it dumps the response in to a table with one column of type VARCHAR:
The next step in the job creates a table with 1 column of type Variant. I then push the data from the initial table to the new one:
New table Data:
The tables column “response” is of type Variant but the data dose not look correct:
Any ideas on why this is happening?
