Why is the Delta date field mandatory in Salesforce Delta Export?

Integrator.io
1

Hi ,

I’m trying to use Delta Export on Salesforce. But i don’t want to use the dropdown selection and want to provide custom export query using export time.

I have followed the method mentioned in post : Override Automatic Filter on a Delta Export?

But, the Date Fields to use in Delta search is mandatory and i’m not able to save.

is this expected or i’m doing something wrong.

select Id
from Object  where 
and (Parent_Object.LastModifiedDate <= {{data.currentExportDateTime}} or Object <= {{data.currentExportDateTime}})

image
image887×566 32.1 KB

can anyone help me on this?

2

You have to use {{data.lastExportDateTime}} somewhere

3

@tylerlamparter , Thanks for the hint. It worked

I do have a question. I noticed all i had to do was to add {{data.lastExportDateTime}} in comment in the query section and the required condition removed on Delta field. It seems unnecessary to have such restriction that {{data.lastExportDateTime}} has to be present in data export

image
image858×657 36.4 KB

1 Like
4

Hey Varun, this is good feedback for the Product Feedback channel. Probably for 99% of the time, users only need the multi-select drop down of dates, but we could think of something better here for both those users and power users.

5

I've had similar situation in an HTTP lookup once; I just threw the data.lastExportDateTime in an fake URL parameter (e.g., /path?this=that&ignore={{data.lastExportDateTime}})