How to get the size of the file in workflow

Hi,

It seems like you might have to write a stored procedure with (Data length) and surface it as a SmartObject. It then can be used to calculate the size of the file in your workflow. I'm not an expert in SQL, someone else can confirm this.

https://docs.microsoft.com/en-us/sql/t-sql/functions/datalength-transact-sql

For example, i have a SQL table with a column (type: nvarchar(max)), it's setup to store file size that is greater than 1 MB.

I can use something like this to show the file size.

Select [name], DATALENGTH(file_attachment) AS SizeInBytes, LEN(file_attachment) AS NumberOfCharacters
FROM [K2].[dbo].[TestFileSizeSMO1]