Ok, thanks. I will start looking at these. My first thought when I started this was to isolate the decoding/conversion.  Then I was hoping to find a solution where I could simply replace the "content"-value from the original file with the decoded/converted value.  But I never got farther than decoding/converting.   ... View more

Ah, ok. My aim is to convert the XML to JSON and insert the converted JSON back into the original main JSON-document in place of the coded value for the content. If you take a look at the test JSON-file in my previous comment, there you will see the base64coded-value.  I am trying to end up with a similar document but in stead of the base64coded-value I want to insert the Json equivalent of the XML-document.   On other words I would like to end up with this: { "header": { "dokumentidentifikator": null, "dokumentidentifikatorV2": "dcff985b-c652-4085-b8f1-45a2f4b6d150", "revisjonsnummer": 1, "dokumentnavn": "Engangsavgiftfastsettelse:1122334455:44BIL1:2017-10-20", "dokumenttype": "SKATTEMELDING_ENGANGSAVGIFT", "dokumenttilstand": "OPPRETTET", "gyldig": true, "gjelderInntektsaar": 2017, "gjelderPeriode": "2017_10", "gjelderPart": { "partsnummer": 5544332211, "identifiseringstype": "MASKINELL", "identifikator": null }, "opphavspart": { "partsnummer": 5544332211, "identifikator": null }, "kildereferanse": { "kildesystem": "ENGANGSAVGIFTFASTSETTELSE", "gruppe": "", "referanse": "aef147fb-8ce8-43ef-833b-7aa3bac1ece0", "tidspunkt": "2018-01-16T13:28:02.49+01:00" } }, "data": { "metadata": { "format": "motorvogn:motorvognavgift:v1", "bytes": 4420, "mimeType": "application/xml", "sha1": "c0AowOsTdNdo6VufeSsZqTphc0Y=" }, "content": "{ "avgiftslinje": { "avgiftsbeloep": 542896.0, "avgiftsopplysning": { "saeravgiftTypekode": "BB", "saeravgiftGruppekode": "X" }, "avgiftsdato": "2017-10-20" }, "betalingsinformasjon": { "kidnummer": 101010101010, "forfallsdato": "2017-10-20", "fakturadato": "2017-10-20", "totalAvgiftsbeloep": 542896.0 }, "motorvognavgiftstype": "engangsavgift", "tidsstempel": "2018-01-16+01:00", "grunnlagForMotorvognavgift": { "kjoeringensArt": 10, "kjoeretoey": { "eierskapRegistrert": "2017-10-20", "foersteRegistreringsaar": 2017, "foersteRegistreringsdatoINorge": "2017-10-20", "kjoeretoeygruppe": 101, "lengde": 3964, "motoreffekt": 96, "slagvolum": 143, "drivstoff": "BENSIN", "egenvekt": 1519, "eier": { "foedselsEllerDnummer": 1122334455, "partsnummer": 5544332211, "navn": "KLARA KU" }, "tillattTotalvekt": 2164, "hybrid": "nei", "co2utslipp": 268, "noxutslipp": 59.4, "kjoeretoeyidentifikator": { "kjoeretoeyUnikIdentifikator": "ABCDEFGHIJ", "kjennemerke": "44BIL1", "understellsnummer": "UNDERSTELL44" } } }, "avgiftspliktig": { "foedselsEllerDnummer": 1122334455, "partsnummer": 5544332211 }, "avgiftskomponent": [ { "komponent": "Co2", "beloep": 475337.2 }, { "komponent": "Egenvekt", "beloep": 60945.64 }, { "komponent": "Motoreffekt", "beloep": 0.0 }, { "komponent": "NOx", "beloep": 4213.24 }, { "komponent": "Slagvolum", "beloep": 0.0 }, { "komponent": "Co2 Fratrekk", "beloep": 0.0 }, { "komponent": "Egenvekt Fratrekk", "beloep": 0.0 }, { "komponent": "Motoreffekt Fratrekk", "beloep": 0.0 }, { "komponent": "NOx Fratrekk", "beloep": 0.0 }, { "komponent": "Slagvolum Fratrekk", "beloep": 0.0 }, { "komponent": "Co2 Sum", "beloep": 475337.2 }, { "komponent": "Egenvekt Sum", "beloep": 60945.64 }, { "komponent": "Motoreffekt Sum", "beloep": 0.0 }, { "komponent": "NOx Sum", "beloep": 4213.24 }, { "komponent": "Slagvolum Sum", "beloep": 0.0 }, { "komponent": "Vrakpant", "beloep": 2400 }, { "komponent": "Bruksfradrag 0%", "beloep": 0.0 } ], "forhaandsberegning": false }" }, "extension": null, "skjemaversjon": "v3_0" } ... View more

