时间戳

首页 > 解决方案 > 如何使用 SOAP 请求 XML 请求从日期到日期的字段？

api - 如何使用 SOAP 请求 XML 请求从日期到日期的字段？

问题描述

我尝试使用soap api xml将与ditetimerange条件匹配的所有数据提取到Archer平台。

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:web="http://archer-tech.com/webservices/">
   <soapenv:Header/>
   <soapenv:Body>
      <web:ExecuteSearch><web:sessionToken>6227E03F9FDCD7449FC961C7B6940C2E</web:sessionToken>
         <web:searchOptions><![CDATA[<SearchReport>
    <PageSize>9999999</PageSize>
    <DisplayFields>
        <DisplayField name="Incident_ID">15483</DisplayField>
        <DisplayField name="Alert Type">14760</DisplayField>
        <DisplayField name="Summary">14025</DisplayField>
        <DisplayField name="Alert_Source">15529</DisplayField>
        <DisplayField name="Creation Date">15518</DisplayField>
        <DisplayField name="Last Updated">15481</DisplayField>
        <DisplayField name="Application">15494</DisplayField>
        <DisplayField name="Title">15488</DisplayField>
        <DisplayField name="Urgency">15485</DisplayField>

    </DisplayFields>
    <Criteria>
        <Filter>
            <Conditions>
                <DateTimeRangeFilterCondition>
                    <Field name="Last Updated">15481</Field>
                    <BeginDate>05/16/2019</BeginDate>
                    <BeginTime>06:00 am</BeginTime>
                    <EndDate>05/16/2019</EndDate>
                    <EndTime>08:45 am</EndTime>
                    <TimeZoneId>Romance Standard Time</TimeZoneId>
                    <IsTimeIncluded>TRUE</IsTimeIncluded>
                </DateTimeRangeFilterCondition>
            </Conditions>
        </Filter>
        <ModuleCriteria>
            <Module name="Incidents">445</Module>
        </ModuleCriteria>
    </Criteria>
</SearchReport>]]></web:searchOptions>
         <web:pageNumber>1</web:pageNumber>
      </web:ExecuteSearch>
   </soapenv:Body>
</soapenv:Envelope>

问题是开始日期条件只考虑创建日期字段而不是上次更新。结果，我没有正确的结果。如果有人有想法，我是接受者:)

在此先感谢您的帮助

标签： apisoap

解决方案

I finaly find a way to solve my issue.

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" 
    xmlns:web="http://archer-tech.com/webservices/">
       <soapenv:Header/>
       <soapenv:Body>
          <web:ExecuteSearch> 
   <web:sessionToken>6227E03F9FDCD7449FC961C7B6940C2E</web:sessionToken>
             <web:searchOptions><![CDATA[<SearchReport>
        <PageSize>9999999</PageSize>
        <DisplayFields>
            <DisplayField name="Incident_ID">15483</DisplayField>
            <DisplayField name="Alert Type">14760</DisplayField>
            <DisplayField name="Summary">14025</DisplayField>
            <DisplayField name="Alert_Source">15529</DisplayField>
            <DisplayField name="Creation Date">15518</DisplayField>
            <DisplayField name="Last Updated">15481</DisplayField>
            <DisplayField name="Application">15494</DisplayField>
            <DisplayField name="Title">15488</DisplayField>
            <DisplayField name="Urgency">15485</DisplayField>
    </DisplayFields>
        <Criteria>
            <Filter>
                <Conditions>
            <DateRangeFilterCondition>
    <Operator>Between</Operator>
    <Field>15481</Field>
    <BeginValue>2019-05-16T06:00:00</BeginValue>
    <EndValue>2019-05-16T09:00:00</EndValue>
    <TimeZoneId>Romance Standard Time</TimeZoneId>
    <IsTimeIncluded>TRUE</IsTimeIncluded>
    </DateRangeFilterCondition>
            </Conditions>
        </Filter>
        <ModuleCriteria>
            <Module name="Incidents">445</Module>
        </ModuleCriteria>
    </Criteria>
    </SearchReport>]]></web:searchOptions>
         <web:pageNumber>1</web:pageNumber>
      </web:ExecuteSearch>
   </soapenv:Body>
    </soapenv:Envelope>

推荐阅读