Forum Discussion

Precy's avatar
Precy
New Contributor
6 years ago

Need help to generate json format as per maximo target requirement

I have an input in below format: which i need to transform into a json structure like below in order to load the asset to maximo, where highlighted ones are part of column list in input file a...
Precy's avatar
Precy
New Contributor
6 years ago

When i tried with below logic i get output as follow:

jsonPath($.mapValues((value, key) => { ALNVALUE: parseFloat(value) || value, ASSETSTTRID:key}), “$*”)

which is not completely correct, i want highlighted assetnum, siteid, classstructureid outside the json path as mentioned in mapper snap.

Seems like i am missing somewhere a bit.