Problem with passing json with nested arrays

Hey there @HyKamil!

I‘m not 100% certain from what I’m seeing in the screenshots but, it looks like the Code step is outputting the category Paths as line items rather than individual fields for each category. So it seems like you’ve got at least two line items that are being output in the selected Data Object Data Category Path field (category 7 and 3).

I’m guessing that you’re looking to select the categories individually as separate fields, is that correct?

If so, what you could try here is to add a Formatter (Utilities > Line-item to Text) step directly after the Code step. That would convert the line items to text and output all line item elements into separate fields. You can find out more about converting line items here: Convert line items into text strings

Hopefully that helps! 

Ok, I created new flow and was able to add 4th and 5th step but it not solved the issue entirely.

Let me start again with the issue as maybe there is a simple way to do this.

My flow is rather simple: receive JSON → map it → send new JSON.

I started with 2 steps

1. Trigger Webhook ->Catch Hook
2. Action Webhook → POST

Images below are my test in first step (looks ok) than mapping in second step. I can already see at this point that recognition of field is wrong for Category ID. I don’t have any issues with filed like dataObject.general.o_key or dataObject.data.color, but when I want  to get dataObject.data.category.id the problem starts.

Then if I proceed what I will get on ma endpoint  JSON in left column, instead of what I want in right column ( I manually eddied right column)

{
  "object": {
    "data": {
      "category": {
        "id": "3,7",
        "type": "/Categories/Electro,/Categories/Light"
      },
      "color": "white"
    },
    "name": "Led Bulb"
  }
}

{
  "object": {
    "data": {
      "category": [
        {
          "id": "3",
          "type": "/Categories/Electro"
        },
        {
          "id": "7",
          "type": "/Categories/Light"
        }
      ]
    },
    "color": "white"
  },
  "name": "Led Bulb"
}

So another flow that I created is based on solutions mention before, on this forum plus @SamB suggestion.

New flow looks like this:

This is what I have in me hook on the test:

then JavaScript

code:

var obj = {},
jsondata = JSON.parse(inputData.rawjson);
for(var y in jsondata.dataObject.data.category[0]){

   obj[y] = [];
}
for(var x in jsondata.dataObject.data.category){
   for(var y in jsondata.dataObject.data.category[x]){
       obj[y].push(jsondata.dataObject.data.category[x][y]);
   }
}
obj.webhook = jsondata;
return obj;

Then I add two formatters for two fields Category Id and Category Path. I understand that one filed - one Formatter.

So after test in one step I have this:

Last step is Web Hook with POST method and mapping all the things.

However I still cannot or don't know how to  create array in JSON. I cannot give the same name and best I can do is JSON bellow. Still category is not a list but fields are separated.

Map:

and final JSON

{
  "object": {
    "data": {
      "category": {
        "id": "3",
        "id1": "7",
        "type": "/Categories/Light",
        "type1": "/Categories/Electro"
      },
      "color": "white"
    },
    "name": "Led Bulb"
  }
}

Any ideas ?