Skip to main content
Solved

OneDriveConnector to Emailer - how to bring through _sharable_link attribute

J
Forum|alt.badge.img

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!

Best answer by takashi

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:

View original
Did this help you find an answer to your question?

7 replies

takashi
Influencer
  • takashiInfluencer
  • June 23, 2018
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.

 

J
Forum|alt.badge.img
  • johnwk
  • Author
  • June 23, 2018
takashi wrote:
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.

 

takashi
Influencer
  • takashiInfluencer
  • June 23, 2018
If you just set the attribute value (i.e. raw URL string) to the message like this, what would happen?

 

@Value(_sharable_link)
J
Forum|alt.badge.img
  • johnwk
  • Author
  • June 23, 2018
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.

 

 

J
Forum|alt.badge.img
  • johnwk
  • Author
  • June 23, 2018
takashi wrote:
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

 

takashi
Influencer
  • takashiInfluencer
  • Best Answer
  • June 24, 2018

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:

J
Forum|alt.badge.img
  • johnwk
  • Author
  • June 24, 2018
takashi wrote:

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


Helpful Members This Week

Community Stats

31,201
Posts
118,279
Replies
38,806
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.