cancel
Showing results for 
Search instead for 
Did you mean: 

HCI: Dynamic filter for SF Query and use results of that for another query

rawinder2489
Explorer
0 Kudos

HCI: Dynamic filter for SF Query.

I have a requirement where I need to pull extracts from SF where lastModifiedDate is used to pull latest records from SF. Below is my SF Query.

$select=externalCode,approvalStatus,cust_Endtime,cust_Starttime,endDate,fractionQuantity,lastModifiedDateTime,startDate,timeType,userId&$filter=lastModifiedDateTime ge datetimeoffset'${property.SystemDate}'. I have tried with SF Adapter but i am not getting data from SF. Can anyone provide me the solution for this issue.

Accepted Solutions (0)

Answers (2)

Answers (2)

jorgeh
Explorer
0 Kudos

Hi

your property ${property.SystemDate} should have next format 1976-10-08T03:50:38Z

Kr

jorgeh
Explorer
0 Kudos

Hi

You can use next source code

String old_timestamp;

String sfql;

old_timestamp = "1976-10-08T03:50:38Z";

sfql = "&\$filter=lastModifiedDate ge datetimeoffset'" + old_timestamp + "'";

This is the format of feature you have choosen

Kr

rawinder2489
Explorer
0 Kudos

Hi Jorge Hernandez,

So what exactly i should give for LastModifiedDate. Could you please suggest.