This topic contains 0 replies, has 0 voices, and was last updated by synergydev 7 years, 1 month ago.
-
AuthorPosts
-
synergydev- Contributions: 0
- Level 1
- ☆
I'm in the process of writing a SuiteTalk integration, and I've hit an interesting data transformation issue. In the target system, we have a sort of notes table which has a category column and then the notes column. Data going into that table from NetSuite could be several different fields on a single entity in NetSuite terms, but several records of different categories in our terms.
If I were writing a SQL query, i would use the UNION clause, with the first column being a dynamic column denoting the category and the second column being the actual data field from NetSuite. My ideal would be if I could somehow do a similar thing either as a single saved search, or as one saved search per entity, without having to create any additional fields within NetSuite itself, so that from the SuiteTalk side I can just query the search and pull in the data.
Any idea if something like this is at all possible?? Or if not, is there a way of solving this without hard-coding the category values?
This is a cached copy. Click here to see the original post. -
AuthorPosts
You must be logged in to reply to this topic.