Double issues : one with \" in JSON array and another with Date formatting

[Atelier_mesure]

Hello,

Issue 01

I am using the “Create Json” object, with an Array called “Product_Tags”.

When mapping with [“1”,“2”] makes formats the array like this :

How can I avoid the automatic echappement ?

Issue 02

I need to output a date in a specific format “YYYY-MM-DD HH:mm:ss”
I am pulling the data from a google sheet doc where the date is “YYYY-MM-DD”

I use for formatDate formula in a Array aggregator module

The output is not formatted properly

So in my Create JSON module, the date is showing like this

Many thanks

[samliew]

Welcome to the Make community!

@Atelier_mesure

How can I avoid the automatic echappement ?

You’ll have to use an iterator + array aggregator module, or convert your text 1,2 into an array like this:

{{ split("1,2"; ",") }}

@Atelier_mesure

I use for formatDate formula in a Array aggregator module

You have to parse a date-like string type into a date type, by using the built-in function parseDate, before you can use formatDate.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate
• Discord Server – join us in live chat for fans of Make!

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

[Atelier_mesure]

Thank you a lot @samliew

I was able to fix the array issue with split(

However, I am still struggling with the dateformat, I have tried with this formula : formatDate(parseDate(“date”;YYYY-MM-DD);YYYY-MM-DD) and still had the HH:mm:ssss indication.

As you can see I have even tried to make it manually

and the output still contains hh:mm:ssss

Any idea of what I am doing wrong ?

Thank you

[samliew]

No problem, glad I could help!

1. If anyone have a new question in the future, please start a new thread for each question. This keeps the forum organised and makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

others can save time when catching up with the latest activity here, and

• allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

samliew – request private consultation

Join the unofficial Make Discord server to chat with us!