Filter based on creation date

[former_member47135]

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>