cancel
Showing results for 
Search instead for 
Did you mean: 

Filter based on creation date

Hi,

We have a scenario to update pending leave requests in Successfactor through CPI if the difference of the current date and creation date is more than 10 days.

Output XML from request replay. Now we want filter based on 10 days logic.


            <m:properties>
                <d:externalCode>254642d7508e47f5a5aaf667e4dcf8ce</d:externalCode>
                <d:approvalStatus>APPROVED</d:approvalStatus>
                <d:createdDate m:type="Edm.DateTime">2022-07-13T23:21:19</d:createdDate>
                <d:timeType>CL_Ind</d:timeType>
                <d:comment m:null="true"></d:comment>
                <d:workflowRequestId m:type="Edm.Int64">717674</d:workflowRequestId>
                <d:userId>60425</d:userId>
                <d:startDate m:type="Edm.DateTime">2022-06-30T00:00:00</d:startDate>
            </m:properties>
        </content>
    </entry>
    <entry>
    
            <m:properties>
                <d:externalCode>7d8e44e35edc41aa8769731c69c0387a</d:externalCode>
                <d:approvalStatus>APPROVED</d:approvalStatus>
                <d:createdDate m:type="Edm.DateTime">2022-08-16T06:39:34</d:createdDate>
                <d:timeType>CL_Ind</d:timeType>
                <d:comment m:null="true"></d:comment>
                <d:workflowRequestId m:type="Edm.Int64">744581</d:workflowRequestId>
                <d:userId>60425</d:userId>
                <d:startDate m:type="Edm.DateTime">2022-08-12T00:00:00</d:startDate>
            </m:properties>
        </content>
    </entry>
    <entry>
      
            <m:properties>
                <d:externalCode>64a1c24e95214c9e8d38938542225bdf</d:externalCode>
                <d:approvalStatus>PENDING</d:approvalStatus>
                <d:createdDate m:type="Edm.DateTime">2023-04-23T05:51:59</d:createdDate>
                <d:timeType>PL_Ind</d:timeType>
                <d:comment>Sure</d:comment>
                <d:workflowRequestId m:type="Edm.Int64">834145</d:workflowRequestId>
                <d:userId>60425</d:userId>
                <d:startDate m:type="Edm.DateTime">2023-04-14T00:00:00</d:startDate>
            </m:properties>
        </content>
    </entry>
</feed>

Accepted Solutions (0)

Answers (0)