Use Transformation to extract the key from JSON object to be used in mapping

Josh Davis
  • Edited

I have a data set that I need to transform into journal entries in NetSuite. The "Input" data shows what will become the Journal Lines as separate key:value pairs. I need to break this out so that it shows the summary.key as a line value and the summary.value as another line value.

This is what my input data looks like:

 

And this is what I want the output data to look like:

 

I just cannot figure out how to pull the summary.key and value out to put them in separate lines.

0

Comments

2 comments

Date Votes
  • Scott Henderson CTO
    Celigo University Level 1: Skilled
    Answer Pro
    Top Contributor

    This should be really easy to do with JavaScript.  Is that an option? 

    I have only rarely used the rule based transformation engine.  On a side note, we have a "transformation 2.0" rule based engine being considered for release mid next year, and it will be much more powerful and intuitive than what you have right now in the product.

    0
  • Josh Davis

    Its been a long time since I wrote any JS. I could try to brush up on it and figure it out, but I was hoping to do it with rules. I'll try to figure it out with JS.

    That's good to hear about the upgrade coming to the transformation tool. We've been really happy with the update to the error UI that just came out. Its made fixing issues much easier.

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post