Table creation when sending mail

Question

Hello,
I was designing a pipeline which includes salesforce upsert and deletion . Obviously error view will be captured for the upsert and deletion operation and while sending the mail along with sending the file we decided to incorporate the values ( like upsert success, error and delete success , delete error ) in a table format using snaplogic’s HTML TABLE method . We achieved the same but whenever we have say 2 values out of 4 we have two separate tables and if we have 3 values 3 tables are created but we would like to incorporate all the values in a single table view . Please find my pipeline and sample attachment.

As per the above screenshot we would like to have the values Submitted Leave Success and Cancel DEL success in a single table instead of separate table.
Please find my pipeline:
CM_GL_WORKDAY_TO_VEEVA_ABSENCE_INTEGRATION_2020_11_07.slp (109.8 KB)

del · Answer

Harsha3:

May i know the working procedure here because without this method we would have got two rows so does it like the inherent table property we use in mail sender

I’m not sure I understand this question; but will try to answer.
If the output from your pipeline just before the email sender is 2 separate documents due to the way your pipeline is set up; the email sender creates a table row for each document (i.e. a table with 2 rows).  If your output was 30 documents, the table would have 30 rows.
However, by adding the aggregate snap before the email sender, it reduces all the individual documents into a single document - therefore the email sender will only create a table with one row.

supratim · Answer

@Harsha3 - Try below approach-
Use group by N make it as 0 so all record should be grp by in one array, then change the table data path with your group name like below-

harsha3 · Answer

Hi Supratim,
Thanks for the reply I have tried that approach still we get two rows instead of one for having two values.
Thanks,
Harshavardhana

del · Answer

@Harsha3,
You might try the Aggregate snap using the MAX function:

harsha3 · Answer

Hi del,
Thanks so much it works! . May i know the working procedure here because without this method we would have got two rows so does it like the inherent table property we use in mail sender

Forum Discussion

Table creation when sending mail

9 Replies

Recent Discussions

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found

Unable to write sldb file to file system