Insert HTML in Collection Runner

hrmedeiros · October 22, 2019, 6:54pm

Hello everyone!

I’m trying to create a collection runner with external data, with a field containing a HTML layout for e-mails. I had scaped all the double quotes in my data file, but Postman does not recognize.

Data:

[
{
“OWNER_TYPE_ID”: 2,
“OWNER_ID”: 909,
“TYPE_ID”: 4,
“COMMUNICATIONS”: [ { “VALUE":"[email protected]”}, { “VALUE":"[email protected]”} ],
“SUBJECT”: “Teste por API 10”,
“COMPLETED”: “Y”,
“PRIORITY”: 2,
“RESPONSIBLE_ID”: 45,
“DESCRIPTION”: “p{margin-top:0px; margin-bottom:0px;}</style><body class="setupTab" style=" background-color:#FFFFFF; bEditID:b1st1; bLabel:body;"><table cellpadding="0" width="500" cellspacing="0" id="topTable" height="450" ><tr valign="top" ><td style=" background-color:#FFFFFF; bEditID:r1st1; bLabel:header; vertical-align:top; height:100; text-align:left;"><img border="0" bEditID="r1sp1" bLabel="headerImage" id="r1sp1" src="serverurl” ></img></td></tr><tr valign="top" ><td style=" background-color:#FFFFFF; bEditID:r2st1; bLabel:accent1; height:0;"></td></tr><tr valign="top" ><td styleInsert="1" height="300" style=" background-color:#FFFFFF; color:#000000; bEditID:r3st1; bLabel:main; font-size:12pt; font-family:arial;"><table border="0" cellpadding="5" width="550" cellspacing="5" height="400" ><tr valign="top" height="400" ><td tEditID="c1r1" style=" background-color:#FFFFFF; color:#000000; bEditID:r3st1; bLabel:main; font-size:12pt; font-family:arial;" aEditID="c1r1" locked="0" ><table width="800" border="0"><p style="font: small/normal Times New Roman; color: rgb(0, 65, 130); text-transform: none; text-indent: 0px; letter-spacing: normal; margin-top: 0px; margin-bottom: 0px; word-spacing: 0px; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;">Carolina,
Bom dia!<p style="font: small/normal Times New Roman; color: rgb(0, 65, 130); text-transform: none; text-indent: 0px; letter-spacing: normal; margin-top: 0px; margin-bottom: 0px; word-spacing: 0px; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;">
\t\t\tConforme solicitado, segue proposta comercial para an\u00E1lise.<p style="font: small/normal "Times New Roman"; color: rgb(0, 0, 0); text-transform: none; text-indent: 0px; letter-spacing: normal; margin-top: 0px; margin-bottom: 0px; word-spacing: 0px; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;"> <p style="font: small/normal Times New Roman; color: rgb(0, 65, 130); text-transform: none; text-indent: 0px; letter-spacing: normal; margin-top: 0px; margin-bottom: 0px; word-spacing: 0px; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;">\t\t\tFicamos no aguardo do aceite.<p style="font: small/normal "Times New Roman"; color: rgb(0, 0, 0); text-transform: none; text-indent: 0px; letter-spacing: normal; margin-top: 0px; margin-bottom: 0px; word-spacing: 0px; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;"> <p style="font: small/normal Times New Roman; color: rgb(0, 65, 130); text-transform: none; text-indent: 0px; letter-spacing: normal; margin-top: 0px; margin-bottom: 0px; word-spacing: 0px; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;">\u00C0 \t\t\tdisposi\u00E7\u00E3o para esclarecimentos.

\t\t\tAtenciosamente,
\t\t\t </td></tr><p style="font: 700 small/normal Times New Roman; color: rgb(0, 65, 130); text-transform: none; text-indent: 0px; letter-spacing: normal; margin-top: 0px; margin-bottom: 0px; word-spacing: 0px; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;">\t\t\tAnderson de Oliveira Dias\t\t\tHaztec Tecnologia e Planejamento Ambiental S.A.
\t\t\tRua Joaquim Palhares, 40 | 1\u00BA andar | Cidade Nova
\t\t\tRio de Janeiro | RJ | Cep 20260-080
\t\t\tTel.: +55 (21) 3974-6158<a style="color: blue; text-underline: single;" href="mailto:[email protected]">\t\t\[email protected]</a>
\t\t\t <a style="color: blue; text-underline: single;" href="http://www.haztec.com.br/">\t\t\twww.haztec.com.br</a><img align="left" alt="" src="https://c.na11.content.force.com/servlet/servlet.ImageServer?id=015G000000CcNh2&oid=00DG0000000kj2I" border="0">
 \t





Imprima somente se necess\u00E1rio\t\t\tEsta mensagem cont\u00E9m informa\u00E7\u00E3o confidencial e somente para quem \t\t\testa foi destinada. Caso voc\u00EA n\u00E3o seja o destinat\u00E1rio da mensagem, \t\t\tfavor informar-nos imediatamente. Ela n\u00E3o deve ser lida, \t\t\tretransmitida, disseminada ou utilizada de qualquer forma por \t\t\tpessoas ou entidades outras que n\u00E3o o destinat\u00E1rio. Nenhuma forma de \t\t\tcontrata\u00E7\u00E3o resultar\u00E1 desta mensagem, at\u00E9 que documentos/contratos \t\t\tsejam assinados em nome da empresa. A Haztec Tecnologia e \t\t\tPlanejamento Ambiental SA n\u00E3o se responsabiliza por mensagens \t\t\ttransmitidas atrav\u00E9s de redes p\u00FAblicas. \t\t\t Print \t\t\tonly if necessary\t\t\tThis e-mail contains confidential information for the addressee \t\t\tonly. If you are not the intended recipient, please notify us \t\t\timmediately. You should not use, disclose, distribute or copy this \t\t\tcommunication if received in error. No binding contract will result \t\t\tfrom this e-mail until such time as a written document is signed on \t\t\tbehalf of the company. Haztec Tecnologia e Planejamento Ambiental SA \t\t\tcannot accept any responsibility for the completeness or accuracy of \t\t\tthis message as it has been transmitted over public networks.</td></tr></tbody></table></td></tr></table></td></tr><tr valign="top" ><td style=" background-color:#FFFFFF; bEditID:r4st1; bLabel:accent2; height:0;"></td></tr><tr valign="top" ><td style=" background-color:#FFFFFF; bEditID:r5st1; bLabel:footer; vertical-align:top; height:100; text-align:left;"></td></tr><tr valign="top" ><td style=" background-color:#FFFFFF; bEditID:r6st1; bLabel:accent3; height:0;"></td></tr></table></center><img src="http://na23.salesforce.com/servlet/servlet.ImageServer?oid=00DG0000000kj2I&esid=0181600000Ocf1F"></body></html>",
“DESCRIPTION_TYPE”: 3
},

{ "OWNER_TYPE_ID": 2, "OWNER_ID": 909, "TYPE_ID": 4, "COMMUNICATIONS": [ { "VALUE":"[email protected]"}, { "VALUE":"[email protected]"} ], "SUBJECT": "Teste por API 11", "COMPLETED": "Y", "PRIORITY": 2, "RESPONSIBLE_ID": 45, "DESCRIPTION": "<h1>b</h1>", "DESCRIPTION_TYPE": 3 }

]

