AnsweredAssumed Answered

Interested in emailing a query result in HTML table inline in email message

Question asked by allan.ford577519 on Feb 23, 2017
Latest reply on Mar 22, 2017 by Srinivas Chandrakanth Vangari

Hi !

 

I am interested in using Boomi to emailing a query result in a HTML table inline in an email message

 

I spotted this:

http://help.boomi.com/atomsphere/GUID-96F4A5D9-D157-47A2-BF38-2E96DD53FE35.html

 

I spotted this also:

https://community.boomi.com/thread/3224

 

example email as per this:

 

Hi,

A message from the weekly automated email process.

New Wells added to dbMap this week or spudded this week are these:

Database connect string: jdbc:oracle:thin:@ldap://ldap.santos.com:389/coopprod,cn=OracleContext,ou=au,ou=tnsnames,dc=santos,dc=com

Database account used: ETL_READ

Proces run date/time: 2017-02-23 11:00:04

well_codewell_full_namecurrent_operatorgpr_geological_province_codewell_intent_codewell_cat_primaryspud_datedate_insertedp_person_id_insert
17802266DALDOWIE 3SANTOSSURBOWCSGDEV2017-02-20 00:00:00.02014-10-29 17:05:18.0HAYTA
78821956DANDY 1BEACH ENERGYCOOP/EROMnullEXP2017-02-11 00:00:00.02017-02-20 10:32:20.0ASPRO
79916183TOOLACHEE 53SANTOSCOOP/EROMGASDEVnull2017-02-21 16:35:09.0ROGBR
79923287TOOLACHEE 54SANTOSCOOP/EROMGASDEVnull2017-02-21 16:41:31.0ROGBR

The query sql run was this:
select
well_code,
well_full_name,
current_operator,
gpr_geological_province_code,
well_intent_code,
well_cat_primary,
spud_date,
date_insert,
edp_person_id_insert
from basic_wells
where ( date_insert >= sysdate - 7 and location_source <>'DOP' )
or ( spud_date >= sysdate - 7 and spud_date <= sysdate and location_source <>'DOP' )
order by well_full_name

kind regards, Integration team.

Outcomes