How do I seed the lastExportDateTime when using a Delta export type?

[Daniel_Wilson]

When I set up a data source with a basic HTTP API and I select the Delta export type, the {{lastExportDateTime}} is a critical parameter.

But where can I set a starting value for it?

I would get some data to let me start developing my transformation if I could use an earlier date.

Thanks!

[tonycurcio80 (Tony Curcio)]

@Daniel_Wilson … there was a discussion of a few different options on that here. Hope this helps.

How to reset flow run time to restart a Delta export type

Alternative to @scotthenderson's and @mattgraney's suggestion, which would work, you could potentially make this a bit more automated. This does assume that the global updates you are making are to fields that shouldn't every trigger the flow to send an update even if not mass updated. I had a similar use case at my last company where some fields would get updated daily, but those fields had no reason to trigger updates to external sources. First option could be to add search criteria to your …

[nuriensing]

You can add Handlebars expressions to the URL in Celigo to manipulate date, including using custom helpers like date add substract, as referenced in the Celigo documentation:
Celigo dateAdd function

[Daniel_Wilson]

OK, that looks like a promising workaround for development. Thanks!

[Daniel_Wilson]

Thanks!

The first response in that thread appears to be what I’m looking for. I’ll try to follow those instructions.

[nuriensing]

@Daniel_Wilson so you mean running it manually and then selecting a custom date right?

[tylerlamparter]

To add, typically an application won’t respond with an error when no results are found as it will just respond with an empty array or return no data with a 200 code. When this happens, we provide a pop-up to the user saying “We didn’t find anything, would you like to use a different date?” In this case, since the application is actually throwing an error back, that doesn’t occur.