Someone can help me?

arlem · October 23, 2019, 8:54am

Hi and welcome to the Postman community hrmedeiros!

Have you tried using single quotes for the JSON part and double quotes for the HTML part?

Something like that:

[{
'OWNER_TYPE_ID': 2,
'COMMUNICATIONS”': [ 
{ 'VALUE':'[email protected]'}, 
'DESCRIPTION': 'p{margin-top:0px; margin-bottom:0px;}</style><body class="setupTab" style="background-color:#FFFFFF; bEditID:b1st1; bLabel:body;">'
// rest of your code here

hrmedeiros · October 23, 2019, 5:01pm

Hello!
The JSON is correct. But Postman always interpret as pure HTML.

I solved with a pre-request script like

pm.environment.set('VAR_DESCRIPTION', JSON.stringify(data['DESCRIPTION']));

Thanks for your help

Topic		Replies	Views
Input file for collection runner - JSON - with double quotes Ask the Experts and Postman Tips	1	1715	July 17, 2018
GitHub #3178 Bug Fix -- Issue Ask the Experts and Postman Tips collections	1	733	June 24, 2019
CSV with empty cell and Collection Runner Ask the Experts and Postman Tips	8	948	January 25, 2021
Exception when using Collection Runner Ask the Experts and Postman Tips	2	1325	October 7, 2019
"Collections Runner" is not POSTing quotes Ask the Experts and Postman Tips collections , csv	4	2379	March 3, 2020

Insert HTML in Collection Runner

Related topics