Storing a Note as a URL Link

(0) Share

Report

Posted on by Thomas David Dayman

11,323

I have a SSIS Package which stores note attachments into SharePoint and then leaves a note with the URL to that SharePoint Location.

At the moment the Note gets stored as a string. Is it possible to make it into a Clickable link? Or are there any possible alternatives to achieve this?

*This post is locked for comments

All responses (4)

Answers (1)

Thomas David Dayman 11,323 on at

Like (0)

Report

RE: Storing a Note as a URL Link

That worked! Thank you :)
Verified answer

ashlega 34,475 on at

Like (0)

Report

RE: Storing a Note as a URL Link

Hi Thomas,

I think it's the right attribute, but it has to be encoded:

msdn.microsoft.com/.../gg328429.aspx

DocumentBody = Convert.ToBase64String(

new UnicodeEncoding().GetBytes("Sample Annotation Text")),

This may help, though I did not try:

stackoverflow.com/.../converting-blobcolumn-to-string-in-ssis-script-component
Thomas David Dayman 11,323 on at

Like (0)

Report

RE: Storing a Note as a URL Link

Hi Alex,

I was trying your solution and I have a question

When I add a HTML attachment manually in CRM it adds a bunch of random text to the Document Body. But in SSIS I am putting the HTML in the Document Body. Am I putting the HTML in the right attribute?
Suggested answer

ashlega 34,475 on at

Like (0)

Report

RE: Storing a Note as a URL Link

Hi,

it's an HTML textarea there, so you probably can't display a link either way. You could create an html file attachment and use HTML redirect there.. but your users may have to download the file first, and, then, open it for this to work:

<!DOCTYPE html>

<html>

<head>

<meta http-equiv="refresh" content="0; url=http://www.google.com">

</head>

<body>

</body>

</html>