Forum Discussion

arvindnsn's avatar
arvindnsn
Contributor
7 years ago
Solved

How to create multiple hierarchy sets in for API output

Hello, I am having issues structuring the API output i am working in. I have attached both the Source data and the JSON output structure expected in the attachment. I have attached the source file ...
  • koryknick's avatar
    koryknick
    4 years ago

    It’s the newline character in the string that is causing the issue. The dot notation for character matching in regex does not match newlines. After a bit of thought, we can also simplify the result by using the regex group capture syntax. Try this:

    $notes.replaceAll('\n','').replace(/.*#IF:(.{9}).*/g, '$1')
ptaylor's avatar
ptaylor
Employee
6 years ago
Copy LinkReport

Hi. See the attached pipeline:

Community7305_2020_05_08.slp (5.1 KB)

The crux is using an expression like the following. Note that in the filter and first map callback, you can use any of the key prefixes that have numeric suffixes: “Student_ID”, “Student_Name”, or “Age”; I chose “Age” since it’s short.

$.keys()
.filter(k => k.startsWith("Age"))
.map(k => k.substring("Age".length))
.map(i => {"Student_ID": $.get("Student_ID"+i), 
           "Student_Name": $.get("Student_Name"+i), 
           "Age": $.get("Age"+i)})
  • jaybodra's avatar
    jaybodra
    New Contributor III
    7 years ago
    Copy LinkReport

    Hi Jack,

    the best work around to this use json.loads and json.dumps; json.loads(in_doc.get(‘str_json’)). use a mapper with JSON.stringify() to represent JSON as string and then you can use json.loads() in the script.

  • Henchway's avatar
    Henchway
    Contributor
    5 years ago
    Copy LinkReport

    Have you ever found a good solution to this besides converting it to a string prior?

    Generally, the proposed method by @jaybodra works, but it seems more like a short-term workaround.
    Additionally, I’m unable to retain the sorting of the dumps after re-loading it, even when telling it to do so specifically. So this only leaves the option of entering a string and passing out a string and then using JSON.parse(), then it will actually be an ordered json … 😮

    json_input = json.loads(inDoc.get('content'))
json_string = json.dumps(json_input, sort_keys=True)
json_output = json.loads(json_string, object_pairs_hook=OrderedDict)

    Best regards
    Thomas