This topic contains 0 replies, has 0 voices, and was last updated by synergydev 7 years, 2 months ago.

  • Author
    Posts
  • #22731

    synergydev

    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.

You must be logged in to reply to this topic.