Timezone issue - create json module

[NunuNana]

I want to create a json string with the dates shown in the iterator. However, when doing that, the json module doesn’t consider the timezone anymore. How can I have the timezone (GMT+03:00) included in all the dates shown in the json string?

[L_Duperval]

Maybe use the formatDate() function. It allows you to specify the timezone as an optional parameter.

L

[NunuNana]

Thanks!I also thought about that. But this is how the modules look like. Where would I do the formatting?

[samliew]

You can do the formatting in the Create JSON module fields that you have set up (NOT while editing the data structure as shown in your second screenshot).

[NunuNana]

Thank you! I did this:

But I’m getting only one start-end pair with this method, even though there are two (see iterator module above)

[L_Duperval]

What are you getting out of your iterator? The JSON sees only one input bundle which may be why you only get one bundle output.

L

[NunuNana]

I’m getting the busy times from my calendar in start-end pairs and I want them in a json string next. Actually the json module does see multiple bundles as shown here:

@NunuNana

Screenshot 2024-07-15 at 03.31.591188×702 116 KB

But after using the formatDate function it creates a json string for only one start-end pair.

[L_Duperval]

Use a Parse JSON instead of Create JSON:

L

[L_Duperval]

Sorry, ignore my previous response. Where is the formatDate used and what are the results? It’s unclear from the screenshots. I have the impression you’re showing the JSON screenshots but we’re not seeing the iterator screenshots. It’s important (for me, anyway) to see the input and the output, not just one or the other.

I

[NunuNana]

This is the iterator module input and output:

[NunuNana]

This is the create json module input and output without “formatDate”:

[NunuNana]

And this is the json module input and output with “formatDate”:

As you can see, it only outputs one start-end pair, when I use the formatDate function.

[NunuNana]

What I want is the json module to output a json string with all the bundles it receives from the iterator. Right now, the problem is that it’s outputting it in UTC format, which messes up the following flow. I need the dates and times in the json string to include my timezone.

[L_Duperval]

Hi,

OK, I’m not able to make it work. I’m pretty sure the solution is rather simple.

Hopefully one of the ninjas here can make it work.

L

[NunuNana]

I figured it out! Thanks!

[L_Duperval]

Great! Are you willing to share your solution?

L

[Audrey_Bai]

Hey I am running into the same issue, can you share your solution? Thank you