Using getattachrec.exe to retrieve URL in Process Flow Pro

See my blog entry as well as the attached screen shot: http://consultdavidw.blog...chrecexe-cgi-to.html

My blog describes how to do this with JavaScript in Design Studio and my screen shot is an example of how I used the WebRun to get a PO Header comment.

This is what I used, mostly from David's blog.

&_OUT=XML&_PDL=&_FN=REQHEADER&_IN=RQHSET1&K1=&K2=&_ATYP=U&_AUDT=I&_USCH=http&_OPM=T&_DATA=TRUE&_ECODE=FALSE

You then have to get the results of the getattachrec from a javascript variable to attach it to your email like:

//RQCheckAttach is the name of my getattachrec webrun
var Attachback = RQCheckAttach_result;
var D = Attachback.indexOf("AttData")
var F = Attachback.indexOf("/AttData")
var myAttach = Attachback.substr(D+18,F-D-23);
var myAttach = escape(myAttach);
var myAttach = myAttach.replace(/%5C/g,"%5C");
//Set for input button
//var myAttach = "'" + unescape(myAttach) + "'" ;
var myAttach = unescape(myAttach);
var vresults = myAttach.length

if (vresults >= 1)
{var vEmailAttach = '

Click here to see attached quote

'}
//{var vEmailAttach = ''}
else
{var vEmailAttach = ''}

Your key fields &K1 and &K2 are in the wrong spot, they need to be part of the Index paramater  (&_IN=RQHSET1&K1=1&K2=266) . If you are going to send the output to TXT yoiu will have to parse the D:0= returned, otherwise if you have OUT=XML then you could feed it to an XML Parse node then refer to the AttData varaiable from that node.

Thank you both - I was able to get it working with your input. Went with the XML output and Derek's explanation of parsing out the data.

Works like a charm! Thanks again.