Mapper 2.0 - Possible to build multiple array elements?

Comments

6 comments

  • Amanjot Singh Group Product Manager
    Engaged
    Answer Pro
    Great Answer
    Celigo University Level 4: Legendary

    Hello Steve,

    Could you add the source field (right side) as"$,$,$" for the destination field n1 [object]?

    This will create 3 tabs as shown below. Go to each tab and configure the 3 objects separately.

    Let me know if this works.

    1
  • Amanjot Singh Group Product Manager
    Engaged
    Answer Pro
    Great Answer
    Celigo University Level 4: Legendary

    Noted. Thank you for sharing feedback. We will get more sessions on Mapper 2.0 in university. 

    1
  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    And this is why I asked for a training session on mapper 2.0 on the University Forum.  

    0
  • Steve Klett Strategic Partner
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Top Contributor
    Awesome Follow-up
    Engaged

    Amanjot! - this is excellent! :)

    This is EXACTLY what I needed and was hoping for. Thank you for the reply, you've helped greatly.

    [EDIT] Just found a great article by Tom Santiago that explains this JSONPath notation!


    BTW, I second Dave's request; it's a powerful tool, but we've failed to adopt it because it's easy to get blocked due to lack of knowledge on how it all works.

    0
  • Kelly Izer Senior Solutions Consultant
    Awesome Follow-up
    Engaged
    Answer Pro
    Top Contributor
    Celigo University Level 4: Legendary

    Steve,

        Glad that worked for you. I just wanted to provide another screenshot to show how the $, $, $ notion looks expanded

    0
  • Steve Klett Strategic Partner
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Top Contributor
    Awesome Follow-up
    Engaged

    Kelly Izer We may be talking about different things. Your screen shot shows nested objects arrays, but I was looking to create multiple elements/records/entriesin the array. Here's a screen shot showing my situation:

     

    Which results in (perfect!):

      "hl_shipment": [
        {
          "n1": [
            {
              "entity_identifier_code_n101": "ST",
              "name_n102": "",
              "identification_code_qualifier_n103": "67",
              "identification_code_n104": "TBD - UPS Warehouse Code"
            },
            {
              "entity_identifier_code_n101": "A",
              "name_n102": "1367655",
              "identification_code_qualifier_n103": "C",
              "identification_code_n104": "D"
            },
            {
              "entity_identifier_code_n101": "E",
              "name_n102": "F",
              "identification_code_qualifier_n103": "G",
              "identification_code_n104": "A"
            }
          ]
        }
      ]
    0

Please sign in to leave a comment.