Forum Discussion

manohar's avatar
manohar
Contributor
3 years ago
Solved

To fix the pipeline to convert to array

Hi there, I have the following JSON [ { "POSEX":"00010", "E1EDPT1": [ { "E1EDPT2": [ { "@SEGMENT": "1", "TDLINE": "KIT,HIGH SPEED PINION...
pipeline
  • Abhishek_Soni37's avatar
    Abhishek_Soni37
    3 years ago

    I created this expression that supports both object and array if that’s how the external system is sending data to Snaplogic. This will work, give it a try. You can do a little fine-tuning to this.

    Let me know if this works.
    toArray_2023_05_29 (1).slp (7.4 KB)

    Cheers,

Abhishek_Soni37's avatar
Abhishek_Soni37
Contributor
3 years ago
Copy LinkReport

I created this expression that supports both object and array if that’s how the external system is sending data to Snaplogic. This will work, give it a try. You can do a little fine-tuning to this.

Let me know if this works.
toArray_2023_05_29 (1).slp (7.4 KB)

Cheers,

  • manohar's avatar
    manohar
    Contributor
    3 years ago
    Copy LinkReport

    hi thanks @Soni37,

    Works like perfectly except for one thing, I need to add 2 static elements along with the text, I tried a few ways but was not able to add to it. can you point out on how to add that?

    “type”:“AttachmentText”,
    “intent”:“Supplier”,

    [
  {
    "LINES": [
      {
        "POSEX": "00010",
        "attachments": [
          {
          	"type":"AttachmentText",
          	"intent":"Supplier",
            "text": "KIT,HIGH SPEED PINION (HSP),,<br/>"
          },
          {
            "type":"AttachmentText",
          	"intent":"Supplier",
            "text": "*NSK bearings ,STF*"
          }
        ]
      },
      {
        "POSEX": "00020",
        "attachments": [
          {
            "type":"AttachmentText",
          	"intent":"Supplier",
            "text": ",<br/>,MATERIAL DESCRIPTION :REVERSING"
          }
        ]
      }
    ]
  }
]

    Thank you again for your help.