manohar
Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
records to json file
Hi there, I am pulling data from Coupa to store it in json files. its coming in below format. I need to create a JSON file for each record and store it into sftp server with id as file name. input [ { "statusLine": { "protoVersion": "HTTP/1.1", "statusCode": 200, "reasonPhrase": "OK" }, "entity": [ { "id": 41728, "created-at": "2025-04-29T15:26:38-07:00", "updated-at": "2025-04-29T15:35:14-07:00", "po-number": "4501939775" } ], "headers": { "strict-transport-security": "max-age=31536000; includeSubDomains;", "x-content-type-options": "nosniff", "vary": "Accept", "x-runtime": "0.692075" } } ] heres my pipeline with one record. after my union, i get following [ { "fileName": "41728" }, [ { "id": 41728, "created-at": "2025-04-29T15:26:38-07:00", "updated-at": "2025-04-29T15:35:14-07:00", "po-number": "4501939775" } ] ] what I am trying to do is use the id and storing it in filename so I can use that for the file name. but in fact what i want in the file is just below. { "id": 41728, "created-at": "2025-04-29T15:26:38-07:00", "updated-at": "2025-04-29T15:35:14-07:00", "po-number": "4501939775" } how can I achieve that? also how can I get the Id to be the filename.json like in below example, 41728.json Thanks Manohartransform a array
Hi there, need some help transforming the array I have a structure that's coming as below [ { "statusLine": { "protoVersion": "HTTP/1.1", "statusCode": 200, "reasonPhrase": "OK" }, "entity": { "links": [ { "rel": "self" } ], "items": [ { "datetime_beginning_utc": "2023-01-01T00:00:00", "pnode_id": 1269364670, "total_lmp_rt": 25.611892, "marginal_loss_price_rt": 0.132546 }, { "datetime_beginning_utc": "2023-01-01T01:00:00", "pnode_id": 1269364670, "total_lmp_rt": 22.818414, "marginal_loss_price_rt": 0.150509 } ] }, "original": { "priceType": "rt_hrl_lmps", "pnodId": "1269364670", } } ] Need to be transformed as below with only from "items" and "original". Need to combine both while adding "original" to all array elements in "items". Any help is greatly appreciated. Thanks Manohar [ { "datetime_beginning_utc": "2023-01-01T00:00:00", "pnode_id": 1269364670, "total_lmp_rt": 25.611892, "marginal_loss_price_rt": 0.132546, "priceType": "rt_hrl_lmps", "pnodId": "1269364670" }, { "datetime_beginning_utc": "2023-01-01T01:00:00", "pnode_id": 1269364670, "total_lmp_rt": 22.818414, "marginal_loss_price_rt": 0.150509, "priceType": "rt_hrl_lmps", "pnodId": "1269364670" } ]
