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)

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 @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

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 Scott,

I had created ZAUTHENTICATE.mac in %SYS namespace. Implemented the GetCredentials and validated the authentication for delegated user. It works for me without any issues.

Hello @Hannah Sullivan 
If you need to delete the list of object while deleting the parent object. You can override the %OnDelete method and add the delete implementation refer below code logic. Once you call the ##Class(package.class).%DeleteId(id). It will trigger the %OnDelete Method and delete the list of persistent object as well.

ClassMethod%OnDelete(oid As%ObjectIdentity) As%Status [ Private, ServerOnly = 1 ]
{
    set object = ..%Open(oid,,.status)
    If$$$ISERR(status) quit status
    If$IsObject(object.Organizations) {
        set org= object.OrganizationsGetSwizzled()
        while org.GetNext(.key){
            do object.Organizations.GetAt(key).%DeleteId(key)
        }
    }
    Quit$$$OK
}

You can create these object with Parent-child relationship as well.

kudos everyone!

%JSON.Adaptor default manner is rid out the null value properties when %JSONExport method invokes. There is some default parameter are used to achieve this while exporting. You need to enable parameter in your class definition. The %JSONNULL parameter is used to export all the field and display even the property has null values. Once you have added the parameter and try export the itemdetails object

Class Samples.AllItems Extends (%JSON.Adaptor, Ens.Response)
{

Parameter%JSONNULLAs BOOLEAN = 1;Property ItemtId As%String;Property itemName As%String(MAXLEN = 100);Property itemStockNumber As%String(MAXLEN = 150);Property itemType As%String;Property itemPriority As%String;Property itemDetailData As%String(MAXLEN = 10000);
}

You need to call. If it's was declared as method. I tried the below and it works.  

<script language=cache method="montaDDList" arguments="">
    Set listaPropriedades=$SYSTEM.SQL.Execute("SELECT * from Sample.Person")
</script>

	#(..montaDDList())#

You're absolutely right.It's crucial, We really need to build it for IRIS.