iSheets API version 2 - Common objects - iSheet view object

The iSheet view object consists of the following elements

<isheetview>

        <viewid>{iSheet view id}</viewid>

        <title></title>

        <markasdefault>0/1</markasdefault>

        <emailview>0/1</emailview>

        <columns>

            list of column objects

        </columns>

        <viewsortorder>

            <sortorder columnid="{column id}" ordertype="1" sortposition="1"/> (ordertype [1 = ASC, 2 = DESC])

            <sortorder columnid="{column id}" ordertype="2" sortposition="2"/> (ordertype [1 = ASC, 2 = DESC])

        </viewsortorder>

        <viewfilter>

           list of rows of common object

        </viewfilter>

</isheetview>

For JSON use the following format

{
    "title": "TEST123 - to delete",
    "markasdefault": 0,
    "emailview": 0,
    "columns": {
        "column": [
            {
                "columnid": 12131
            },
            {
                "columnid": 12143
            },
            {
                "columnid": 12138
            }
        ]
    }
    "viewsortorder": { 
        "sortorder": [
            {
                "columnid": 12131,
                "ordertype": "1",
                "sortposition": "1"
            }
        ]
    },
    "viewfilter": {
        "row": [
            {
                "columnid": 12136,
                "operatorid": 8,
                "oprand": "Test Me",
                "logicaltype": "1",
                "sheetfiltervaluetypeid": "0"
            }
        ]
    }
}

Note:

1. sortPosition [1 = first column sorting, 2 = second column sorting]

2. sortOrder (columnID) : sort order supports below column types

Note:

A sample for Normal iSheet

<isheetview>

    <viewid>100</viewid>

    <title>iSheet view 1</title>

    <markasdefault>1</markasdefault>

    <emailview>0</emailview>

    <columns>

        <column>

            <columnid>20</columnid>

            <type>5</type>

            <name>Custom column 1</name>

            <section>17</section>

        </column>

    </columns>

</isheetview>

A sample for Task custom metadata iSheet (TMD) (applicable from Collaborate 5.0)

<isheetview>

    <viewid>100</viewid>

    <title>iSheet view 1</title>

    <markasdefault>1</markasdefault>

    <emailview>0</emailview>

    <columns>

        <column>

            <columnid>20</columnid>

            <type>5</type>

            <name>Custom column 1</name>

            <section>17</section>

            <columntype>ISHEET_CUSTOM</columntype>

        </column>

        <column>

            <columnid>5</columnid>

            <type>0</type>

            <name>Status</name>

            <columntype>TASK_STANDARD</columntype>

        </column>

    </columns>

</isheetview>

Note :

1. If iSheet is not TMD - No need to defined '<columntype>' in request xml.

2. If iSheet id TMD, then '<columntype>' is mandatory for every column.

3. for 'columntype = TASK_STANDARD'.. no section id will be there. because of those columns are not iSheet's custom columns.