Convert Binary to Json

[david.oliveira]

Describe the issue/error/question

Hello, I have a problem with the Move Binary Data node, I need the data to look like this in this image

and right now she’s like this.

I need to access various data and the way you are giving me the json I can only do “0.analyst_name” and it needs to be just “analyst_name”.

Anyone who can help me would be grateful.

json in the file:

[
  {
    "analyst_name": "Test",
    "analyst_email": {
      "email_send": "[email protected]"
    }
  },
  {
    "analyst_name": "Test 1",
    "analyst_email": {
      "email_send": "[email protected]"
    }
  }
]

Workflow

[Jon]

Hey @david.oliveira,

Welcome to the community

Give the workflow below a go, The main difference is in the Move Binary Data node I have told it to not set all data then used the JSON Parse option which has outputted the array under a data column which I have split out using the Item Lists node.

[david.oliveira]

Thanks for the reply, that’s exactly what I needed.