Skip to main content
  • EN

Hi,

I'm doing a bit of testing with OneDriveConnector and Emailer.

My workspace writes an Excel file out using FeatureWriter and then uploads that file to OneDrive. I want to insert the '_sharable_link' attribute, created in the OneDriveConnector, into the body text of the Emailer.

However, the Emailer appears to get rid of the value in the '_sharable_link' attribute, therefore the hyperlink <a href="@Value(_sharable_link)">Output</a> doesn't work in the resulting email.

Has anyone come across this before? Or in the more likely scenario, am I missing something obvious?

Thanks!

Firstly insert a Logger (or a breakpoint) between the OneDriveConnector and the Emailer then run, to make sure that the "_sharable_link" attribute definitely has a proper value.

 

Firstly insert a Logger (or a breakpoint) between the OneDriveConnector and the Emailer then run, to make sure that the "_sharable_link" attribute definitely has a proper value.

 

Hi @takashi, thanks for your reply. Yes, I should have said in my original question that I have tested the direct output of the OneDriveConnector and '_sharable_link' does have a value which is correct (tested in internet browser and goes to the desired page.

 

Just seems to disappear in the Emailer.

 

If you just set the attribute value (i.e. raw URL string) to the message like this, what would happen?

 

@Value(_sharable_link)
I've stripped everything out apart from the OneDriveConnector and the Emailer. Setting the body text with only the _sharable_link value works!

However, in my full workspace, I read in another attribute from another stream which provides the email addresses to which to send the emails to (recorded in the 'To' attribute. It is when these are introduced into the Emailer that the _sharable_link value seems to disappear.

 

 

If you just set the attribute value (i.e. raw URL string) to the message like this, what would happen?

 

@Value(_sharable_link)
I've stripped everything out apart from the OneDriveConnector and the Emailer. Setting the body text with only the _sharable_link value works! 

0684Q00000ArMYCQA3.jpg

However, in my full workspace, I read in another attribute from another stream which provides the email addresses to which to send the emails to (recorded in the 'To' attribute. It is when these are introduced into the Emailer that the _sharable_link value seems to disappear.

 

0684Q00000ArMVCQA3.jpg

 

The reason for the problem is that the features coming from the Sheet1 feature type don't have "_sharable_link". Be aware that the Emailer attempts to process input features one by one separately.

You can use the FeatureMerger (set an identical constant e.g. 1 to the "Join On" for both Requestor and Supplier) to unconditionally merge "_sharable_link" held by the feature from the OneDriveConnector to every feature from the Sheet1 reader feature type, then enter the merged features into the Emailer, as in:

The reason for the problem is that the features coming from the Sheet1 feature type don't have "_sharable_link". Be aware that the Emailer attempts to process input features one by one separately.

You can use the FeatureMerger (set an identical constant e.g. 1 to the "Join On" for both Requestor and Supplier) to unconditionally merge "_sharable_link" held by the feature from the OneDriveConnector to every feature from the Sheet1 reader feature type, then enter the merged features into the Emailer, as in:

Brilliant, thanks @takashi that has worked perfectly!

 

Reply


Community Stats

30,159
Posts
114,480
Replies
37,807
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.