Last updated year mismatch

Integrator.io
, , ,
1

Sub: {{lastExportDateTime}} always returning 2021

Hi Team,

Here is the description of what I am trying to do and which type of error I am getting;

We are trying to use Delta export type on the HTTP export step.
Where we are using {{lastExportDateTime}} expression to send
lastExportDateTime in HTTP request on export step.
But we are always getting one year back date i.e. 2021, when we are previewing the http request, we can only see today date but year is 1 years back.
We tried enabling and then running flow end to end successfully.
but that is not helping us

Thanks & Regards

Manohar

2

I am also facing the same issue.Did you find a solution?

3

@manohardevarakonda @stutiparichha I've moved this post to the "Troubleshoot custom flows" category.

4

Hi @manohardevarakonda/@stutiparichha

Currently when a delta export is previewed in the Preview panel, the preview request has the {{lastExportDateTime}} set to a dummy date which is “current date-1year”. The reason for this implementation is when {{lastExportDateTime}} is set to year-1 there are higher chances of showing sample data. This is only limited to the preview panel. However, when you run the flow from flow builder, the {{lastExportDateTime}} is the last time the flow had run.

There is an enhancement request to set the {{lastExportDateTime}} to the date which equals to "last time the flow has run". This is yet to be prioritised for development.

I hope you find this information helpful, please feel free to reach out to us if you are having any additional questions. Thank you.

Regards,

Pridhvi

5

Hi Pridhi,

How can we limit the import to a single record or the last updated record.I tried adding a product_id parameter but it does not help.

Thanks,

Stuti

6

Hi @stutiparichha207,

Please correct me if I'm misunderstood. Is it your intention to import a specific record or a single record per file?
It would be helpful if you could provide an example. Thank you very much.

Pridhvi

7

Hi, I'm experiencing this same issue, and this is not in the context of the "Preview" request, I'm getting the incorrect year sent through all the way in the HTTP request, see the debug log as example

2022-08-19T15:29:33.429Z 3bf365bbeae541f9b0cac040aece2c61 export 62daa529d861ef2e49b7ca0c
{"url":"https://us12.api.mailchimp.com/3.0/lists/f5c7ab104a/members?fields=since_last_changed&since_last_changed=2021-08-19T12:29:32+0000","method":"GET","headers":{"content-type":"application/json","Authorization":"Bearer ********","accept":"application/json"}}

8

Hey David, is this debug log from when you run the flow, or is this a debug log from a preview request in the export bubble drawer? Couple other questions. Is the flow setup to run as a delta? Has it ever exported data before? Can you post a pic of the flow and also the export bubble configuration?

Sorry for all the questions, but something is amiss.