mohit3
New Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Convert array into different format.
Hi All, I want to convert an input array to expected array. Can you please suggest. Input Array : "Customfield": [ { "fieldname": "RECTY", "fieldvalue": "S01" }, { "fieldname": "LFDNR", "fieldvalue": "0000004" }, { "fieldname": "ARE4", "fieldvalue": "467Q" }] Expected Array : "Customfield": [ { "fieldname": "RECTY", "fieldvalue": "S01", "fieldname": "LFDNR", "fieldvalue": "0000004", "fieldname": "ARE4", "fieldvalue": "467Q" }] Thanks Mohit2.5KViews0likes2CommentsGetting issue in creating JSON
Need to convert the below source JSON to target JSON Source : “Header”: { “Customfield”: { “ABPER”:“202303”, “ABKRS”:“SL” } } Target : “Header”: { “Customfield”: { “fieldname” :“ABPER”, “fieldvalue” : “202303” }, { “fieldname” :“ABKRS”, “fieldvalue” : “SL” } } @dmiller @rsramkoski can you please in converting the json to the above given format.Re: Generating wrong Json format for empty values
@djsiegel I am not using the pass through. I am just mapping the fields in mapper snap and then sending it to Json formatter snap to generate the Json but it is only showing single quotation mark for empty values. I tried your expression as well but it is also not working.4.1KViews0likes0CommentsGenerating wrong Json format for empty values
Hi All, I am creating a Json file by using the Json formatter but I am not getting the json in correct format for all the empty values. Below is the input for Json Formatter : Getting below output from Json Formatter. The output should look like below. Empty fields should be enclosed in double codes. “Bankgroup” : “”, “BankNumber” : “”, Please let me know how we can achieve this. @dmiller Thanks Mohit5.5KViews0likes5Comments