Forum Discussion

jfpelletier's avatar
jfpelletier
Contributor
2 years ago
Solved

Unexpected error with JSON generator

Hello! I'm new to this board and SnapLogic in general, so this should be an easy one to resolve... 🙂 I'm creating a very simple pipeline where I use a HTTP client to read a list of ongoing, "live"...
  • Aleksandar_A's avatar
    Aleksandar_A
    3 years ago

    Hi @arvindnsn,

    You can try to filter out documents that have “error” keys, and later on to split them using JSON Splitter Snap.

    $result.filter(x => x.hasPath("error"))

    Let me know if this helps you.

    BR,
    Aleksandar.

JensDeveloper's avatar
JensDeveloper
Contributor II
3 years ago
Copy LinkReport

Hi @Thom

I see that when its null it’s always an object with two properties and when it has a value its type is a string. So I created a pipeline that checks which type it is and based on that it gets the value or puts null as the value. The pipeline below:
Soap_format_2023_06_22.slp (4.6 KB)

Let me know if it helps

Jens

Thom's avatar
Thom
New Contributor II
3 years ago
Copy LinkReport

Thanks for this example. I was envisioning something that iterated through all the fields in the document and converting these objects to null. Do you believe that to be possible?
Any number of fields could be null and that could be different in each document being processed.
Thanks again.