Nice article. However, there is a minor problem while setting the trailing zero values in %Set() of dynamicobject. But, It's not happening in literal constructor {} syntax. Due to objectscript not keep the trailing zeros. But json number do.

set json = { "decimal": 12.000}
    zw json
    set json1= ##Class(%DynamicObject).%New()
    do json1.%Set("decimal", 12.000) ; this is consider as stringdo json1.%Set("decimal1", $FN(12,,2), "number")	
    zw json1
    
    #;output
    json={"decimal":12.000}  ; <DYNAMIC OBJECT>
    json1={"decimal":12,"decimal1":12}  ; <DYNAMIC OBJECT>

Hello @ARTHUR.LASILVA 

You create a your custom task and schedule this task in task manager if it's required. Follow the below steps to schedule the task.

1. Create a new class definition with extends of %SYS.Task.Definition. Override the OnTask() method and necessary logic inside the method
2. Goto System Management portal > System Operation>Task Manager>NewTask
   1. Add unique task name
   2. Select namespace
   3. Assign the task type ( which is your class definition)
   4. Select output file when task running
   5. Provide your ouputfile.csv in the output file
   6. schedule the execution date and time.
   7. Finish the task

Class Samples.TaskMgr.SQLExportTask Extends%SYS.Task.Definition
{

Parameter TaskName As STRING = "ExportQueryToCSV";

Method OnTask() As%Status
{
    set statement = ##class(%SQL.Statement).%New()
    /// Place your sql queryset sql = "Select Name,dob,Phone From Samples_DB.Person"set tSC = statement.%Prepare(sql)
    if$$$ISERR(tSC) Q$$$OKset result = statement.%Execute()
    #dim meta As%SQL.StatementMetadata= result.%GetMetadata()
    for i=1:1:meta.columnCount {
        if i>1w","write meta.columns.GetAt(i).colName
    }
    write$$$NLwhile result.%Next()
    {
        write result.Name,",",result.dob,",",result.Phone,$$$NL
    }
    return$$$OK
}
}

Task scheduler

Hi @Sakthivel Perumal 

Can you try the below sample to download file from the directory

Class Samples.CSPFileDownload Extends%CSP.Page
{
Parameter CONTENTTYPE As STRING = "application/text";ClassMethod OnPage() As%Status
{
    do%stream.OutputToDevice()
    return$$$OK
}
ClassMethod OnPreHTTP() As%Boolean
{
    #; your directory and fileset file="C:\Users\readmyfile.txt"set stream=##class(%Stream.FileCharacter).%New()
    set sc=stream.LinkToFile(file)
    set%stream = stream
    set%response.ContentType = ..#CONTENTTYPE
    set%fileName = file
    set%response.ContentLength=stream.Size
    return$$$OK
}
}

Hello Scott,

As of m understanding, If your dynObject is actually the expected JSON format. Create a instance for class response class and load the dynObject into object by method  obj.%JSONImport(dynObject)