Why is {{timestamp "L"}} (or any format) throwing an error "... Missing helper: "timestamp ..."

Integrator.io
, , ,
1

I need to set a field to the current date in my Import mapping. I added the expression:

{{timestamp "L"}}

which results in the error:

Message: Could not compile handle bar "{{timestamp "L"}}" because "Missing helper: "timestamp"" .Please correct and retry

I also tried the two examples in the handlebar helper page: 

{{timestamp HH:MM:SS "America/Los_Angeles"}}

which resulted in the same error:

Message: Could not compile handle bar "{{timestamp HH:MM:SS "America/Los_Angeles"}}" because "Missing helper: "timestamp"" .Please correct and retry

I don't get it, why the error? Am I wrong to thing this helper should be available in the Import mapping context?

As a workaround I used 

{{dateFormat "L" timeStamp}}

Hopefully someone can shed some light on this.

2

Hey Steve,

We have a bug logged for this and we are fixing this in an upcoming release.

You can use `{{{timeStamp "L"}}}`(with a capital S) for now or the dateFormat helper.

3

Hi @umagarimella,

My colleague @davidgollom was telling me something about this workaround and I could swear I tried capital Stamp, but still got the error - either way, I just tried it again (per your suggestion) and indeed no error was thrown, BUUUUUUTTtt....... I do get an unexpected result:

{{timeStamp "L"}}

Yields:

2022-08-15T21:44:25-07:00

The Celigo help for the format strings shows "L" as

09/04/2020

When I use workaround:

{{dateFormat "L" timeStamp}}

I get:

08/15/2022

Which is expected. Is this a bug, or do the format strings behave differently in different contexts?

4

Hey @steveklett

Thank you for reporting this. I'm able to reproduce this. I'll log a bug for this and get it fixed in an upcoming release.

5

I should have logged something when I found that timestamp vs. timeStamp issue last year. Sorry i was lazy.