Is there a way to have a file link generated when implementing the SQL to Excel node?

Is there a way to have a file link generated when implementing the SQL to Excel node? Here is my example:

I have a process dashboard that has a Export CSV button. User clicks button and it initiates the SQL to Excel download. What I would like then is to generate the document URL, put that URL in a email and send it to the logged in user.

I looked at a function and there was a "linktodocumentsinternal". I attempted to use this but it returns a partial URL (missing the appiancloud.zzzzz.com/....... I tried to append this part of the url to the part of the url that is returned with the function above but it does not create a complete URL.

So basically, is there a way to generate that exported document link, drop it into a PV so I can then insert it into a email and send to the user? Better yet, is there a way when clicking that Export CSV button to generate a browser modal that says Open or Save this document?

Thanks...

OriginalPostID-101269

OriginalPostID-101269

  Discussion posts and replies are publicly visible

Parents
  • Hey Alex, I did the above and here is what got generated. linktofolderinternal(pv!savedFolder,"CSV Exports"). It generated a link in the email "CSV Exports". However, the URL was the following; /suite/knowledge/ViewFolderContents.bg?id=16270&appian_environment= . As you can see what is generated by the function linktofolderinternal is missing the https://ourdomain.com. Even when I appended the domain name to the URL it would still not take me to the folder. The folder link in the properties is this: OURDOMAIN.appiancloud.com/.../16270. While the URL generated from the linktofolderinternal with the appended domain is this: OURDOMAIN.appiancloud.com/.../ViewFolderContents.bg. See the difference? We are all Tempo enabled and cloud based. What would be better is I think I could construct the URL if I could get the folder ID. Anyway to get the folder ID on the Save from SQL?
Reply
  • Hey Alex, I did the above and here is what got generated. linktofolderinternal(pv!savedFolder,"CSV Exports"). It generated a link in the email "CSV Exports". However, the URL was the following; /suite/knowledge/ViewFolderContents.bg?id=16270&appian_environment= . As you can see what is generated by the function linktofolderinternal is missing the https://ourdomain.com. Even when I appended the domain name to the URL it would still not take me to the folder. The folder link in the properties is this: OURDOMAIN.appiancloud.com/.../16270. While the URL generated from the linktofolderinternal with the appended domain is this: OURDOMAIN.appiancloud.com/.../ViewFolderContents.bg. See the difference? We are all Tempo enabled and cloud based. What would be better is I think I could construct the URL if I could get the folder ID. Anyway to get the folder ID on the Save from SQL?
Children
No Data