IPD JSON Converter Node and JSON Builder Node

Legacy Contributor

In an IPA, I have used webrun node to call an API with the results in CSV format.  I used JSON converter node to convert from CSV to JSON.  Now I need to reference the output of the converter and map to a different JSON definition.  How do I reference the output from the converter within the JSON Builder?  My result set from the JSON converter looks like this:

JSONConverter7220_outputData =
[

{
"Description":"New/Unknown Department",
"BusinessGroupCH":"",
"ShortDescription":"00000",
"Active":"true",
"HROrganizationUnit":"40",
"HROrganization":"30",
"UnitType":"DEPARTMENT",
"DivisionCH":"",
"OrgUnitProcessLevelNewCH":"SW-Clinical Integration Netwrk"
},

{
"Description":"ACHF-ADMINISTRATION",
"BusinessGroupCH":"FOUND",
"ShortDescription":"00042",
"Active":"true",
"HROrganizationUnit":"42",
"HROrganization":"30",
"UnitType":"DEPARTMENT",
"DivisionCH":"ACHF",
"OrgUnitProcessLevelNewCH":"ACHF"
},

{
"Description":"SW-Parent Admin",
"BusinessGroupCH":"SUPPORT",
"ShortDescription":"00054",
"Active":"true",
"HROrganizationUnit":"43",
"HROrganization":"30",
"UnitType":"DEPARTMENT",
"DivisionCH":"PPL",
"OrgUnitProcessLevelNewCH":"CORP"
},

The new json format is 

{
"folder": {
"value": "Active Cost Center"
},
"name":"<!JSONConverter7220_outputData>.${.Description.value}",
"externalid":"HROrganizationUnit",
"field36862":"ShortDescription",
"field36857":{
"externalid":"DivisionCH"
},
"field36858":{
"externalid":"BusinessGroupCH"
},
"field36859":{
"externalid":"OrgUnitProcessLevelNewCH"
}
}

I have inserted the new JSON into the builder and tried this path, but it is not working. The output is that exact statement.

"name":"<!JSONConverter7220_outputData>.${.Description.value}"

I also realize i could have set the output on the webrun to JSON, but I am not sure how to reference that output either.

Thanks,

Maggie

andy

Instead of using the JSON converter / builder nodes, you could just use a JS assign node, iterate through the CSV and manually build the needed JSON object. If you don't want to iterate through the CSV in the JS assign node, you could also use a Data Iterator node and a JS assign node inside the iterator to build the JSON object.

Does your resulting output need to be a single JSON object or a JSON array?

Your example JSON output is an array of three JSON objects. Are you trying to consolidate each CSV line into a single JSON object?

You may already be aware, but just in case, JSON values can be accessed / defined using dot or square bracket notation.

For example...

json = { key1 : "ABC", obj1 : { key2 : "GHI" } }

json.key1 will return "ABC"

json["key1"] will also return "ABC"

json.key1 = "DEF" will change the key1 value to "DEF"

json.obj1.key2 will return "GHI"

json["obj1"]["key2"] will also return "GHI"

Note: you may need to create an empty JSON object with all the key values defined before iterating through the CSV and building the output JSON. I seem to recall IPA's flavor of JS doesn't seem to allow setting a JSON key value if the key is not already defined.

{
folder : {value: ""},
name : "",
externalid : "",
field36862 : "",
field36857 : {externalid : ""},
field36858 : {externalid : ""},
field36859 : {externalid : ""}
}