Forum Discussion

jfpelletier's avatar
jfpelletier
Contributor
2 years ago

Linking attachments with email body using join snap returns errors

Hello everyone. I'm using the Exchange Online Read Email snap to parse the content of the message, and process the attached files according to rules defined in the message. The Read Email has 2 out...
jfpelletier's avatar
jfpelletier
Contributor
2 years ago

Hello alchemiz,

Thanks for your reply! The error message that I reported in the original post is when I do use the "Unsorted" option as you suggest. If I use the default "Ascending" value, the error message is different:

Failure: Failed to perform join operation, Reason: Not ascending order: [null(value: AAMkADIwYmQwMzJhLTQ3YWQtNDY0Ni04YTliLWRlM2JhY2NkMzUwMABGAAAAAACqlsLWwl3zTpiuZt2kjeu4BwCh0wtN9WH0QYJbfsTDukxNAAAAAAEMAACh0wtN9WH0QYJbfsTDukxNAAKH0bTlAAA=, type: String)] and [null(value: AAMkADIwYmQwMzJhLTQ3YWQtNDY0Ni04YTliLWRlM2JhY2NkMzUwMABGAAAAAACqlsLWwl3zTpiuZt2kjeu4BwCh0wtN9WH0QYJbfsTDukxNAAAAAAEMAACh0wtN9WH0QYJbfsTDukxNAAKH0bTjAAA=, type: String)], Resolution: Please address the reported issue.

I also tried to use the "Sort" snap on the outputs just before the "Join", but the "Sort" at the Attachment branch is returning a similar error message.

JF

diptee_sawant's avatar
diptee_sawant
New Contributor
2 years ago

Hello,

Were you able to fix this issue?

We are also facing the same with sort snap.

Regards,

Diptee

  • jfpelletier's avatar
    jfpelletier
    Contributor
    2 years ago

    Hello Diptee,

    It was a while ago and I'm not using this pipeline anymore, but on top of my head what worked at the end was to add the ".toString()" method on both of my steams.

    If you try this, please let me know so that we can document the solution if it works. 🙂

    Kind regards,

    JF