Array and text aggregator to build json

[Martin_Carlsson]

Hi,

I need help creating a JSON.

Here is my starting point:

I want to return this JSON:

The blurred parts are two different email addresses, same as ‘key’ in my starting point. The starting point is what I get from an array aggregator. I tried using a text aggregator to combine the two ‘busy’-arrays for the first email key, but it doesnt work. Here is my text aggregator setup now:

Can someone help me with this?

Thanks in advance

[samliew]

You can’t use groupby if you are using a JSON in a Text Aggregator.

You also need to have the Row separator set to a comma.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.