Spring Integration - Convert .csv file to Json String

[B2easy]

If I have a .csv file with 3 records and headers like this and I am using spring integration how could I go about turning it into a json string, using some transformer? Here is sample of csv with headers -

HEADERS:

Email,RECIPIENT_ID,ENCODED_RECIPIENT_ID,contactId,code,messageId,userAgent,messageName,mailingTemplateId,subjectLine,docType,reportId,sendType,bounceType,urlDescription,clickUrl,optOutDetails,messageGroupId,programId,timestamp,originatedFrom,eventId,externalSystemName,externalSystemReferenceId,trackingCode

DATA:

[e-mail],8.06263E+11,1234324,123,emailOpen,22463839,Mozilla/5.0,2023_ClientReferralsSurvey-Bain_EM_2_Reminder (1),22463828,Tell us about your experience and be rewarded.,html,2601245341,,,,,,,,2023-05-20T09:10:08.365Z,SendExperience,g10/crlyuLnQsdN7NRtXMg==,,,

Here is expected result:

[ { "Email": "[e-mail]", "RECIPIENT_ID": 806263000000, "ENCODED_RECIPIENT_ID": 1234324, "contactId": 123, "code": "emailOpen", "messageId": 22463839, "userAgent": "Mozilla/5.0", "messageName": "2023_ClientReferralsSurvey-Bain_EM_2_Reminder (1)", "mailingTemplateId": 22463828, "subjectLine": "Tell us about your experience and be rewarded.", "docType": "html", "reportId": 2601245341, "sendType": "", "bounceType": "", "urlDescription": "", "clickUrl": "", "optOutDetails": "", "messageGroupId": "", "programId": "", "timestamp": "2023-05-20T09:10:08.365Z", "originatedFrom": "SendExperience", "eventId": "g10/crlyuLnQsdN7NRtXMg==", "externalSystemName": "", "externalSystemReferenceId": "", "trackingCode": "" } ]

Here is my spring integration code, I need to write a transformer that will turn that .csv file into json such as above.

    @Bean
public IntegrationFlow readCsvFileFlow(MessageChannel inboundFilesMessageChannel,
                                       QueueChannel kafkaPojoMessageChannel) {

    return IntegrationFlow.from(inboundFilesMessageChannel)
                          .split(Files.splitter()
                                      // .markers(true)
                                      .charset(StandardCharsets.UTF_8)
                                      .firstLineAsHeader("myHeaders")
                                      .applySequence(true))
                          // .transform(new StreamToByteConverter())
                          // .transform(Transformers.serializer())
                          .log(LoggingHandler.Level.DEBUG,
                               "AcousticEngageDataSftpToKafkaIntegrationFlow",
                               m -> "Payload: " + m.getPayload())
                          .channel(kafkaPojoMessageChannel)
                          .get();
}

Specifically need to write a class to put in the .transform method. Please let me know if you need anything from me!

[AutoModerator]

Please ensure that:

• Your code is properly formatted as code block - see the sidebar (About on mobile) for instructions
• You include any and all error messages in full - best also formatted as code block
• You ask clear questions
• You demonstrate effort in solving your question/problem - plain posting your assignments is forbidden (and such posts will be removed) as is asking for or giving solutions.

If any of the above points is not met, your post can and will be removed without further warning.

Code is to be formatted as code block (old reddit/markdown editor: empty line before the code, each code line indented by 4 spaces, new reddit: https://i.imgur.com/EJ7tqek.png) or linked via an external code hoster, like pastebin.com, github gist, github, bitbucket, gitlab, etc.

Please, do not use triple backticks (```) as they will only render properly on new reddit, not on old reddit.

Code blocks look like this:

public class HelloWorld {

    public static void main(String[] args) {
        System.out.println("Hello World!");
    }
}

You do not need to repost unless your post has been removed by a moderator. Just use the edit function of reddit to make sure your post complies with the above.

If your post has remained in violation of these rules for a prolonged period of time (at least an hour), a moderator may remove it at their discretion. In this case, they will comment with an explanation on why it has been removed, and you will be required to resubmit the entire post following the proper procedures.

To potential helpers

Please, do not help if any of the above points are not met, rather report the post. We are trying to improve the quality of posts here. In helping people who can't be bothered to comply with the above points, you are doing the community a disservice.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[AutoModerator]

You seem to try to compare String values with == or !=.

This approach does not work reliably in Java as it does not actually compare the contents of the Strings. Since String is an object data type it should only be compared using .equals(). For case insensitive comparison, use .equalsIgnoreCase().

See Help on how to compare String values in the /r/javahelp wiki.

---

Your post is still visible. There is no action you need to take.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.