CLI for BCP (SQL SVR) and dynamic file names
The scenario I needed to accomplish was to pull data from SQL server, group the data sets together based on different fields and then dynamically define the file name based on those groupings.
Perf...
Forum Discussion
Try double quoting the url like I mentioned before:
<a href="$URL">Click me</a>
As I can see, you’re referencing the incoming field without quotations, that’s why it is not treated as a proper attribute (href).
I tried opening the final html file in notepad++ while I was testing the solution and what I found was that the tags get converted to predefined snapLogic letters like the one seen in the link below:
Link 1: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439280/XML+Generator
Link 2: The XML FAQ: What are the special characters in XML?
Moreover, putting double quotes in
<a href = >
is challenging too as the URL intakes some variables too, so you may consider the URL to be
That’s why I suggested to do the transformations before the XML Generator. Create the URL link , and just pass it like a variable into the XML Generator.
URL generation and transformation is actually happening in the parent pipeline and its way before the XML generator (which is in child pipeline)