Thanks for the quick response @stevenmatison . I am not getting the expected result (yet) in that the XML-code is in my resulting file? I left the EvaluateJson as above. In the UpdateAttribute I set content to:      ${innhold:base64Decode()}     and in the AttributesToJson I did this: The result is a json-fil with one attribute "content", and this attribute contains the whole XML-file. Where did I go wrong here? So the flow now looks like this:   Thanks, bjornmy         ... View more

Thank you for your input @stevenmatison  Below you will find more info, and I have also enclosed a test json-file.   The main source here is JSON-documents, and as mentioned above the value in $.data.content in these files is a base64encoded XML-document.  That is the reason for the ConvertRecord (see below).  If it not had been for this I suspect your suggestion would work fine. The flow that I have made so far is extracting the value from $.data.content, decodes it, converts the XML to JSON and finally stores the JSON-content from this base64-field to S3.  And it's the encoded data in $.data.content in the main document I would like to have replaced with the decoded/coneverted JSON-document, and then store the updated version of the main file in S3.   The EvaluateJsonPath looks like this:     The ReplaceText looks like this:  The Base64EncodeContent looks like this:   and finally the ConvertRecord looks like this: This is what a test json-file would look like.  Here you can see the $.data.content encoded value I need to replace with the corresponding decoded/converted json-value, before writing the updated content to S3:   { "header": { "dokumentidentifikator": null, "dokumentidentifikatorV2": "dcff985b-c652-4085-b8f1-45a2f4b6d150", "revisjonsnummer": 1, "dokumentnavn": "Engangsavgiftfastsettelse:1122334455:44BIL1:2017-10-20", "dokumenttype": "SKATTEMELDING_ENGANGSAVGIFT", "dokumenttilstand": "OPPRETTET", "gyldig": true, "gjelderInntektsaar": 2017, "gjelderPeriode": "2017_10", "gjelderPart": { "partsnummer": 5544332211, "identifiseringstype": "MASKINELL", "identifikator": null }, "opphavspart": { "partsnummer": 5544332211, "identifikator": null }, "kildereferanse": { "kildesystem": "ENGANGSAVGIFTFASTSETTELSE", "gruppe": "", "referanse": "aef147fb-8ce8-43ef-833b-7aa3bac1ece0", "tidspunkt": "2018-01-16T13:28:02.49+01:00" } }, "data": { "metadata": { "format": "motorvogn:motorvognavgift:v1", "bytes": 4420, "mimeType": "application/xml", "sha1": "c0AowOsTdNdo6VufeSsZqTphc0Y=" }, "content": "PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/Pgo8bW90b3J2b2duYXZnaWZ0IHhtbG5zPSJza2U6ZmFzdHNldHRpbmc6bW90b3J2b2duOm1vdG9ydm9nbmF2Z2lmdDp2MSI+CiAgICA8YXZnaWZ0c2xpbmplPgogICAgICAgIDxhdmdpZnRzYmVsb2VwPjU0Mjg5Ni4wMDwvYXZnaWZ0c2JlbG9lcD4KICAgICAgICA8YXZnaWZ0c29wcGx5c25pbmc+CiAgICAgICAgICAgIDxzYWVyYXZnaWZ0VHlwZWtvZGU+QkI8L3NhZXJhdmdpZnRUeXBla29kZT4KICAgICAgICAgICAgPHNhZXJhdmdpZnRHcnVwcGVrb2RlPlg8L3NhZXJhdmdpZnRHcnVwcGVrb2RlPgogICAgICAgIDwvYXZnaWZ0c29wcGx5c25pbmc+CiAgICAgICAgPGF2Z2lmdHNkYXRvPjIwMTctMTAtMjA8L2F2Z2lmdHNkYXRvPgogICAgPC9hdmdpZnRzbGluamU+CiAgICA8YmV0YWxpbmdzaW5mb3JtYXNqb24+CiAgICAgICAgPGtpZG51bW1lcj4xMDEwMTAxMDEwMTA8L2tpZG51bW1lcj4KICAgICAgICA8Zm9yZmFsbHNkYXRvPjIwMTctMTAtMjA8L2ZvcmZhbGxzZGF0bz4KICAgICAgICA8ZmFrdHVyYWRhdG8+MjAxNy0xMC0yMDwvZmFrdHVyYWRhdG8+CiAgICAgICAgPHRvdGFsQXZnaWZ0c2JlbG9lcD41NDI4OTYuMDA8L3RvdGFsQXZnaWZ0c2JlbG9lcD4KICAgIDwvYmV0YWxpbmdzaW5mb3JtYXNqb24+CiAgICA8bW90b3J2b2duYXZnaWZ0c3R5cGU+ZW5nYW5nc2F2Z2lmdDwvbW90b3J2b2duYXZnaWZ0c3R5cGU+CiAgICA8dGlkc3N0ZW1wZWw+MjAxOC0wMS0xNiswMTowMDwvdGlkc3N0ZW1wZWw+CiAgICA8Z3J1bm5sYWdGb3JNb3RvcnZvZ25hdmdpZnQ+CiAgICAgICAgPGtqb2VyaW5nZW5zQXJ0PjEwPC9ram9lcmluZ2Vuc0FydD4KICAgICAgICA8a2pvZXJldG9leT4KICAgICAgICAgICAgPGVpZXJza2FwUmVnaXN0cmVydD4yMDE3LTEwLTIwPC9laWVyc2thcFJlZ2lzdHJlcnQ+CiAgICAgICAgICAgIDxmb2Vyc3RlUmVnaXN0cmVyaW5nc2Fhcj4yMDE3PC9mb2Vyc3RlUmVnaXN0cmVyaW5nc2Fhcj4KICAgICAgICAgICAgPGZvZXJzdGVSZWdpc3RyZXJpbmdzZGF0b0lOb3JnZT4yMDE3LTEwLTIwPC9mb2Vyc3RlUmVnaXN0cmVyaW5nc2RhdG9JTm9yZ2U+CiAgICAgICAgICAgIDxram9lcmV0b2V5Z3J1cHBlPjEwMTwva2pvZXJldG9leWdydXBwZT4KICAgICAgICAgICAgPGxlbmdkZT4zOTY0PC9sZW5nZGU+CiAgICAgICAgICAgIDxtb3RvcmVmZmVrdD45NjwvbW90b3JlZmZla3Q+CiAgICAgICAgICAgIDxzbGFndm9sdW0+MTQzPC9zbGFndm9sdW0+CiAgICAgICAgICAgIDxkcml2c3RvZmY+QkVOU0lOPC9kcml2c3RvZmY+CiAgICAgICAgICAgIDxlZ2VudmVrdD4xNTE5PC9lZ2VudmVrdD4KICAgICAgICAgICAgPGVpZXI+CiAgICAgICAgICAgICAgICA8Zm9lZHNlbHNFbGxlckRudW1tZXI+MTEyMjMzNDQ1NTwvZm9lZHNlbHNFbGxlckRudW1tZXI+CiAgICAgICAgICAgICAgICA8cGFydHNudW1tZXI+NTU0NDMzMjIxMTwvcGFydHNudW1tZXI+CiAgICAgICAgICAgICAgICA8bmF2bj5LTEFSQSBLVTwvbmF2bj4KICAgICAgICAgICAgPC9laWVyPgogICAgICAgICAgICA8dGlsbGF0dFRvdGFsdmVrdD4yMTY0PC90aWxsYXR0VG90YWx2ZWt0PgogICAgICAgICAgICA8aHlicmlkPm5laTwvaHlicmlkPgogICAgICAgICAgICA8Y28ydXRzbGlwcD4yNjg8L2NvMnV0c2xpcHA+CiAgICAgICAgICAgIDxub3h1dHNsaXBwPjU5LjQ8L25veHV0c2xpcHA+CiAgICAgICAgICAgIDxram9lcmV0b2V5aWRlbnRpZmlrYXRvcj4KICAgICAgICAgICAgICAgIDxram9lcmV0b2V5VW5pa0lkZW50aWZpa2F0b3I+QUJDREVGR0hJSjwva2pvZXJldG9leVVuaWtJZGVudGlmaWthdG9yPgogICAgICAgICAgICAgICAgPGtqZW5uZW1lcmtlPjQ0QklMMTwva2plbm5lbWVya2U+CiAgICAgICAgICAgICAgICA8dW5kZXJzdGVsbHNudW1tZXI+VU5ERVJTVEVMTDQ0PC91bmRlcnN0ZWxsc251bW1lcj4KICAgICAgICAgICAgPC9ram9lcmV0b2V5aWRlbnRpZmlrYXRvcj4KICAgICAgICA8L2tqb2VyZXRvZXk+CiAgICA8L2dydW5ubGFnRm9yTW90b3J2b2duYXZnaWZ0PgogICAgPGF2Z2lmdHNwbGlrdGlnPgogICAgICAgIDxmb2Vkc2Vsc0VsbGVyRG51bW1lcj4xMTIyMzM0NDU1PC9mb2Vkc2Vsc0VsbGVyRG51bW1lcj4KICAgICAgICA8cGFydHNudW1tZXI+NTU0NDMzMjIxMTwvcGFydHNudW1tZXI+CiAgICA8L2F2Z2lmdHNwbGlrdGlnPgogICAgPGF2Z2lmdHNrb21wb25lbnQ+CiAgICAgICAgPGtvbXBvbmVudD5DbzI8L2tvbXBvbmVudD4KICAgICAgICA8YmVsb2VwPjQ3NTMzNy4yMDwvYmVsb2VwPgogICAgPC9hdmdpZnRza29tcG9uZW50PgogICAgPGF2Z2lmdHNrb21wb25lbnQ+CiAgICAgICAgPGtvbXBvbmVudD5FZ2VudmVrdDwva29tcG9uZW50PgogICAgICAgIDxiZWxvZXA+NjA5NDUuNjQ8L2JlbG9lcD4KICAgIDwvYXZnaWZ0c2tvbXBvbmVudD4KICAgIDxhdmdpZnRza29tcG9uZW50PgogICAgICAgIDxrb21wb25lbnQ+TW90b3JlZmZla3Q8L2tvbXBvbmVudD4KICAgICAgICA8YmVsb2VwPjAuMDA8L2JlbG9lcD4KICAgIDwvYXZnaWZ0c2tvbXBvbmVudD4KICAgIDxhdmdpZnRza29tcG9uZW50PgogICAgICAgIDxrb21wb25lbnQ+Tk94PC9rb21wb25lbnQ+CiAgICAgICAgPGJlbG9lcD40MjEzLjI0PC9iZWxvZXA+CiAgICA8L2F2Z2lmdHNrb21wb25lbnQ+CiAgICA8YXZnaWZ0c2tvbXBvbmVudD4KICAgICAgICA8a29tcG9uZW50PlNsYWd2b2x1bTwva29tcG9uZW50PgogICAgICAgIDxiZWxvZXA+MC4wMDwvYmVsb2VwPgogICAgPC9hdmdpZnRza29tcG9uZW50PgogICAgPGF2Z2lmdHNrb21wb25lbnQ+CiAgICAgICAgPGtvbXBvbmVudD5DbzIgRnJhdHJla2s8L2tvbXBvbmVudD4KICAgICAgICA8YmVsb2VwPjAuMDA8L2JlbG9lcD4KICAgIDwvYXZnaWZ0c2tvbXBvbmVudD4KICAgIDxhdmdpZnRza29tcG9uZW50PgogICAgICAgIDxrb21wb25lbnQ+RWdlbnZla3QgRnJhdHJla2s8L2tvbXBvbmVudD4KICAgICAgICA8YmVsb2VwPjAuMDA8L2JlbG9lcD4KICAgIDwvYXZnaWZ0c2tvbXBvbmVudD4KICAgIDxhdmdpZnRza29tcG9uZW50PgogICAgICAgIDxrb21wb25lbnQ+TW90b3JlZmZla3QgRnJhdHJla2s8L2tvbXBvbmVudD4KICAgICAgICA8YmVsb2VwPjAuMDA8L2JlbG9lcD4KICAgIDwvYXZnaWZ0c2tvbXBvbmVudD4KICAgIDxhdmdpZnRza29tcG9uZW50PgogICAgICAgIDxrb21wb25lbnQ+Tk94IEZyYXRyZWtrPC9rb21wb25lbnQ+CiAgICAgICAgPGJlbG9lcD4wLjAwPC9iZWxvZXA+CiAgICA8L2F2Z2lmdHNrb21wb25lbnQ+CiAgICA8YXZnaWZ0c2tvbXBvbmVudD4KICAgICAgICA8a29tcG9uZW50PlNsYWd2b2x1bSBGcmF0cmVrazwva29tcG9uZW50PgogICAgICAgIDxiZWxvZXA+MC4wMDwvYmVsb2VwPgogICAgPC9hdmdpZnRza29tcG9uZW50PgogICAgPGF2Z2lmdHNrb21wb25lbnQ+CiAgICAgICAgPGtvbXBvbmVudD5DbzIgU3VtPC9rb21wb25lbnQ+CiAgICAgICAgPGJlbG9lcD40NzUzMzcuMjA8L2JlbG9lcD4KICAgIDwvYXZnaWZ0c2tvbXBvbmVudD4KICAgIDxhdmdpZnRza29tcG9uZW50PgogICAgICAgIDxrb21wb25lbnQ+RWdlbnZla3QgU3VtPC9rb21wb25lbnQ+CiAgICAgICAgPGJlbG9lcD42MDk0NS42NDwvYmVsb2VwPgogICAgPC9hdmdpZnRza29tcG9uZW50PgogICAgPGF2Z2lmdHNrb21wb25lbnQ+CiAgICAgICAgPGtvbXBvbmVudD5Nb3RvcmVmZmVrdCBTdW08L2tvbXBvbmVudD4KICAgICAgICA8YmVsb2VwPjAuMDA8L2JlbG9lcD4KICAgIDwvYXZnaWZ0c2tvbXBvbmVudD4KICAgIDxhdmdpZnRza29tcG9uZW50PgogICAgICAgIDxrb21wb25lbnQ+Tk94IFN1bTwva29tcG9uZW50PgogICAgICAgIDxiZWxvZXA+NDIxMy4yNDwvYmVsb2VwPgogICAgPC9hdmdpZnRza29tcG9uZW50PgogICAgPGF2Z2lmdHNrb21wb25lbnQ+CiAgICAgICAgPGtvbXBvbmVudD5TbGFndm9sdW0gU3VtPC9rb21wb25lbnQ+CiAgICAgICAgPGJlbG9lcD4wLjAwPC9iZWxvZXA+CiAgICA8L2F2Z2lmdHNrb21wb25lbnQ+CiAgICA8YXZnaWZ0c2tvbXBvbmVudD4KICAgICAgICA8a29tcG9uZW50PlZyYWtwYW50PC9rb21wb25lbnQ+CiAgICAgICAgPGJlbG9lcD4yNDAwPC9iZWxvZXA+CiAgICA8L2F2Z2lmdHNrb21wb25lbnQ+CiAgICA8YXZnaWZ0c2tvbXBvbmVudD4KICAgICAgICA8a29tcG9uZW50PkJydWtzZnJhZHJhZyAwJTwva29tcG9uZW50PgogICAgICAgIDxiZWxvZXA+MC4wMDwvYmVsb2VwPgogICAgPC9hdmdpZnRza29tcG9uZW50PgogICAgPGZvcmhhYW5kc2JlcmVnbmluZz5mYWxzZTwvZm9yaGFhbmRzYmVyZWduaW5nPgo8L21vdG9ydm9nbmF2Z2lmdD4K" }, "extension": null, "skjemaversjon": "v3_0" }     Thanks, bjornmy   ... View more

Any input would be appreciated guys. The output from the ConvertRecord is a JSON-document, and I would like to replace the value of $.data.content from the originale file with this JSON-document. How can I do this? ... View more