iSheet advanced search API query

27334

Hi,

I am trying to use the API to query an iSheet and only return items created since a specific date / time. 

The column I am querying is a date time type:

<headcolumn sequence="2" columntypealias="SHEET_COLUMN_TYPE_DATE_AND_TIME" columntypeid="5" columnid="4291">
            <columnvalue>
                <![CDATA[Created date

            </columnvalue>
        </headcolumn>

E.g. 1 record has the value:

<column sequence="2" attributecolumnid="4291">
                <rawdata>
                    <date>
                        <![CDATA[2019-08-14]]>
                    </date>
                    <time>
                        <![CDATA[12:11:42]]>
                    </time>
                </rawdata>
                <displaydata>
                    <value>
                        <![CDATA[14 Aug 2019 12:11]]>
                    </value>
                </displaydata>
            </column>

Using the advanced search (https://collaborate.highq.com/sitepoint/viewWikiPage.action?metaData.siteID=714&metaData.wikiID=26409)I was able to use the API to check for items created since a specific date but dont see a way to use the time part e.g. can I say all records from 14 AUG 2019 13:00:00.

<filterdata>
    <data>
        <!-- date time type column -->
        <column attributecolumnid="4291">
            <rawdata>
                <fromdate><![CDATA[14 AUG 2019]]></fromdate>
            </rawdata>
        </column>
    </data>
</filterdata>

I tried adding a <fromtime> object but it didnt do anything, is this possible?

]]>
  • Chris Doig, in short no. Search request doesn't expose the time component, same as the Collaborate Adv. Search UI. Your only option is to post-filter the results.